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