?
Solved

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

Posted on 2016-08-17
2
Medium Priority
?
79 Views
Last Modified: 2016-08-17
Heyas,

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.
0
Comment
Question by:Zack
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 2000 total points
ID: 41759139
Hi
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.
0
 

Author Closing Comment

by:Zack
ID: 41760348
Cheers for the input looking into Powershell SMO now.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
In this post we will be converting StringData saved within a text file into a hash table. This can be further used in a PowerShell script for replacing settings that are dynamic in nature from environment to environment.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question