How to Create a Collection of Computers Based on Sleep Capabilities
Applies To: System Center Configuration Manager 2007 R3
You can use the use the power management information returned by Configuration Manager 2007 R3 client computers to populate a collection of computers dynamically that report various power or power management compatibility information.
For example, you can create a collection of desktop computers that are capable of sleep and capable of wake from sleep and then apply a power management power plan to this collection.
The procedure in this topic explains how to create a Configuration Manager 2007 collection that is populated dynamically with only desktop computers that are capable of both sleep and wake from sleep. You can use this query as a basis to create other queries based on the power management information returned by Configuration Manager 2007 R3 client computers.
The information in this topic applies only to Configuration Manager 2007 R3.
To create a collection based on the sleep capability of desktop computers
Copy the following query and paste it into a text editor, such as Notepad.
select SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion from SMS_R_System inner join SMS_G_System_POWER_MANAGEMENT_CAPABILITIES on SMS_G_System_POWER_MANAGEMENT_CAPABILITIES.ResourceID = SMS_R_System.ResourceId where (SMS_G_System_POWER_MANAGEMENT_CAPABILITIES.RtcWake = "PowerSystemHibernate" or SMS_G_System_POWER_MANAGEMENT_CAPABILITIES.RtcWake = "PowerSystemSleeping3" or SMS_G_System_POWER_MANAGEMENT_CAPABILITIES.RtcWake = "PowerSystemShutdown") and SMS_G_System_POWER_MANAGEMENT_CAPABILITIES.SystemS3 = 1 and SMS_G_System_POWER_MANAGEMENT_CAPABILITIES.PreferredPMProfile != 2 order by SMS_R_System.Name DESC
To create the collection, in the Configuration Manager console, right-click the Collections node, and then click New Collection to start the New Collection Wizard.
On the General page, specify the collection named Desktop computers capable of sleep and wake from sleep and, optionally, specify a description.
On the Membership Rules page, click the second Membership rules icon to open the Query Rules Properties dialog box.
In the Query Rules Properties dialog box, specify a name such as Desktop computers capable of sleep and wake from sleep, ensure System Resource is selected as the Resource class, and then click Edit Query Statement.
In the Query Statement Properties dialog box, click Show Query Language.
In the Query Statement Properties dialog box, paste the modified query earlier in this topic from Notepad into the Query Statement box.
Click OK to save the query, and then click OK to close the Query Statement Properties dialog box.
In the Query Rule Properties dialog box, optionally select Limit to collection, and then click OK.
On the Membership Rules page of the New Collection Wizard, optionally click Schedule if you want to define an update schedule for the collection membership that is shorter than the default of every day.
If you are defining an alternative schedule, specify your alternative in the Custom Schedule dialog box, and then click OK.
Complete the wizard.
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.