Microsoft System Center Extending Operations Manager Reporting by George Wallace & Chris Jones & Bill May & Fred Lee & Mitch Tulloch

Author:George Wallace & Chris Jones & Bill May & Fred Lee & Mitch Tulloch
Language: eng
Format: epub, mobi, pdf
Publisher: Microsoft Press
Published: 2014-06-20T16:00:00+00:00

End

Close C1

Deallocate C1

Select * From #Results

Drop Table #Temp

Drop Table #Results

* * *

LISTING 6-3 SQL query for logical disk free space

Click here to view code image

* * *

SELECT DISTINCT ME.Path

INTO #SNames

FROM Perf.vPerfDaily PD

INNER JOIN vPerformanceRuleInstance PRI

ON PRI.PerformanceRuleInstanceRowId = PD.PerformanceRuleInstanceRowId

INNER JOIN vManagedEntity ME

ON PD.ManagedEntityRowId = ME.ManagedEntityRowId

INNER JOIN vPerformanceRule PR

ON PRI.RuleRowId = PR.RuleRowId

WHERE ObjectName = 'logicaldisk'

SELECT DISTINCT CONVERT(INT, PD.AverageValue) AS FreeSpace,

ME.Path AS ServerName,

R.RuleDefaultName,

ME.Name AS Drive,

PD.DateTime

FROM Perf.vPerfDaily PD

INNER JOIN vManagedEntity ME

ON PD.ManagedEntityRowId = ME.ManagedEntityRowId

INNER JOIN vPerformanceRuleInstance PR

ON PD.PerformanceRuleInstanceRowId = PR.PerformanceRuleInstanceRowId

INNER JOIN vRule R

ON PR.RuleRowId = R.RuleRowId

WHERE R.RuleDefaultName LIKE '% Logical Disk Free Space Windows Server 2012'

AND PD.DateTime >= DATEADD(DAY, - 2, GetDate())

AND ME.Path

IN (SELECT * FROM #SNames)

DROP TABLE #SNames

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.