July 2008 - Posts
The documentation for the smsclictr.automation library (used for SMS Client Center and SMS Collection Commander) was updated.
http://smsclictr.sourceforge.net/smsclictr.automation/
Note: The Documentation.chm file should not be opened online (download first).
The technical release 1.1.3.3 is published at:
http://smsclictr.sourceforge.net/
Changes:
- FIX: "register MSXML3.dll" action fixed
- DCMScan feature added (SCCM2007 required)
Collection Commander technical release 1.3.0.2 published at:
http://smscollctr.sourceforge.net/
Changes:
- Counter for online clients added
- local Policy Import for SCCM clients added (the policy format has changed with SCCM)
- OOB (OutOfBand) Discovery feature added (SCCM2007 SP1 required)
- Run custom command feature added
Note:
There will be no WindowsInstaller Package for technical releases. The technical releases must be installed from the "ClickOnce" deployment page.
This SMS2003 Collection-Query (WQL) shows all clients where authorized security patches (authorize date > 15 days) are "applicable":
select * from SMS_R_System
inner join SMS_G_System_PATCHSTATEEX on SMS_G_System_PATCHSTATEEX.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_PATCHSTATEEX.QNumbers in (select distinct QNumbers from SMS_ApplicableUpdatesSummaryEx where SMS_ApplicableUpdatesSummaryEx.TimeAuthorized != null and ScanAgent = "Microsoft Updates Tool" and DATEDIFF(dd,TimeAuthorized, GETDATE()) > 15)
and SMS_G_System_PATCHSTATEEX.Status = "Applicable"
Caution: The authorize date will not synchronized to child sites...
Requirements: SMS2003, ITMU
A new Installation Guide for the "SMS Client Center Web GUI" can be found at: http://sourceforge.net/projects/smsclictr (HowToSMSCliCtrWebGUI.pdf).
Thanks to Sherry Kissinger, Ben Monrad and Hector Cortez for writing the Doc...