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>

14 + 2 =


Unable to display Facebook posts.
Show error

Error: (#10) To use 'Page Public Content Access', your use of this endpoint must be reviewed and approved by Facebook. To submit this 'Page Public Content Access' feature for review please read our documentation on reviewable features:
Type: OAuthException
Code: 10
Please refer to our Error Message Reference.