collection – NINet.org

SCCM Patch Compliance Reports

April 3, 2012November 20, 2013 Ryan 51 Comments

Updated: 2013-11-20 – Fixes for rdl files and 2012 report, I’ve edited the RDLs but I have no infrastructure currently to test on so feedback is welcome.

I was watching SCCM Guru Episode 9 with Garth Jones, when I saw in his powerpoint presentation two reports for patch compliance that I liked the look of. So I decided to see if I could emulate the reports, I will say here having only seen the final product in his slide my reports will look similar to his, and may even share code, however I have not seen ANY of his code so any similarities here are purely coincidental and not me just copying his code and taking credit.

Deployment Management Report

February 28, 2012March 20, 2013 Ryan Leave a comment

Sorry it’s taken so long but here is my 1st post (of many) since my change of Job.

In my new environment machine history isn’t retained upon a machine rebuild, so how do I determine what a machine had before it was rebuilt? Well there is no “easy” answer to this, the company historically used a vbs script to diff the uninstall reg key against a list of standard or core applications. This worked to some extent but was far from perfect and could result in very large lists of applications that were not even installed by SCCM.

Forefont Endpoint Protection Query Details

February 7, 2011March 20, 2013 Ryan 2 Comments

Those of us that installed FEP 2010 are no doubt annoyed that we cannot see the details of the queries used by SCCM to populate the FEP created collections.

The following will require acess to the SQL instance that SCCM uses as the querys are to be executed driectly on that instance.

SCCM restrict collection membership

September 8, 2010March 20, 2013 Ryan Leave a comment

The snippet allows one to create a collection containing objects that are in some OUs but NOT IN another collection