Property source per database
Is it possible to create a custom property source per database when monitoring SQL? For example a simple jdbc select query that populates a custom property?
Forum Discussion
4 hours ago, Stuart Weenig said:db instance != lm instance
You're using the word instance to refer to the SQL instance. I'm using it to refer to the LogicMonitor resource instance. Your "resource" (aka device) has children on it. Each child is an instance. Each CPU is an instance, each disk is an instance, each NIC is an instance, RAM is an instance, open TCP/UDP ports are each instances, etc.. So, if you're monitoring a server, you will have one or more LogicMonitor "instances" associated that server in LogicMonitor as a child of that object. For databases, you'll have usually a LM instance per database. All of this depends on the details of the databases as they show up in LogicMonitor under the device. What is the DataSource that is currently showing the databases in LogicMonitor (or are the databases not yet showing up as children under the server)?
Gotcha, the children indeed are populated by the Microsoft_SQLServer_Databases datasource. The thought originally was to use a datasource but since the need is to use strings, the thought went to properties. For example create a property per SQL database that is populated by something simple like "select version from versions"
