MSSQL Database Version

Purpose

The objective of this solution is to centralize the retrieval of MSSQL server versions across the environment into a single location for auditing purposes.

Associated Content

Auditing Content

Content	Type	Function
Get MSSQL Database Version	Script	The script collects the Version and Patch Level information of the MSSQL Server.
Execute Script - Get MSSQL Database Version	Internal Monitor	The internal monitor detects the MSSQL servers where the Script - Get MSSQL Database Version has not been executed within the last week.
MSSQL Database Version	Dataview	The data view showcases the version and patch level details of MSSQL Servers, acquired through the Script - Get MSSQL Database Version.
pvl_mssql_db_version	Custom Table	The custom table stores the data gathered by the Script - Get MSSQL Database Version.
△ Custom - Execute Script - Get MSSQL Database Version	Alert Template	The Alert Template executes the Script - Get MSSQL Database Version against the machines detected by the Internal Monitor - Execute Script - Get MSSQL Database Version.

Implementation

1. Import the following content using the ProSync Plugin:

   • Script - Get MSSQL Database Version
   • Dataview - MSSQL Database Version
   • Internal Monitor - Execute Script - Get MSSQL Database
   • Alert Template - △ Custom - Execute Script - Get MSSQL Database Version

2. Reload the System Cache
   

3. Execute the Script - Get MSSQL Database Version against an online Windows Machine with the Set_Environment parameter set to 1, to create the Custom Table - pvl_mssql_db_version
   

4. Configure the solution as follows:

   • Navigate to Automation → Monitors within the CWA Control Center and set up the following:
     • Internal Monitor - Execute Script - Get MSSQL Database
       • Configure with the alert template: △ Custom - Execute Script - Get MSSQL Database Version
       • Right-click and Run Now to start the monitor.