MSSQL Instances Auto Property Override

We have a Windows server with multiple MS SQL Instances running, but only want to monitor 1 instance. I have added the custom property: mssql.sql_server_instances with the value of the instance in this case 'SQL2016DEV' however it doesn't appear to be overriding auto property (auto.sql_server_instances) the MS SQL Dbs that are being monitored or alerted on.

I am going to the root of the device that, then the Info Tab and then clicking the cog above the custom property table, scrolling to properties and adding the custom property mssql.sql_server_instances in there. Is this the correct method?

Cheers!

Laurie Street

Posted 4 years ago·Last reply 4 years ago

1 comment

LM User

·4 years ago

Assume the main DS you're having difficulty with is Microsoft_SQLServer_Databases, that method should work because of this line:

<span class="pln">def sqlInstances </span><span class="pun">=</span><span class="pln"> hostProps</span><span class="pun">.</span><span class="pln">get</span><span class="pun">(</span><span class="str">"mssql.sql_server_instances"</span><span class="pun">)</span><span class="pln"> </span><span class="pun">?:</span><span class="pln"> hostProps</span><span class="pun">.</span><span class="pln">get</span><span class="pun">(</span><span class="str">"auto.sql_server_instances"</span><span class="pun">)</span><span class="pln">  </span><span class="com">// override sql instances with manual instances</span>

Take it back to the source and test active discovery at the datasource to see if you get the same behavior. If you're still getting more than you wanted, I would next take the script to the script debug console and flip the debug boolean to true. That should give you more output to help figure out what is happening inside the script and where the problem might be.

1	SUYASH GAIKWAD
2	NA Nazmeen Ali
3	DK Deepak Kumar
4	PG Phillip Green
5	SS Sean Staats
6	AH Arno haverlach