• Thu, Apr 21 2011

    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.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client FROM SMS_R_System WHERE SMS_R_System.CreationDate < "21/04/2011...
    • Thu, Apr 7 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. select ssaa.SMS_Assigned_Sites0, sd.Itemkey, sd.name0, sd.SMS_Unique_Identifier0, sd.client0, sd.client_Type0, dia.AgentSite...