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>

2 + 8 =

Facebook

Unable to display Facebook posts.
Show error

Error: Error validating application. Application has been deleted.
Type: OAuthException
Code: 190
Please refer to our Error Message Reference.