Data Warehouse Main 11in DateTime =Now.AddDays(-7) Start Date DateTime =Now End Date String ObjectName ObjectName ObjectName ObjectName String Counter Name CounterName CounterName CounterName String true Computer ComputerList name name true Float true true Threshold Line Integer true true Min scale value Integer true true Max scale value String Hourly Data Type Hourly Daily Raw Float -5 true GMT Offset String true Report Title true 8.5in true 0.25in 0.25in 0.25in 3ebf24e3-9c7d-4cca-ad2b-8f4d96349b1e 11in name System.String ObjectName System.String CounterName System.String InstanceName System.String DateTime System.DateTime SampleValue System.Int32 SampleCount System.Int32 AverageValue System.Double MinValue System.Double MaxValue System.Double StandardDeviation System.Double DataWarehouseMain IF @dataview='Hourly' BEGIN --vPerfHourly query select vme2.name ,vpru.ObjectName ,vpru.CounterName ,vpri.InstanceName ,(DATEADD(hh,(CAST(@gmtoffset as float)),pdata.DateTime)) as DateTime ,0 as SampleValue ,pdata.SampleCount ,pdata.AverageValue ,pdata.MinValue ,pdata.MaxValue ,pdata.StandardDeviation from Perf.vPerfHourly pdata join vManagedEntity vme on pdata.ManagedEntityRowId=vme.ManagedEntityRowId join vPerformanceRuleInstance vpri on vpri.PerformanceRuleInstanceRowId=pdata.PerformanceRuleInstanceRowId join vPerformanceRule vpru on vpru.RuleRowId=vpri.RuleRowId join vManagedEntity vme2 on vme2.ManagedEntityRowId=vme.TopLevelHostManagedEntityRowId where vpru.ObjectName=@ObjectName and vpru.CounterName=@CounterName --and datetime between @StartDate and @EndDate and datetime between (DATEADD(hh,-(CAST(@gmtoffset as float)),@startdate)) and (DATEADD(hh,-(CAST(@gmtoffset as float)),@enddate)) and vme2.name in (@Computer) order by datetime asc END ELSE IF @dataview='Daily' BEGIN --vPerfDaily query select vme2.name ,vpru.ObjectName ,vpru.CounterName ,vpri.InstanceName ,(DATEADD(hh,(CAST(@gmtoffset as float)),pdata.DateTime)) as DateTime ,0 as SampleValue ,pdata.SampleCount ,pdata.AverageValue ,pdata.MinValue ,pdata.MaxValue ,pdata.StandardDeviation from Perf.vPerfDaily pdata join vManagedEntity vme on pdata.ManagedEntityRowId=vme.ManagedEntityRowId join vPerformanceRuleInstance vpri on vpri.PerformanceRuleInstanceRowId=pdata.PerformanceRuleInstanceRowId join vPerformanceRule vpru on vpru.RuleRowId=vpri.RuleRowId join vManagedEntity vme2 on vme2.ManagedEntityRowId=vme.TopLevelHostManagedEntityRowId where vpru.ObjectName=@ObjectName and vpru.CounterName=@CounterName --and datetime between @StartDate and @EndDate and datetime between (DATEADD(hh,-(CAST(@gmtoffset as float)),@startdate)) and (DATEADD(hh,-(CAST(@gmtoffset as float)),@enddate)) and vme2.name in (@Computer) order by datetime asc END ELSE IF @dataview='Raw' BEGIN select vme2.name ,vpru.ObjectName ,vpru.CounterName ,vpri.InstanceName ,(DATEADD(hh,(CAST(@gmtoffset as float)),pdata.DateTime)) as DateTime ,pdata.SampleValue ,1 as SampleCount ,pdata.SampleValue as AverageValue ,pdata.SampleValue as MinValue ,pdata.SampleValue as MaxValue ,0 as StandardDeviation from Perf.vPerfRaw pdata join vManagedEntity vme on pdata.ManagedEntityRowId=vme.ManagedEntityRowId join vPerformanceRuleInstance vpri on vpri.PerformanceRuleInstanceRowId=pdata.PerformanceRuleInstanceRowId join vPerformanceRule vpru on vpru.RuleRowId=vpri.RuleRowId join vManagedEntity vme2 on vme2.ManagedEntityRowId=vme.TopLevelHostManagedEntityRowId where vpru.ObjectName=@ObjectName and vpru.CounterName=@CounterName --and datetime between @StartDate and @EndDate and datetime between (DATEADD(hh,-(CAST(@gmtoffset as float)),@startdate)) and (DATEADD(hh,-(CAST(@gmtoffset as float)),@enddate)) and vme2.name in (@Computer) order by datetime asc END =Parameters!dataview.Value =Parameters!gmtoffset.Value =Parameters!ObjectName.Value =Parameters!CounterName.Value =Parameters!StartDate.Value =Parameters!EndDate.Value =Parameters!Computer.Value true CounterName System.String DataWarehouseMain select distinct CounterName from vPerformanceRule where ObjectName=@ObjectName order by CounterName asc =Parameters!ObjectName.Value true name System.String DataWarehouseMain select distinct vme2.name from vManagedEntity vme join Perf.vPerfDaily vpd on vpd.ManagedEntityRowId=vme.ManagedEntityRowId join vPerformanceRuleInstance vpri on vpri.PerformanceRuleInstanceRowId=vpd.PerformanceRuleInstanceRowId join vPerformanceRule vpr on vpr.RuleRowId=vpri.RuleRowId join vManagedEntity vme2 on vme2.ManagedEntityRowId=vme.TopLevelHostManagedEntityRowId where vpr.ObjectName=@ObjectName order by vme2.name asc =Parameters!ObjectName.Value true ObjectName System.String DataWarehouseMain select distinct ObjectName from vPerformanceRule order by ObjectName asc true 10.375in 0.125in 6 true 0.375in =Parameters!ReportTitle.Value 5OpsMgrDW7.5in =Fields!name.Value =Fields!name.Value Ascending

