I'm attempting to configure an alert for the File Size Monitor template to return the file path in the body of the message. I'm using this thread as a reference and I have no SQL experience. The goal is to be able to apply this to multiple different files/nodes without having to change or create separate alerts for each by using variables.
https://thwack.solarwinds.com/docs/DOC-175087#start=25
"This can be used to get any of the values simply changing the [Key] condition to whatever your looking for. Also make sure you set your component type in your trigger condition to 6 to avoid non-http applications sending this alert off."
${SQL:select Value from APM_ComponentSetting
where [Key] = 'Url' and ComponentID = '${ComponentID}'}
If I understand the statement in bold above correctly, I can get the value of the file path by changing it from [key] = 'Url' to [key] = 'FullPath'
I get an error, "MACRO SQL ERROR - Error converting data type varchar to bigint." when I leave it at ComponentID = '${ComponentID}'}, but if I set ComponentID = 15935 it works. Please what am I doing wrong?
Above is a snip of values in the database below is the modified query I mentioned with 'FullPath' instead of 'Url' for the key
This is what it looks like when you insert it as a variable that gives me the error.
Like I said to make it work hard coding in the component ID to this specific one (15935 vs the variable "${ComponentID}") does return the file path, but it means it wouldn't work for anything else I tried to apply this to.
