SQL database name or instance in the alert about Logical Disk

[clover]

Hello. Please help.
SQL server monitoring.
Task: If alert "the queue on disk X: is too high" is sending, the name of SQL database located on it is including to message. Like "the queue on disk X: is too high ; Server1\instance2"

Disks are determining by Discovery rule.

[clover]

help please

[ArtemK]

you either need to write your own discovery, which will supply info about SQL instance on specific disk, or you can just stop using built-in discovery and add item manually for all your drives + add some info about SQL instance to trigger name for that item.

[clover]

Artem, thank you
I would like to create " the discovery that supply info about SQL instance on specific disk". I have no idea how to do it.
I have discovery of instances, and then some Perfmon keys. This is usual basic staff about SQL.
In my case I guess I need a macro, but as I dummie, I have no idea even how to google my query.

Please help

[ArtemK]

Check how to write custom LLDs there. You probably need to write script using powershell/vbs, that will discover SQL instances and will check which drive those instances are using and then report that data to zabbix.

But what if some databases are using filegroups with data files on another disks? Custom script could be overkill in your situation, if you don't have a lot of sql servers/instances.