Microsoft.Virtualization.2016.Reports.VMPerformance.rdl (ReportResource)

Element properties:

TypeReportResource
File NameMicrosoft.Virtualization.2016.Reports.VMPerformance.rdl
AccessibilityInternal

Source Code:

<ReportResource ID="Microsoft.Virtualization.2016.Reports.VMPerformance.rdl" FileName="Microsoft.Virtualization.2016.Reports.VMPerformance.rdl" Accessibility="Internal" HasNullStream="false" MIMEType="application/octet-stream"/>

File Content: Microsoft.Virtualization.2016.Reports.VMPerformance.rdl

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<Body><Script>
<ReportItems>
<Textbox Name="textboxReportTitle_tmp">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>=String.Format(Code.GetLocTable("LT_Report").GetString("R.Description", "CPU Usage by Virtual Machines Compared with Total CPU Usage on the Host ({0})"), Parameters!Hosts.Value)</Value>
<Style></Style>
<FontFamily>Verdana</FontFamily>
<FontSize>9pt</FontSize>
<FontWeight>Bold</FontWeight>
<Color>#000000</Color>
</Style>
</TextRun>
</TextRuns>
<Style /></Style>
</Paragraph>
</Paragraphs>
<Top>0.125in</Top>
<Left>0.125in</Left>
<Height>0.25in</Height>
<Width>9.75in</Width>
<DataElementOutput>NoOutput</DataElementOutput>
<Style></Style>
<Border>
<Color>LightGrey</Color>
<Width>0.25pt</Width>
</Border>
<BackgroundColor>WhiteSmoke</BackgroundColor>
<BackgroundImage>
<Source>External</Source>
<Value>/Microsoft Operations Manager Reporting/Images/9Inch_Banner.png</Value>
<BackgroundRepeat>Clip</BackgroundRepeat>
</BackgroundImage>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
</Textbox>
<Chart Name="chart1">
<ChartCategoryHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!DataPointDateTime.Value</GroupExpression>
</GroupExpressions>
<DataElementName>CPUChartCategoryGroup</DataElementName>
</Group>
<Label />
<DataElementName>CPUChartCategoryGroupCollection</DataElementName>
<DataElementOutput>Output</DataElementOutput>
</ChartMember>
</ChartMembers>
</ChartCategoryHierarchy>
<ChartSeriesHierarchy>
<ChartMembers>
<ChartMember>
<Group Name="chart1_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Fields!DisplayName.Value</GroupExpression>
</GroupExpressions>
<DataElementName>CPUChartSeriesGroup</DataElementName>
</Group>
<Label />
<DataElementName>CPUChartSeriesGroupCollection</DataElementName>
<DataElementOutput>Output</DataElementOutput>
</ChartMember>
</ChartMembers>
</ChartSeriesHierarchy>
<ChartData>
<ChartSeriesCollection>
<ChartSeries Name="Series1">
<ChartDataPoints>
<ChartDataPoint>
<ChartDataPointValues>
<Y>=Fields!AVG1.Value</Y>
</ChartDataPointValues>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
<Style></Style>
<Border>
<Width>2.25pt</Width>
</Border>
</Style>
<ChartMarker>
<Size>6pt</Size>
<Style /></Style>
</ChartMarker>
</ChartDataPoint>
</ChartDataPoints>
<Type>Line</Type>
<Style /></Style>
<ChartEmptyPoints>
<Style /></Style>
<ChartMarker>
<Style /></Style>
</ChartMarker>
<ChartDataLabel>
<Style /></Style>
</ChartDataLabel>
</ChartEmptyPoints>
<ValueAxisName>Primary</ValueAxisName>
<CategoryAxisName>Primary</CategoryAxisName>
<ChartSmartLabel>
<CalloutLineColor>Black</CalloutLineColor>
<MinMovingDistance>0pt</MinMovingDistance>
</ChartSmartLabel>
</ChartSeries>
</ChartSeriesCollection>
</ChartData>
<ChartAreas>
<ChartArea Name="Default">
<ChartCategoryAxes>
<ChartAxis Name="Primary">
<Style></Style>
<Border>
<Style></Style>None</Style>
<Width>0.75pt</Width>
</Border>
<Format>M/d/yy HH:mm</Format>
</Style>
<ChartAxisTitle>
<Caption />
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<Margin>False</Margin>
<Interval>NaN</Interval>
<ChartMajorGridLines>
<Enabled>False</Enabled>
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<Interval>NaN</Interval>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Enabled>False</Enabled>
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<Interval>NaN</Interval>
</ChartMinorGridLines>
<ChartMajorTickMarks>
<Enabled>True</Enabled>
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<Interval>NaN</Interval>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Type>None</Type>
</ChartMinorTickMarks>
<Scalar>true</Scalar>
<Angle>-30</Angle>
<PreventFontShrink>true</PreventFontShrink>
<PreventFontGrow>true</PreventFontGrow>
<IncludeZero>false</IncludeZero>
<LabelsAutoFitDisabled>true</LabelsAutoFitDisabled>
<ChartAxisScaleBreak>
<Style /></Style>
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption />
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style /></Style>
</ChartAxisScaleBreak>
</ChartAxis>
</ChartCategoryAxes>
<ChartValueAxes>
<ChartAxis Name="Primary">
<Style></Style>
<Border>
<Style></Style>None</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<ChartAxisTitle>
<Caption>=Code.GetLocTable("LT_Report").GetString("R.YAxis.Percentage", "Percentage")</Caption>
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<Margin>True</Margin>
<ChartMajorGridLines>
<Enabled>True</Enabled>
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<Interval>NaN</Interval>
</ChartMajorGridLines>
<ChartMinorGridLines>
<Enabled>False</Enabled>
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<Interval>NaN</Interval>
</ChartMinorGridLines>
<ChartMajorTickMarks>
<Enabled>True</Enabled>
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<Interval>NaN</Interval>
</ChartMajorTickMarks>
<ChartMinorTickMarks>
<Type>None</Type>
</ChartMinorTickMarks>
<Interlaced>true</Interlaced>
<InterlacedColor>Lavender</InterlacedColor>
<Scalar>true</Scalar>
<Minimum>0</Minimum>
<Maximum>100</Maximum>
<PreventFontShrink>true</PreventFontShrink>
<PreventFontGrow>true</PreventFontGrow>
<IncludeZero>false</IncludeZero>
<ChartAxisScaleBreak>
<Style /></Style>
</ChartAxisScaleBreak>
</ChartAxis>
<ChartAxis Name="Secondary">
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
<ChartAxisTitle>
<Caption />
<Style></Style>
<FontSize>8pt</FontSize>
</Style>
</ChartAxisTitle>
<CrossAt>NaN</CrossAt>
<Location>Opposite</Location>
<Minimum>NaN</Minimum>
<Maximum>NaN</Maximum>
<ChartAxisScaleBreak>
<Style /></Style>
</ChartAxisScaleBreak>
</ChartAxis>
</ChartValueAxes>
<ChartThreeDProperties>
<ProjectionMode>Perspective</ProjectionMode>
<Shading>Simple</Shading>
<WallThickness>15</WallThickness>
<Clustered>true</Clustered>
</ChartThreeDProperties>
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
<BackgroundColor>AliceBlue</BackgroundColor>
</Style>
</ChartArea>
</ChartAreas>
<ChartLegends>
<ChartLegend Name="Default">
<Style></Style>
<Border>
<Style></Style>Solid</Style>
<Width>0.75pt</Width>
</Border>
</Style>
<Position>RightCenter</Position>
<Layout>Column</Layout>
<DockOutsideChartArea>true</DockOutsideChartArea>
<ChartLegendTitle>
<Caption />
<Style></Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
<TextAlign>Center</TextAlign>
</Style>
</ChartLegendTitle>
<AutoFitTextDisabled>true</AutoFitTextDisabled>
</ChartLegend>
</ChartLegends>
<Palette>BrightPastel</Palette>
<ChartBorderSkin>
<Style></Style>
<BackgroundColor>Gray</BackgroundColor>
<BackgroundGradientType>None</BackgroundGradientType>
<Color>White</Color>
</Style>
</ChartBorderSkin>
<ChartNoDataMessage Name="NoDataMessageTitle">
<Caption>No Data</Caption>
<Style></Style>
<BackgroundGradientType>None</BackgroundGradientType>
<TextAlign>General</TextAlign>
<VerticalAlign>Top</VerticalAlign>
</Style>
</ChartNoDataMessage>
<DataSetName>VMCPUPerf</DataSetName>
<Top>0.375in</Top>
<Left>0.125in</Left>
<Height>3.32292in</Height>
<Width>9.625in</Width>
<ZIndex>1</ZIndex>
<CustomProperties>
<CustomProperty>
<Name>__Upgraded2005__</Name>
<Value>__Upgraded2005__</Value>
</CustomProperty>
</CustomProperties>
<DataElementName>CPUChart</DataElementName>
<Style></Style>
<BackgroundColor>White</BackgroundColor>
</Style>
</Chart>
</ReportItems>
<Height>3.69792in</Height>
<Style /></Style>
</Script></Body>
<Width>9.875in</Width>
<Page>
<PageHeight>8.5in</PageHeight>
<PageWidth>11in</PageWidth>
<InteractiveHeight>11in</InteractiveHeight>
<InteractiveWidth>8.5in</InteractiveWidth>
<LeftMargin>0.5in</LeftMargin>
<RightMargin>0.5in</RightMargin>
<TopMargin>0.5in</TopMargin>
<BottomMargin>0.5in</BottomMargin>
<Style /></Style>
</Page>
<AutoRefresh>0</AutoRefresh>
<DataSources>
<DataSource Name="DataWarehouseMain">
<DataSourceReference>OpsMgrDataWare</DataSourceReference>
<rd:SecurityType>None</rd:SecurityType>
<rd:DataSourceID>e4235c51-407f-4065-8519-a1e57374bc45</rd:DataSourceID>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="LT_Report_Query">
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.VirtualMachineManager.2016.Reports</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>Microsoft.Virtualization.2016.Reports.VMPerformance</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>R.%</Value>
</QueryParameter>
</QueryParameters>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
</Query>
<Fields>
<Field Name="ValueXml">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
</Field>
<Field Name="ValueName">
<Value>="R"</Value>
</Field>
</Fields>
</DataSet>
<DataSet Name="ManagementGroups">
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>

