SCCM Client Inventory and WSUS Scan state

Here is a view that you can use to see SCCM Client inventory and WSUS scan state information. CREATE view [dbo].[v_SCCM_Health_Check] as select distinct a.name0 as ‘MachineName’ , a.itemkey , a.operating_system_name_and0 as ‘OperatingSystem’ , os.CSDVersion0 as ‘OS_ServicePack’ , a.client0 as ‘SCCM_Client’ , a.Client_Version0 as ‘SCCM_ClientVersion’ , case when a.User_Name0 like ‘%\%’ then substring(a.User_Name0,charindex(‘\’,a.User_Name0)+ 1,charindex(‘\’,a.User_Name0)) else […]