I have a resource on my home page that displays any server that is low on drive space. this is pulled from an alert called Server Volume 95% Trigger. I have added 2 custom volume properties called INC_ and Volume_Exception. Can one of you please help me modify the code below to show the 2 new fields? The code below shows:
Server Volumes Less than 5% Free
Live Alerts
| AlertName | ServerVolume | TriggerTime |
| Server Volume 95% Trigger | msdcvc01-C:\ Label: 814e178 | 11/6/2013 11:06:05 AM |
| Server Volume 95% Trigger | msdccs01-D:\ Label:Data d42cdc2a | 9/9/2013 9:34:38 PM |
| Server Volume 95% Trigger | msdcin01-C:\ Label: a4147b48 | 11/4/2013 12:11:01 AM |
| Server Volume 95% Trigger | MSDCPFDATA01.Lighthouse.hhc-G:\ Label:New Volume 44ee9019 | 8/30/2013 6:42:08 PM |
Select Name AS AlertName, ObjectName AS ServerVolume, TriggerTimeStamp AS TriggerTime
From Orion.AlertStatus s
Join Orion.AlertDefinitions d on s.AlertDefID = d.AlertDefID
Where Name = 'Server Volume 95% Trigger'
I want it to show:
Server Volumes Less than 5% Free
Live Alerts
| AlertName | ServerVolume | TriggerTime | VolumeException | INC# |
| Server Volume 95% Trigger | msdcvc01-C:\ Label: 814e178 | 11/6/2013 11:06:05 AM | Yes | INC12345 |
| Server Volume 95% Trigger | msdccs01-D:\ Label:Data d42cdc2a | 9/9/2013 9:34:38 PM | No | |
| Server Volume 95% Trigger | msdcin01-C:\ Label: a4147b48 | 11/4/2013 12:11:01 AM | Yes | INC67890 |
| Server Volume 95% Trigger | MSDCPFDATA01.Lighthouse.hhc-G:\ Label:New Volume 44ee9019 | 8/30/2013 6:42:08 PM | No | |
