Share

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'
Share on Facebook0Tweet about this on TwitterShare on Google+0Share on LinkedIn0Pin on Pinterest0

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>

seventeen − 8 =

Facebook

Unable to display Facebook posts.
Show error

Error: Unsupported get request. Object with ID 'orchtechsoftwarehouse' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https://developers.facebook.com/docs/graph-api
Type: GraphMethodException
Code: 100
Subcode: 33
Please refer to our Error Message Reference.