SCCM Client Status report.

SCCM Client Status report.

SELECT S.Name0 as 'Computer Name', S.User_Name0 as 'User Name',
case when S.Decommissioned0='0'
then 'Not Decommissioned' when S.Decommissioned0='1'
then 'Decommissioned' end as 'Decommissinoed Status',
S.Last_Logon_Timestamp0,
Case when CS.ClientActiveStatus='1'
then 'Active' When CS.ClientActiveStatus='0'
then 'Inactive' end as 'Client Active Status'
FROM v_R_System S inner Join v_CH_ClientSummary CS on S.ResourceId=CS.ResourceID