Home Forums SQL Server 2008 SQL Server 2008 - General How to Graph SQL Server Data from a PowerShell Script RE: How to Graph SQL Server Data from a PowerShell Script

  • October 21, 2012 at 6:18 pm

    #1551201

    shew (10/12/2012)

    Jeff Moden (10/12/2012)

    You do't need to have MS Office installed on the server to do what I suggest. You would use the spreadsheet from your (or a user's) desktop as if it were a 3rd party app (which it is) to access "External Data" and plot it.

    Thanks, Jeff.

    I think understood what you meant. In certain circumstances, we already do what you suggest.

    However, we are a hosting facility with scores of VLANs and VPNs, and we do not necessarily allow firewall connections to reach the remote data. I need something that works totally on the remote server, without any dependencies on my local desktop.

    Sorry for the late reply. Maybe SSRS?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)