WhatsUp Gold 有預先設定的動態群組範例，位於 [裝置] 索引標籤下的網頁介面畫面中。如需這些群組的詳細資訊，請參閱〈建立動態群組〉。

下例列出的幾個動態群組過濾條件，可讓您為裝置建立實用的動態群組。若要使用這些範例，請選取過濾條件的文字，然後複製並貼到 [動態群組] 對話方塊的 [過濾條件] 方塊中。

註: 從說明檔複製程式碼時若出現版權資訊，最好移除貼上的版權資訊。

顯示過去三小時內所有狀態有所變更的裝置

SELECT DISTINCT Device.nDeviceIDFROM   Device       JOIN PivotActiveMonitorTypeToDevice         ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID       JOIN ActiveMonitorStateChangeLog         ON PivotActiveMonitorTypeToDevice.nPivotActiveMonitorTypeToDeviceID =              ActiveMonitorStateChangeLog.nPivotActiveMonitorTypeToDeviceIDWHERE  Device.bRemoved = 0        AND DATEDIFF(Hh,ActiveMonitorStateChangeLog.dStartTime,GETDATE()) <= 3

顯示所有安裝了多個網路介面的裝置

SELECT DISTINCT NetworkInterface.nDeviceID FROM Device          JOIN NetworkInterface            ON Device.nDeviceID = NetworkInterface.nDeviceID WHERE    Device.bRemoved = 0 GROUP BY NetworkInterface.nDeviceID HAVING   COUNT(NetworkInterface.nDeviceID) > 1

顯示所有從過去兩小時內離線到現在的裝置

SELECT DISTINCT Device.nDeviceID FROM 	Device 	JOIN PivotActiveMonitorTypeToDevice 	  ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID 	JOIN ActiveMonitorStateChangeLog         ON PivotActiveMonitorTypeToDevice.nPivotActiveMonitorTypeToDeviceID =              ActiveMonitorStateChangeLog.nPivotActiveMonitorTypeToDeviceID       JOIN MonitorState         ON Device.nWorstStateID = MonitorState.nMonitorStateID WHERE Device.bRemoved = 0 	AND PivotActiveMonitorTypeToDevice.bDisabled = 0 	AND DATEDIFF(hh, ActiveMonitorStateChangeLog.dStartTime, GETDATE()) <= 2 	AND MonitorState.nInternalMonitorState = 1

顯示所有過去兩天內有觸發動作的裝置（在一個特定群組中）

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN ActionActivityLog          ON Device.nDeviceID = ActionActivityLog.nDeviceID        JOIN PivotDeviceToGroup          ON Device.nDeviceID = PivotDeviceToGroup.nDeviceID        JOIN DeviceGroup          ON PivotDeviceToGroup.nDeviceGroupID = DeviceGroup.nDeviceGroupID WHERE  Device.bRemoved = 0        AND DATEDIFF(Dd,ActionActivityLog.dDateTime,GETDATE()) <= 2        AND DeviceGroup.sGroupName = 'My Key Resources Group'

顯示所有需要認可的裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN PivotActiveMonitorTypeToDevice          ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID        JOIN ActiveMonitorStateChangeLog          ON PivotActiveMonitorTypeToDevice.nPivotActiveMonitorTypeToDeviceID =               ActiveMonitorStateChangeLog.nPivotActiveMonitorTypeToDeviceID WHERE  Device.bRemoved = 0        AND ActiveMonitorStateChangeLog.bAcknowledged = 0        AND PivotActiveMonitorTypeToDevice.bRemoved = 0

顯示所有磁碟使用量在 90% 以上的裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN PivotStatisticalMonitorTypeToDevice          ON Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID        JOIN StatisticalDiskIdentification          ON PivotStatisticalMonitorTypeToDevice.nPivotStatisticalMonitorTypeToDeviceID =               StatisticalDiskIdentification.nPivotStatisticalMonitorTypeToDeviceID        JOIN StatisticalDiskCache          ON StatisticalDiskIdentification.nStatisticalDiskIdentificationID =               StatisticalDiskCache.nStatisticalDiskIdentificationID WHERE  Device.bRemoved = 0        AND PivotStatisticalMonitorTypeToDevice.bEnabled = 1        AND StatisticalDiskCache.nDataType = 1        AND (((nUsed_Avg / nSize) > 0.90)             AND (NOT nSize = 0                   OR nSize IS                      NULL))

顯示所有維護中或至少有一個主動監控工具離線且符合指定裝置類型的裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN MonitorState          ON Device.nWorstStateID = MonitorState.nMonitorStateID WHERE  Device.bRemoved = 0        AND MonitorState.nInternalMonitorState IN (1,2)        AND Device.nDeviceTypeID IN (3,4,38,63,64,65,66,67,68,71,72)

只顯示所有主動監控工具都離線的裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN MonitorState          ON Device.nWorstStateID = MonitorState.nMonitorStateID WHERE  Device.bRemoved = 0        AND MonitorState.nInternalMonitorState = 1        AND Device.nWorstStateID = Device.nBestStateID

