The Windows Management User Group
The original UK User Group
Established March 2006
Lionel's configmgr blog
Browse by Tags
Windows Management User Group Community blogs
Get this RSS feed
Tagged Content List
Collection Query to return systems before a specific Install / Creation Date
When creating a query that returns systems before a specific date in a collection, you may get no system records back if you had done the query like the following: Incorrect Query SELECT SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM...
Thu, Apr 21 2011
Discover your Site Discovery Methods for SCCM Clients
Had to troubleshoot various client issues today with regard to discovery methods and this query came in handy. You can run this against the primary site SQL database to find out the discovery methods (i.e. AD System discovery, heartbeart etc) that are being found by a specific client in SCCM 2007. ...
Thu, Apr 7 2011
Obtaining binary locations for your patches with the Unique IDs in SCCM
You may find yourself in situations where you may need to locate the physical location of a certain software update and or check if that has expired. However, it can get cumbersome to determine the right binary just by searching by its KB Article number in Windows Explorer on the SCCM Server. Fret not...
Mon, Jan 17 2011