Need to include the instance of a perfmon counter in my alert

Question

I have a simple disk free space alert set up related to a SAM application. The alert email will already show name of the component that is down, e.g. "% Free Space", but I cannot see a variable that will show me what instance the component is associated with. In other words, its not enough to know that The component "% Free Space" is down, I also want the alert message to tell me whether it is the C, D, F, etc drive that is down. See the attached screenshot:

The Insert Variable option has a variable called "Instance Type", but this is not what I need.

Am I going to need to employ a custom SQL variable, and if so, what is the name and table location of the variable that I am searching for?

Thanks for help in advance.

zackm · Answer

Sorry, I mean the updated syntax for variables.

In this instance, assuming that your alert is set for components, I believe it would be

${N=SwisEntity;M=ComponentID}

borgan · Answer

Not sure what you mean by the proper syntax.

zackm · Answer

Try these out and see if one of them works. In my lab the APM_ComponentTemplateSetting table gave good values, but I think that the APM_ComponentSetting table would populate with any monitors where you override the template settings.

Also, you will want to replace the ${ComponentID} variable placeholder I have here with the proper syntax

SELECT [Value] FROM APM_ComponentTemplateSetting WHERE [Key] = 'Instance' AND [ComponentTemplateID] IN (SELECT [TemplateID] FROM APM_Component WHERE [ID] = ${ComponentID})

SELECT [Value] FROM APM_ComponentSetting WHERE [Key] = 'Instance' AND [ComponentID] = ${ComponentID}

Hope that works!

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

* LinkedIN: Loop1 Systems
* Facebook: Loop1 Systems
* Twitter: @Loop1Systems