只顯示所有主動監控工具都離線 20 分鐘以上的裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN PivotActiveMonitorTypeToDevice          ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID        JOIN ActiveMonitorStateChangeLog          ON PivotActiveMonitorTypeToDevice.nPivotActiveMonitorTypeToDeviceID =               ActiveMonitorStateChangeLog.nPivotActiveMonitorTypeToDeviceID        JOIN MonitorState          ON PivotActiveMonitorTypeToDevice.nMonitorStateID =               MonitorState.nMonitorStateID WHERE  Device.bRemoved = 0        AND PivotActiveMonitorTypetoDevice.bRemoved = 0        AND PivotActiveMonitorTypeToDevice.bDisabled = 0        AND MonitorState.nInternalMonitorState = 1        AND DATEDIFF(Mi,ActiveMonitorStateChangeLog.dStartTime,GETDATE()) >= 20        AND Device.nWorstStateId = Device.nBestStateId

顯示特定效能監控工具被指派到的裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN PivotStatisticalMonitorTypeToDevice          ON Device.nDeviceID = PivotStatisticalMonitorTypeToDevice.nDeviceID        JOIN StatisticalMonitorType          ON StatisticalMonitorType.nStatisticalMonitorTypeID =               PivotStatisticalMonitorTypeToDevice.nStatisticalMonitorTypeID WHERE  Device.bRemoved = 0        AND PivotStatisticalMonitorTypeToDevice.bEnabled = 1        AND StatisticalMonitorType.sStatisticalMonitorTypeName             LIKE '%Interface Utilization%'

顯示特定被動監控工具被指派到的裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN PivotPassiveMonitorTypeToDevice          ON Device.nDeviceID = PivotPassiveMonitorTypeToDevice.nDeviceID       JOIN PassiveMonitorType         ON PassiveMonitorType.nPassiveMonitorTypeID =              PivotPassiveMonitorTypeToDevice.nPassiveMonitorTypeID WHERE  Device.bRemoved = 0       AND PivotPassiveMonitorTypeToDevice.bRemoved = 0       AND PassiveMonitorType.sMonitorTypeName LIKE '%Cold Start%'

顯示特定主動監控工具被指派到的裝置

SELECT DISTINCT Device.nDeviceIDFROM   Device       JOIN PivotActiveMonitorTypeToDevice         ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID        JOIN ActiveMonitorType          ON ActiveMonitorType.nActiveMonitorTypeID =              PivotActiveMonitorTypeToDevice.nActiveMonitorTypeID WHERE  Device.bRemoved = 0       AND PivotActiveMonitorTypeToDevice.bRemoved = 0       AND ActiveMonitorType.sMonitorTypeName LIKE '%Ping%'

依據顯示名稱、主機名稱或 IP 位址尋找一個裝置

SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN NetworkInterface          ON Device.nDeviceID = NetworkInterface.nDeviceID             AND Device.nDefaultNetworkInterfaceID =                   NetworkInterface.nNetworkInterfaceID        JOIN DeviceType          ON Device.nDeviceTypeID = DeviceType.nDeviceTypeID WHERE  (Device.sDisplayName LIKE '%Mail Server%'          OR NetworkInterface.sNetworkName LIKE '%server1.ipswitch.com%'          OR NetworkInterface.sNetworkAddress LIKE '%1.2.3.4%')        AND Device.bRemoved = 0

顯示動作（或主動監控工具的動作）名稱中含有特定字詞的裝置

註: 若要搜尋其他動作，請變更 LIKE 後面的動作名稱。請務必保留那兩個 % 符號。
SELECT DISTINCT Device.nDeviceIDFROM   Device       JOIN ActionPolicy		 ON Device.nActionPolicyID = ActionPolicy.nActionPolicyID        JOIN PivotActionTypeToActionPolicy 		 ON ActionPolicy.nActionPolicyID =  			PivotActionTypeToActionPolicy.nActionPolicyID 		JOIN ActionType 		  ON PivotActionTypeToActionPolicy.nActionTypeID = 			 ActionType.nActionTypeID WHERE  Device.bRemoved = 0        AND ActionType.sActionTypeName LIKE '%Critical%' UNION SELECT DISTINCT Device.nDeviceID FROM   Device        JOIN PivotActiveMonitorTypeToDevice          ON Device.nDeviceID = PivotActiveMonitorTypeToDevice.nDeviceID        JOIN ActionPolicy          ON PivotActiveMonitorTypeToDevice.nActionPolicyID =                ActionPolicy.nActionPolicyID        JOIN PivotActionTypeToActionPolicy          ON ActionPolicy.nActionPolicyID =                PivotActionTypeToActionPolicy.nActionPolicyID        JOIN ActionType          ON PivotActionTypeToActionPolicy.nActionTypeID =                ActionType.nActionTypeID WHERE  Device.bRemoved = 0        AND PivotActiveMonitorTypeToDevice.bRemoved = 0        AND ActionType.sActionTypeName LIKE '%Critical%'UNIONSELECT DISTINCT Device.nDeviceIDFROM   Device       JOIN ActionPolicy	 ON  ActionPolicy.nActionPolicyID=0 and bGlobalActionPolicy=1       JOIN PivotActionTypetoActionPolicy P	 ON P.nActionPolicyID = ActionPolicy.nActionPolicyID       JOIN [ActionType]	 ON P.nActionTypeID = ActionType.nActionTypeIDWHERE  ActionType.sActionTypeName LIKE '%Critical%'