Hi
While triggering an alert for LUNs, I want to get the Storage Array Name to which an LUN belongs to. So, I have written the following query and I am able to get output in SQL Database Management Studio.
Select [SRM_StorageArrays].Name from SRM_StorageArrays inner join
SRM_LUNs on SRM_StorageArrays.StorageArrayID = SRM_LUNs.StorageArrayID
where SRM_LUNs.Name = 'zzz(LUN Name)'
But when I tried the same query as a message while configuring the action, Solarwinds is writing the query into the file instead of writing the value it retrieves from Database.
So, to troubleshoot this issue I have configured two alerts as follows:
1) alert1
- Type: Node
- Configure Action: Write to File
- Message: LUN ID :- ${SQL:Select Name from SRM_LUNs}
- Output: LUN ID :- name123
2) alert2
- Type: LUN
- Configure Action: Write to File
- Message: LUN ID :- ${SQL:Select Name from SRM_LUNs}
- Output: LUN ID :- ${SQL:Select Name from SRM_LUNs}
I want to know, why Solarwinds is unable to resolve SQL for LUN. Please help me with this case. Also, please let me know what variables are to be used in the message[while configuring alert action] for getting the LUNname, Storage Array Name.