I'm an IT professional with over fourteen years of experience and since 2000 I've been working with Microsoft Infrastructure. I'm post-graduated in Computer Network and Telecommunications and Microsoft Certified Professional (MCP, MCSA Security, MCSE Security, MCTS, MCITP, MCT and MVP). I work as Technical Consultant mainly involved in Microsoft Security and System Center Configuration Manager solutions
I was awared MVP status by Microsoft in 2010 for System Centre Configuration Manager
Hi All,few days back i was requested by a client to get a compliance list of a specific software update...fine..and easy...i tought...as it is SCCM 2007, I could use Compliance 2 - Specific software update, but unfortunatelly, the SU i was trying to get the compliance is not published via WSUS (is one of those you have to request through MS website)...in this case, how could i try to get it?!?!?!!?1st i was trying to get it using SQL on the server, but it did not help, in this case, i went to the client and i discovered that Windows keeps it on the WMI Class win32_reliabilityRecords...2nd, how to get it?!?!?! if i was going to change the Hardware Inventory, i had to raise a change request and as we're in the midle of olympics, only emergencial changes was going trough...in this case, hw inventory was NO...and after breaking my head, i requested help from my MVP friends and Kim Oppalfens said 1 word: DCM...it was enough and help me a lot...to achieve this, i had to
1- Create a Configuration Item to query the WMINamespace: root\cimv2Class: win32_reliabilityRecordsProperty: ProductNameWQL Query WHERE clause: sourcename = 'Microsoft-Windows-WindowsUpdateClient' and ProductName = '<PUT HERE THE PRODUCT NAME>'
2- Created Baseline
3- Assigned baseline to the collection i wanted...now was easy...i used the report Summary compliance by configuration baseline and my job was done :)