Due the hard readability of the CMK plugin for mssql.vbs and Jobactivities I have created two powershell based Plugins with the same output of the original ones. Both scripts create the same output like the vbs scripts. (Not guaranteed, but tested with several different SQL servers)
I have uploaded them to github at
Advantage:
- Devided the output to functions
- Faster and more realiable execution (We had often short-time alarms when using the vbs script due timeouts)
Disadvantage:
- The execution policy has to allow scripting
- SQLPS has to be installed (Usually automatically done during the SQL Server installation)
Untested:
- Connection with SQL Server Credentials (Only Windows Authentication tested)
Feel free to use this script