TTech

is there a guide to creating reports anywhere? If I can get the groundwork I can take the time to build what I want.

I am trying to create a report that lists patch compliance by machine. It would be similar in scope to the standard compliance 3 report Update list (per update). I have no background in SQL and my attempts so far have not been successful. I would like it to take in a collection and update list. I would like it to output something similar to this. Where missing = patches that are required in the update list that are not installed. Where Total is the total number of patches in the list. Compliant just needs to be a percent of the first 2. I would like this to happen for each computer in the collection. Computer Name Missing Total % Compliant Collection ID WKS01 (4) (174) 97.8% ABC000014 WKS02 (8) (174) 95.6% ABC000014 Any help would be appreciated.

I am new to SCCM patch management. I am deploying patches and they deploy fine on most of my systems. All of my systems run Office 2003 and have "Compatibility Pack for the 2007 Office System" installed. My problem is the client agent on some systems only sees the need for the 2003 version of the patch. The reports show that it does need both the 2003 and 2007 versions. Other systems have both versions. 1 example of this is MS10-87. In the report I see it requiring "MS10-087 2289158 Security Update for Microsoft Office 2007 System (KB2289158) " and MS10-087 2289187 Security Update for Microsoft Office 2003 (KB2289187). I have tried forcing a software updates scan cycle, software updates deployment evaluation cycle, a software inventory cycle, and a machine policy retrieval & evaluation cycle. None of those have triggered the system to see the need for the 2007 version of the patch. I would appreciate any help or insight as to why this is happening and how to fix it. Thanks