• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 89
  • Last Modified:

Using powershell to extract data from an SQL Server 2008 R2 custom report


Modified the SQL Server 2005 Performance Dashboard Reports https://www.microsoft.com/en-au/download/details.aspx?id=22602 to work with SQL Server 2008.

How do I use PowerShell to call and extract data from these custom reports?

There is no reporting services model on my server so it can't be utilized.

Any assistance is appreciated.

Thank you.
1 Solution
Barry CunneyCommented:
I would advise to try the following approach:
Start up a SQL Server Profiler session to trace SQL against the server.
Then run the Performance Dashboard Report and afterwards examine the SQL logged in Profiler.
This may give an idea what SQL Server looks at to get the raw performance data - it is possibly some sort of system tables/views.
Then use Powershell Invoke-Sqlcmd cmdlet to execute similar SQL against these system tables/views to get the performance data.

Also please look into Powershell SMO for some ideas of interacting with SQL Server.
ZackGeneral IT Goto GuyAuthor Commented:
Cheers for the input looking into Powershell SMO now.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now