SELECT
ManagementGroupGuid,
ManagementGroupDefaultName
FROM vManagementGroup

</CommandText>
</Query>
<Fields>
<Field Name="ManagementGroupGuid">
<DataField>ManagementGroupGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="ManagementGroupDefaultName">
<DataField>ManagementGroupDefaultName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
</DataSet>
<DataSet Name="VMCPUPerf">
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<QueryParameters>
<QueryParameter Name="@UTCStartDate1">
<Value>=Parameters!UTCStartDate1.Value</Value>
</QueryParameter>
<QueryParameter Name="@UTCEndDate1">
<Value>=Parameters!UTCEndDate1.Value</Value>
</QueryParameter>
<QueryParameter Name="@HostID">
<Value>=Parameters!HostID.Value</Value>
</QueryParameter>
<QueryParameter Name="@StartDate1">
<Value>=Parameters!StartDate1.Value</Value>
</QueryParameter>
</QueryParameters>
<CommandText>

---------------------------------------------------------------
-- calculate the time difference
---------------------------------------------------------------
DECLARE @DateDiff AS INT;
SET @DateDiff = DATEDIFF(minute , @UTCStartDate1, @StartDate1);


---------------------------------------------------------------
-- The main query
---------------------------------------------------------------
SELECT DISTINCT
vRule.RuleSystemName AS RName,
vManagedEntity.Path,
vManagedEntity.Name,
vManagedEntity.DisplayName,
DATEADD(Minute, @DateDiff, Perf.vPerfHourly.DateTime) as DataPointDateTime,
Perf.vPerfHourly.AverageValue AS AVG1,
Perf.vPerfHourly.MinValue AS MIN1,
Perf.vPerfHourly.MaxValue AS MAX1,
vPerformanceRuleInstance.InstanceName,
vManagedEntity.ManagedEntityRowId,
vManagedEntity.ManagedEntityTypeRowId
FROM vPerformanceRuleInstance
INNER JOIN Perf.vPerfHourly ON
vPerformanceRuleInstance.PerformanceRuleInstanceRowId = Perf.vPerfHourly.PerformanceRuleInstanceRowId
INNER JOIN vManagedEntity ON
vPerformanceRuleInstance.InstanceName = vManagedEntity.DisplayName
INNER JOIN vRule ON
vPerformanceRuleInstance.RuleRowId = vRule.RuleRowId
WHERE
(Perf.vPerfHourly.DateTime &gt;= @UTCStartDate1)
AND (Perf.vPerfHourly.DateTime &lt;= @UTCEndDate1)
AND
( vPerformanceRuleInstance.InstanceName IN
(
SELECT distinct AllHostsAllVMs.DisplayName FROM
(
SELECT
SourceManagedEntityRowId AS HostEntityRowId ,
TargetManagedEntityRowId AS VMEntityRowId,
dbo.vManagedEntity.DisplayName AS DisplayName
FROM dbo.vRelationship
INNER JOIN dbo.vRelationshipType
ON vRelationshipType.RelationshipTypeRowId = vRelationship.RelationshipTypeRowId
INNER JOIN dbo.vManagedEntity
ON dbo.vManagedEntity.ManagedEntityRowId = TargetManagedEntityRowId
WHERE vRelationshipType.RelationshipTypeSystemName = N'Microsoft.SystemCenter.VirtualMachineManager.VMHostContainsVirtualMachine'
) AS AllHostsAllVMs
WHERE AllHostsAllVMs.HostEntityRowId = @HostID
)
)
AND
(
vRule.RuleSystemName IN
(
N'Microsoft.SystemCenter.VirtualMachineManager.2016.VirtualMachine.PercentCPU'
)
)
ORDER BY DataPointDateTime

