System Center Configuration Manager (SCCM) is a powerful tool used by IT administrators to manage large groups of computers running various operating systems. One of its features is the ability to create query collections, which are groups of devices or users that meet specific criteria. In this article, we will focus on creating a query collection for computers that have not updated their hardware information for the past 30 days. This is particularly useful for monitoring and ensuring that hardware inventory is up-to-date, which is critical for asset management and planning.

Examples:

1. Opening the SCCM Console: Open the SCCM console and navigate to the “Assets and Compliance” workspace.

2. Creating a New Device Collection:

   • Right-click on “Device Collections” and select “Create Device Collection”.
   • Enter a name for your collection, for example, “Computers with 30 Days Old Hardware Information”.
   • Choose a limiting collection if necessary (e.g., All Systems), and click “Next”.

3. Defining the Query Rule:

   • On the “Membership Rules” page, click “Add Rule” and select “Query Rule”.
   • Provide a name for the rule, such as “30 Days Old Hardware Info”.
   • Click “Edit Query Statement” to open the “Query Statement Properties” dialog.
   • In the “Query Statement Properties” dialog, go to the “Criteria” tab and click on the “Star” icon to create a new criterion.
   • In the “Criterion Properties” dialog, click on “Select”.

4. Building the Query:

   • In the “Select Attribute” dialog, choose the following:

     • Attribute class: System Resource
     • Attribute: Last Hardware Scan

   • Click “OK”.

   • Back in the “Criterion Properties” dialog, set the condition to “is less than” and provide the value as 30 days ago from today’s date. You can use the following SQL-like statement for this:

     select *  from  SMS_R_System where DateDiff(day, SMS_R_System.LastHardwareScan, GetDate()) > 30

   • Click “OK” to close the “Criterion Properties” dialog.

5. Completing the Query:

   • Review the query statement and ensure it reflects the desired condition.
   • Click “OK” to close the “Query Statement Properties” dialog.
   • Click “Next” on the “Create Device Collection Wizard” and then “Close” to finish the creation of the collection.

6. Verifying the Collection:

   • Navigate to the “Device Collections” node and locate your newly created collection.
   • Right-click on the collection and select “Update Membership” to ensure the query is executed and the collection is populated.