Hi,

By default, If I am trying to pull out the Disk Utilization report from SCOM it is coming in /sec.

I want this logical disk performance report /millisec.

Is it possible to get the reports  by somehow customizing it..?

Please help.

Thanks,

Aakash

SCOM performance rule for logical disk performance is collected in /sec and you need to create your own report by

1) using the following SQL query to extract disk performance data in

select ruledefaultname, instancename, DATEADD(hh,8,datetime) as eventdate, averagevalue * 1000,  path from [Rule] inner join PerformanceRuleInstance  on [Rule].RuleRowId=PerformanceRuleInstance.RuleRowId inner join  perf.vPerfHourly on   PerformanceRuleInstance.PerformanceRuleInstanceRowId =Perf.vPerfHourly.PerformanceRuleInstanceRowId  inner join ManagedEntity on  Perf.vPerfHourly.ManagedEntityRowId=ManagedEntity.ManagedEntityRowId  where ( RuleDefaultName like '%average disk seconds per read%' or  RuleDefaultName like '%average disk seconds per write%'  ) and  DATEDIFF(dd,DATEADD(hh,8,datetime),GETDATE()) < 7 and (Path like 'abc-App%' or   Path like 'abc-DB%')   order by ruledefaultname,Path, InstanceName,eventdate

a) "Path like 'abc-App%' or   Path like 'abc-DB%'" is server which I want to extract it HD disk performance

b) RuleDefaultName is the performance collection rule which collection disk performance

c) the above SQL extract past 7 day performance data

2) Feed this data into your custom SSRS report or in excel format

Roger