</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<Fields>
<Field Name="RName">
<DataField>RName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Path">
<DataField>Path</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Name">
<DataField>Name</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DisplayName">
<DataField>DisplayName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DataPointDateTime">
<DataField>DataPointDateTime</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="AVG1">
<DataField>AVG1</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
<Field Name="MIN1">
<DataField>MIN1</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
<Field Name="MAX1">
<DataField>MAX1</DataField>
<rd:TypeName>System.Double</rd:TypeName>
</Field>
<Field Name="InstanceName">
<DataField>InstanceName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ManagedEntityRowId">
<DataField>ManagedEntityRowId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ManagedEntityTypeRowId">
<DataField>ManagedEntityTypeRowId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
</DataSet>
</DataSets>
<ReportParameters>
<ReportParameter Name="LT_Report">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<Hidden>true</Hidden>
<ValidValues>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ManagementGroupId">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>ManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>ManagementGroupId</Prompt>
<Hidden>true</Hidden>
<ValidValues>
<DataSetReference>
<DataSetName>ManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
<LabelField>ManagementGroupDefaultName</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="StartDate1">
<DataType>DateTime</DataType>
<Prompt>StartDate1</Prompt>
</ReportParameter>
<ReportParameter Name="UTCStartDate1">
<DataType>DateTime</DataType>
<Prompt>UTCStartDate1</Prompt>
</ReportParameter>
<ReportParameter Name="UTCEndDate1">
<DataType>DateTime</DataType>
<Prompt>UTCEndDate1</Prompt>
</ReportParameter>
<ReportParameter Name="HostTypeID">
<DataType>String</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" />
</Values>
</DefaultValue>
<Prompt>HostTypeID</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="Hosts">
<DataType>String</DataType>
<Prompt>Hosts</Prompt>
</ReportParameter>
<ReportParameter Name="HostID">
<DataType>String</DataType>
<Prompt>HostID</Prompt>
</ReportParameter>
</ReportParameters>
<Code><Script>
Const LocTableStringQuery As String = "R/S[@N='{0}']/text()"
Const TimeZoneParameterName As String = "TimeZone"
Dim LocTables As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)
Dim ReportCulture As System.Globalization.CultureInfo

