Last Friday I had the chance to show the Export-DMVInformation module to the Dutch Powershell user group. After the presentation I got a couple of suggestions and wanted to put them in place them into the module.
- Possibility to execute the module using the pipeline
- Get all the databases in one statement by assigning the value “ALL” to the database parameter.
- Replaced messages with verbose
Changes 1 and 2 reduce the amount of time needed to get information from multiple instances and multiple databases. Before you had to execute the module in a external loop and for each database . Now you can get the information from all the databases across multiple instances in a single line!
'server1', 'server2' | Export-DMVInformation -database 'ALL'
Change 3 gives the ability to choose whether to show all the messages or not. Use the switch “-Verbose” to see the various messages.
An example how the new module works is shown below:
Please take a look how to install or use the module on the module page.