Sample Queries for Power Management in Configuration Manager

Oppdatert: januar 2014

Gjelder for: 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.

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)

Se også

-----
For additional resources, see Information and Support for Configuration Manager.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012 Configuration Manager. For instructions and examples, see Search the Configuration Manager Documentation Library.
-----
Vis: