Monday 17 August 2015

SCCM Report Site System Status


Select Distinct

SiteCode,

Role,

'Status' = Case

When Status = 0 Then 'OK'

When Status = 1 Then 'Warning'

When Status = 2 Then 'Critical'

Else ' '

End

From v_SiteSystemSummarizer

0 commenti:

Post a Comment

Give me you feedback!