when i want to monitor the hard desk " volumes" if an alert send an e-mail that c:// is 20 G and only 1 G is free... can i show all the partitions for the Node with statistics if an alert been sent ?
you mean in the alert?
yes you can, you would first have to create custom sql macros that will filter to the data you want.
custom sql queries can be embedded into alerts like this:
${SQL:"your sql query here"}
Yes in Alert . for say Server 1 c: is 1 gb free however D / E is free 100 GB each i want to send that information included in Alert all drives / and status of these devices .
any generic sql you have ?
Anyone can assist on this please need SQL query example .
Regards
GT
I attempted to create an SQL query for this through the Database Manager and it returned all the information pertaining to a specific node. However, when inserting it into an alert message, only the first volume/partition from the results was displayed. Even then, only the first column of the first result was returned.
I believe, by design, the alert engine will only return a single value from the first result of an SQL query. With that in mind, I don't think it's possible to accomplish this but hopefully someone will post something that proves me wrong.
The closest thing that I could suggest as an alternative would be to include a link directly to the corresponding node.