name 4 true =Fields!name.Value textbox11 3 true =Sum(Fields!SampleCount.Value) textbox12 2 true =FormatNumber(Avg(Fields!AverageValue.Value),4) textbox13 1 true =Min(Fields!MinValue.Value) textbox14 true =Max(Fields!MaxValue.Value) 0.21in

9 true Computer 8 true Sample Count 7 true Average Value 6 true Min Value 5 true Max Value 0.22in true

3.33025in 1.66512in 1.53704in 1.79321in 2.04938in 0.43in 1.375in 8in 4 true 0.205in =Parameters!StartDate.Value + " - " + Parameters!EndDate.Value 1.125in 8in 3 true 0.205in =Parameters!dataview.Value + IIf(Parameters!dataview.Value="Raw"," Data"," Average") textbox1 0.875in 8in 2 true 0.205in =Parameters!ObjectName.Value + " - " + Parameters!CounterName.Value

true BottomCenter Table

Outside 0 =Int((int(DateDiff(IIf(Parameters!dataview.Value="Hourly","h",(IIf(Parameters!dataview.Value="Daily","d","m"))),Parameters!StartDate.Value,Parameters!EndDate.Value)))/10) true 1 OpsMgrDW Inside =IIf(IsNothing(Parameters!MinScale.Value),(Ceiling(Min(Fields!AverageValue.Value))),Parameters!MinScale.Value) =IIf(IsNothing(Parameters!MaxScale.Value),(Ceiling(Max(Fields!AverageValue.Value)))+1,Parameters!MaxScale.Value) =Ceiling((Max(Fields!AverageValue.Value))/10) true true true Line =Fields!DateTime.Value =Fields!DateTime.Value Default =(Fields!AverageValue.Value) =IIf(IsNothing(Parameters!Threshold.Value),"",(IIf(Fields!AverageValue.Value > Parameters!Threshold.Value,FormatNumber(Fields!AverageValue.Value) + " (" + Fields!name.Value + ")",""))) true BottomCenter Table Outside 0 =Int((int(DateDiff(IIf(Parameters!dataview.Value="Hourly","h",(IIf(Parameters!dataview.Value="Daily","d","m"))),Parameters!StartDate.Value,Parameters!EndDate.Value)))/10) true OpsMgrDW 30 30 Simple 50 0 =Fields!name.Value =Parameters!CounterName.Value 1.625in Plain Inside =IIf(IsNothing(Parameters!MinScale.Value),(Ceiling(Min(Fields!AverageValue.Value))),Parameters!MinScale.Value) =IIf(IsNothing(Parameters!MaxScale.Value),(Ceiling(Max(Fields!AverageValue.Value)))+1,Parameters!MaxScale.Value) =Ceiling((Max(Fields!AverageValue.Value))/10) true true true Line =Fields!DateTime.Value =Fields!DateTime.Value Default =Parameters!Threshold.Value test 6pt 5.625in 8.625in en-US true 0.15cm -18.2cm 4 18.3cm 0cm 0.9cm 7.609cm 3 true 10.4cm 0.63492cm ="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString() 0.25cm 5.75cm 1 true 0.25cm 0.63492cm ="Execution Time: " + IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).TotalSeconds < 1, "0 seconds", ( IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Hours & " hour(s), ", "") + IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Minutes & " minute(s), ", "") + IIf(System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds > 0, System.DateTime.Now.Subtract(Globals!ExecutionTime).Seconds & " second(s)", "")) ) 0.25cm 12cm true 6cm 0.63492cm =" Executed by " + User!UserID + " on " + Globals!ExecutionTime.ToString() 1in true 0.25in 8.5in