Today I got an internal email telling me that there is new Reporting Documentation for OpsMgr on Microsoft Technet.
And I also got a question about information about the SQL Schema’s of the OpsMgr Databases. In the past I’ve blogged about a tool (SqlSpec) that could help finding the Database Schema for OpsMgr databases. You can find more info at this blogpost of mine: Documenting your OperationsManager Database? Use SqlSpec!
But now you can also use the new Reporting Documentation for info on the The OperationsManagerDW Schema.
I’ve already blogged a couple of times about ways to document your Operations Manager Databases. First I showed you to use SQLSpec from ElsaSoft, a couple days ago I told you you can find more information about the OperationsManagerDW schema in the new Reporting Documentation.
And now I’m telling you, you can use PowerShell to document your Operations Manager Databases.
Today I read a blogpost on the Hey, Scripting Guy! Blog about using PowerShell to Document your SQL Database.
So I downloaded the PowerShell script from the the Script Repository and tested it in my OpsMgr environment, and it worked like a charm!
Change line number 268 with the correct SQL server in the script and you are ready to go.
Run the script with the correct SQL permissions to document all databases running on the SQL server.
Open the index.html file in the folder where the documentation is saved.
And there we have it. Our OperationsManager database documented, and of course all the other databases running on that SQL server.
Have fun using PowerShell to document your Operations Manager Databases!
Have fun learning OpsMgr & PowerShell next year again!
Here you can watch a video where Alex de Jong talks with Vlad Joanovic about OpsMgr vNext.