Need all assigned alerts on the each disk volume

gattadisrikanth

Hi All,

Can some one help on this requirement we have configured disk volume alerts with the multiple threshold levels
so i would like to know which volume has what threshold level is configured and assigned disk volume alerts on a particular volume

Thanks,

Srikanth.

anmolkumar7

Hi Srikanth,

You can create a report using below query. It will give you name of node, name of volume and alert assigned to that volume.

SELECT AO.EntityCaption, AO.AlertObjectID, AO.AlertID, AC.Name, AO.RelatedNodeCaption
FROM [dbo].[AlertObjects] AS AO
LEFT JOIN [dbo].[AlertConfigurations] AS AC
ON AO.AlertID = AC.AlertID
WHERE AO.EntityType = 'Orion.Volumes'

You can add more conditions on this based on your requirement

Best Regards

AK