• Article

Sample Queries for Power Management in Configuration Manager

 

Updated: January 1, 2014

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

The following sample queries demonstrate how to join power management views to other views.

Joining Power Management Views to Discovery Views

The following query lists all computers, by Netbios name that are excluded from power management because the user selected this.

The query returns the Netbios name and the domain of the computer and also the client opt out setting where this value is 1 (indicating that the computer has been excluded from power management).

SELECT        v_R_System.Name0, v_R_System.Resource_Domain_OR_Workgr0, 
                         v_GS_POWER_MANAGEMENT_CLIENTOPTOUT_SETTINGS.IsClientOptOut0
FROM            v_R_System INNER JOIN
                         v_GS_POWER_MANAGEMENT_CLIENTOPTOUT_SETTINGS ON 
                         v_R_System.ResourceID = v_GS_POWER_MANAGEMENT_CLIENTOPTOUT_SETTINGS.ResourceID
WHERE        (v_GS_POWER_MANAGEMENT_CLIENTOPTOUT_SETTINGS.IsClientOptOut0 = 1)