Month: May 2012

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 […]

TechFuseMN – 2012

I will be speaking at TechFuseMN on Thursday May 17th.  Here are links to a couple of the SCCM 2012 tools that I will be using. Right Click Tools – More Right Click Tools (since I have no idea how to get the above one’s to work!)   – RegKeyToMOF – Config Manager […]