How to get provider (storage array) name for LUN related alerts

Question

Hello All,

I have setup alert for LUN available free space alert, by default I am unable to get the provider (storage array) name in variable, I tried setup SQL query variables but it's not working as expected can someone help me.

Thanks,

DN

bakarain · Answer

Hi,

you can use the variable SQL :

${SQL:SELECT Name FROM SRM_StorageArrays WHERE StorageArrayID=${N=SwisEntity;M=StorageArrayID}}

Good luck