public function FormatNumber(fieldValue, formatString) as string
if (fieldValue is Nothing)
FormatNumber = "Not Available"
else
FormatNumber = Format(fieldValue,formatString)
end if
end function

Protected Overrides Sub OnInit()
LocTables = New System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()
ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))
End Sub

Public Function GetCallingManagementGroupId() As String
Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId
End Function

Public Function GetLocTable(ByVal Name As String) As Microsoft.EnterpriseManagement.Reporting.XmlStringTable
If (LocTables is Nothing) then
LocTables = New System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()
End If
Dim LocTable As Microsoft.EnterpriseManagement.Reporting.XmlStringTable
If Not LocTables.TryGetValue(Name, LocTable) Then
LocTable = New Microsoft.EnterpriseManagement.Reporting.XmlStringTable(LocTableStringQuery, Report.Parameters(Name).Value)
LocTables.Add(Name, LocTable)
End If
Return LocTable
End Function

Public Function GetReportLocLanguageCode() As String
If (ReportCulture is Nothing) then
ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))
End If
Return ReportCulture.ThreeLetterWindowsLanguageName
End Function
</Script></Code>
<Language>=User!Language</Language>
<CodeModules>
<CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>
</CodeModules>
<ConsumeContainerWhitespace>true</ConsumeContainerWhitespace>
<rd:ReportUnitType>Inch</rd:ReportUnitType>
<rd:ReportID>717480b3-f4f4-4581-a9e8-ffc0df38704d</rd:ReportID>
</Report>