The Management Pack for SCOM uses certain default SQL queries to collect SCOM data and discover SCOM objects. These queries are modified with each version of the Management Pack.
If you choose to modify the default queries at your own risk, they can be found within the following template properties files, which are located at $VCOPS_BASE/user/plugins/inbound/msscom_adapter3/conf/:
- sql_db.properties.template – contains default queries for the Database source database type
- sql_dw.properties.template – contains the default queries for the Data warehouse source database type
When modifying queries, you will want to re-name the files by removing the .template portion of filename, and then stop and restart data collection for the adapter instance in order for the new properties to take effect.