Read next article:

"Devices with Specific Performance Monitor"

Devices with Memory Utilization Exceeds 85%

In Default | 0 comments

This is a sample of dynamic group for the devices with memory utilization exceeds 85% for example.

SELECT Device.nDeviceID
FROM dbo.StatisticalMemoryCache AS SMC
LEFT OUTER JOIN dbo.StatisticalMemoryIdentification AS SMI ON 
SMI.nStatisticalMemoryIdentificationID = SMC.nStatisticalMemoryIdentificationID
LEFT OUTER JOIN dbo.PivotStatisticalMonitorTypeToDevice AS PSMTTD ON 
PSMTTD.nPivotStatisticalMonitorTypeToDeviceID = SMI.nPivotStatisticalMonitorTypeToDeviceID
LEFT OUTER JOIN Device ON Device.nDeviceID = PSMTTD.nDeviceID
WHERE (SMC.nUsed_Max/SMC.nSize > 0.85) AND sType = 'RAM'

Leave a Reply

Allowed Tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

10 + 2 =


Unable to display Facebook posts.
Show error

Error: (#10) This endpoint requires the 'manage_pages' or 'pages_read_user_content' permission or the 'Page Public Content Access' feature. Refer to and for details.
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.