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

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.