This is a modified version of the Microsoft report. The only change is to replace the Microsoft banner with the EMC banner and change any drill through reports to the corresponding EMC SI reports.
| Accessibility | Public |
| Visible | False |
Home
<Report ID="EMC.SI.Report.AvailabilityTime" Accessibility="Public" Visible="false" Target="System!System.Entity">
<Dependencies>
<DataWarehouseScript>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.Script.AvailabilityTime</DataWarehouseScript>
<DataWarehouseDataSet>DataWarehouse!Microsoft.SystemCenter.DataWarehouse.DataSet.State</DataWarehouseDataSet>
<Report>EMC.SI.Report.Availability</Report>
<Report>EMC.SI.Report.AvailabilityMonitor</Report>
<Report>EMC.SI.Report.ConfigurationChange</Report>
<Report>EMC.SI.Report.Downtime</Report>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.BusinessRelativeDateTimePicker</ReportParameterControl>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox</ReportParameterControl>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox</ReportParameterControl>
</Dependencies>
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="2">
<Controls>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">
<ReportParameters>
<ReportParameter name="DataAggregation">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.DataAggregation</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ComboBox">
<ReportParameters>
<ReportParameter name="AggregationType">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.Aggregation</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.BusinessRelativeDateTimePicker">
<ReportParameters>
<ReportParameter name="TimeZone" binding="TimeZone">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TimeZone</Prompt>
</ReportParameter>
<ReportParameter name="TimeZoneName" binding="TimeZoneName"/>
<ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>
<ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.StartDateTime</Prompt>
</ReportParameter>
<ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>
<ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>
<ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>
<ReportParameter name="EndDate_BaseValue" binding="EndDate_BaseValue">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.EndDateTime</Prompt>
</ReportParameter>
<ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>
<ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>
<ReportParameter name="TimeType" binding="TimeType"/>
<ReportParameter name="TimeWeekMap" binding="TimeWeekMap"/>
</ReportParameters>
</Control>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox">
<ReportParameters>
<ReportParameter name="DownTime">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.AvailabilityDownTime</Prompt>
</ReportParameter>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
<Definition>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataWarehouseState">
<rd:DataSourceID>acefcbbb-fdfd-41d4-95e4-79c8531ee7fd</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>=Parameters!StateConnectionString.Value</ConnectString>
</ConnectionProperties>
</DataSource>
<DataSource Name="DataWarehouseMain">
<rd:DataSourceID>e4235c51-407f-4065-8519-a1e57374bc45</rd:DataSourceID>
<DataSourceReference>Data Warehouse Main</DataSourceReference>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<ReportParameters>
<ReportParameter Name="StateDataSetType">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>StateDataSetType</DataSetName>
<ValueField>DatasetTypeId</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>StateDataSetType</DataSetName>
<ValueField>DatasetTypeId</ValueField>
<LabelField>DatasetTypeId</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="StateConnectionString">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>StateDateSetConnection</DataSetName>
<ValueField>ConnectionString</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>StateDateSetConnection</DataSetName>
<ValueField>ConnectionString</ValueField>
<LabelField>DatasetId</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Report">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>LT_Report_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="LT_Table">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_Table_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>LT_Table_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="DownTime">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>=CInt(Code.StateIntervalType.Black)</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>[Down Time]</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>=CInt(Code.StateIntervalType.Yellow)</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.Yellow", "[Yellow]")</Label>
</ParameterValue>
<ParameterValue>
<Value>=CInt(Code.StateIntervalType.ServiceGray)</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.ServiceGray", "[Monitoring unavailable]")</Label>
</ParameterValue>
<ParameterValue>
<Value>=CInt(Code.StateIntervalType.Blue)</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.Blue", "[Blue]")</Label>
</ParameterValue>
<ParameterValue>
<Value>=CInt(Code.StateIntervalType.Black)</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.Black", "[Black]")</Label>
</ParameterValue>
<ParameterValue>
<Value>=CInt(Code.StateIntervalType.Gray)</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.Gray", "[Disabled]")</Label>
</ParameterValue>
<ParameterValue>
<Value>=CInt(Code.StateIntervalType.White)</Value>
<Label>=Code.GetLocTable("LT_Table").GetString("RT.Legend.White", "[White]")</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="AggregationType">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<Prompt>[Aggregation Type]</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>0</Value>
<Label>Hourly</Label>
</ParameterValue>
<ParameterValue>
<Value>1</Value>
<Label>Daily</Label>
</ParameterValue>
<ParameterValue>
<Value>2</Value>
<Label>Monthly</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ManagedEntityMonitorRowId">
<DataType>String</DataType>
<Prompt>ManagedEntityMonitorRowId</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="DataAggregation">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<Prompt>[Aggregation]</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>0</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.AggregationValue_0", "[Hourly]")</Label>
</ParameterValue>
<ParameterValue>
<Value>1</Value>
<Label>=Code.GetLocTable("LT_Report").GetString("R.AggregationValue_1", "[Daily]")</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<Prompt>[Start Date Base]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>[From]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetType">
<DataType>String</DataType>
<Prompt>[Start Date Offset Type]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetValue">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[Start Date Offset]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseType">
<DataType>String</DataType>
<Prompt>[End Date Base]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseValue">
<DataType>DateTime</DataType>
<Prompt>[To]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetType">
<DataType>String</DataType>
<Prompt>[End Date Offset Type]</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetValue">
<DataType>Integer</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[End Date Offset]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>[Time Type]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeWeekMap">
<DataType>String</DataType>
<Prompt>[Week Days]</Prompt>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="TimeZone">
<DataType>String</DataType>
<Prompt>[Time Zone]</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZoneName">
<DataType>String</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>[Time Zone Name]</Prompt>
</ReportParameter>
<ReportParameter Name="Interactive">
<DataType>Boolean</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value>=False</Value>
</Values>
</DefaultValue>
<Prompt>Interactive</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.05in</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:ReportID>ab518a51-343d-46c4-b1f8-4ec65faafd95</rd:ReportID>
<CodeModules>
<CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>
</CodeModules>
<PageWidth>11in</PageWidth>
<DataSets>
<DataSet Name="AvailabilityData">
<Fields>
<Field Name="DateTime">
<DataField>DateTime</DataField>
</Field>
<Field Name="IntervalDurationMilliseconds">
<DataField>IntervalDurationMilliseconds</DataField>
</Field>
<Field Name="InWhiteStateMilliseconds">
<DataField>InWhiteStateMilliseconds</DataField>
</Field>
<Field Name="InGreenStateMilliseconds">
<DataField>InGreenStateMilliseconds</DataField>
</Field>
<Field Name="InYellowStateMilliseconds">
<DataField>InYellowStateMilliseconds</DataField>
</Field>
<Field Name="InRedStateMilliseconds">
<DataField>InRedStateMilliseconds</DataField>
</Field>
<Field Name="InBlackStateMilliseconds">
<DataField>InBlackStateMilliseconds</DataField>
</Field>
<Field Name="InDisabledStateMilliseconds">
<DataField>InDisabledStateMilliseconds</DataField>
</Field>
<Field Name="InPlannedMaintenanceMilliseconds">
<DataField>InPlannedMaintenanceMilliseconds</DataField>
</Field>
<Field Name="InUnplannedMaintenanceMilliseconds">
<DataField>InUnplannedMaintenanceMilliseconds</DataField>
</Field>
<Field Name="HealthServiceUnavailableMilliseconds">
<DataField>HealthServiceUnavailableMilliseconds</DataField>
</Field>
<Field Name="UpTimeMilliseconds">
<Value>
=Fields!InGreenStateMilliseconds.Value +
IIF(Code.IsDownTime(Code.StateIntervalType.Yellow), 0, Fields!InYellowStateMilliseconds.Value) +
IIF(Code.IsDownTime(Code.StateIntervalType.White), 0, Fields!InWhiteStateMilliseconds.Value) +
IIF(Code.IsDownTime(Code.StateIntervalType.Gray), 0, Fields!InDisabledStateMilliseconds.Value) +
IIF(Code.IsDownTime(Code.StateIntervalType.ServiceGray), 0, Fields!HealthServiceUnavailableMilliseconds.Value) +
IIF(Code.IsDownTime(Code.StateIntervalType.Blue), 0, Fields!InPlannedMaintenanceMilliseconds.Value) +
IIF(Code.IsDownTime(Code.StateIntervalType.Black), 0, Fields!InUnplannedMaintenanceMilliseconds.Value)
</Value>
</Field>
<Field Name="DownTimeMilliseconds">
<Value>
=Fields!InRedStateMilliseconds.Value +
IIF(Code.IsDownTime(Code.StateIntervalType.Yellow), Fields!InYellowStateMilliseconds.Value, 0) +
IIF(Code.IsDownTime(Code.StateIntervalType.White), Fields!InWhiteStateMilliseconds.Value, 0) +
IIF(Code.IsDownTime(Code.StateIntervalType.Gray), Fields!InDisabledStateMilliseconds.Value, 0) +
IIF(Code.IsDownTime(Code.StateIntervalType.ServiceGray), Fields!HealthServiceUnavailableMilliseconds.Value, 0) +
IIF(Code.IsDownTime(Code.StateIntervalType.Blue), Fields!InPlannedMaintenanceMilliseconds.Value, 0) +
IIF(Code.IsDownTime(Code.StateIntervalType.Black), Fields!InUnplannedMaintenanceMilliseconds.Value, 0)
</Value>
</Field>
<Field Name="AggregatedDateTime">
<Value>=CDate(Code.FormatAggregatedTimeValue(Code.ToReportDate(Fields!DateTime.Value), Parameters!AggregationType.Value))</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseState</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>Microsoft_SystemCenter_DataWarehouse_Report_Library_AvailabilityTimeReportDataGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</QueryParameter>
<QueryParameter Name="@StartDate">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@DataAggregation">
<Value>=IIF(CInt(Parameters!AggregationType.Value) = Code.AggregationType.Hourly, 0, Parameters!DataAggregation.Value)</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="StateDateSetConnection">
<Fields>
<Field Name="DatasetId">
<DataField>DatasetId</DataField>
</Field>
<Field Name="ServerName">
<DataField>ServerName</DataField>
</Field>
<Field Name="DatabaseName">
<DataField>DatabaseName</DataField>
</Field>
<Field Name="ConnectionString">
<Value>="Data Source=" + Fields!ServerName.Value + ";Initial Catalog=" + Fields!DatabaseName.Value + ";Integrated Security=SSPI"</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>DataRouteGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@DatasetTypeId">
<Value>=Parameters!StateDataSetType.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="LT_Report_Query">
<Fields>
<Field Name="ValueXml">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
</Field>
<Field Name="ValueName">
<Value>="LT"</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Report.Library</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Report.AvailabilityTime</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>R.%</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="LT_Table_Query">
<Fields>
<Field Name="ValueXml">
<DataField>XML_F52E2B61-18A1-11d1-B105-00805F49916B</DataField>
</Field>
<Field Name="ValueName">
<Value>="LT"</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>ReportDisplayStringGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementGroupGuid">
<Value>=Code.GetCallingManagementGroupId()</Value>
</QueryParameter>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Report.Library</Value>
</QueryParameter>
<QueryParameter Name="@ReportSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Report.AvailabilityTime</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>RT.%</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="ReportObject">
<Fields>
<Field Name="MonitorDisplayName">
<DataField>MonitorDisplayName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ManagedEntityDefaultName">
<DataField>ManagedEntityDefaultName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Image">
<DataField>Image</DataField>
<rd:TypeName>System.Byte[]</rd:TypeName>
</Field>
<Field Name="ManagedEntityGuid">
<DataField>ManagedEntityGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="ManagementGroupDefaultName">
<DataField>ManagementGroupDefaultName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ManagedEntityTypeGuid">
<DataField>ManagedEntityTypeGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="DisplayName">
<DataField>DisplayName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ManagementGroupGuid">
<DataField>ManagementGroupGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="Path">
<DataField>Path</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ManagedEntityRowId">
<DataField>ManagedEntityRowId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>
SELECT ISNULL(vDisplayStringMonitor.Name, vMonitor.MonitorDefaultName) AS MonitorDisplayName, vManagedEntity.ManagedEntityDefaultName,
vManagedEntityTypeImage.Image, vManagedEntity.ManagedEntityGuid, vManagementGroup.ManagementGroupDefaultName,
vManagedEntityType.ManagedEntityTypeGuid, ISNULL(vDisplayString.Name, vManagedEntityType.ManagedEntityTypeDefaultName) AS DisplayName,
vManagementGroup.ManagementGroupGuid, vManagedEntity.Path, vManagedEntity.ManagedEntityRowId
FROM vManagedEntityMonitor INNER JOIN
vManagedEntity ON vManagedEntityMonitor.ManagedEntityRowId = vManagedEntity.ManagedEntityRowId INNER JOIN
vMonitor ON vManagedEntityMonitor.MonitorRowId = vMonitor.MonitorRowId INNER JOIN
vManagementGroup ON vManagedEntity.ManagementGroupRowId = vManagementGroup.ManagementGroupRowId INNER JOIN
vManagedEntityType ON vManagedEntity.ManagedEntityTypeRowId = vManagedEntityType.ManagedEntityTypeRowId LEFT OUTER JOIN
vManagedEntityTypeImage ON vManagedEntity.ManagedEntityTypeRowId = vManagedEntityTypeImage.ManagedEntityTypeRowId AND
vManagedEntityTypeImage.ImageCategory = N'u16x16Icon' LEFT OUTER JOIN
vDisplayString ON vManagedEntityType.ManagedEntityTypeGuid = vDisplayString.ElementGuid AND
vDisplayString.LanguageCode = @LanguageCode LEFT OUTER JOIN
vDisplayString AS vDisplayStringMonitor ON vMonitor.MonitorGuid = vDisplayStringMonitor.ElementGuid AND
vDisplayStringMonitor.LanguageCode = @LanguageCode
WHERE (vManagedEntityMonitor.ManagedEntityMonitorRowId = @ManagedEntityMonitorRowId)
</CommandText>
<QueryParameters>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="StateDataSetType">
<Fields>
<Field Name="DatasetTypeId">
<DataField>DatasetTypeId</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>DatasetTypeIdGet</CommandText>
<QueryParameters>
<QueryParameter Name="@ManagementPackSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Library</Value>
</QueryParameter>
<QueryParameter Name="@DatasetTypeSystemName">
<Value>Microsoft.SystemCenter.DataWarehouse.Dataset.State</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="ConfigurationChangesData">
<Fields>
<Field Name="DateTime">
<DataField>DateTime</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="ManagedEntityPropertyRowId">
<DataField>ManagedEntityPropertyRowId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="FromDateTime">
<DataField>FromDateTime</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="ManagedEntityRowId">
<DataField>ManagedEntityRowId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="AggregatedDateTime">
<Value>=CDate(Code.FormatAggregatedTimeValue(Code.ToReportDate(Fields!DateTime.Value), Parameters!AggregationType.Value))</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>
SELECT vDateTime.DateTime, vManagedEntityProperty.ManagedEntityPropertyRowId, vManagedEntityProperty.FromDateTime,
vManagedEntity.ManagedEntityRowId
FROM vDateTime CROSS JOIN
vManagedEntityMonitor LEFT OUTER JOIN
vManagedEntityProperty ON vManagedEntityProperty.FromDateTime BETWEEN vDateTime.DateTime AND DATEADD(Hour, 1,
vDateTime.DateTime) AND vManagedEntityMonitor.ManagedEntityRowId = vManagedEntityProperty.ManagedEntityRowId LEFT OUTER JOIN
vManagedEntity ON vManagedEntity.ManagedEntityRowId = vManagedEntityMonitor.ManagedEntityRowId
WHERE (vDateTime.DateTime >= @StartDate) AND (vDateTime.DateTime < @EndDate) AND (vDateTime.Minute = 0) AND (vDateTime.Date BETWEEN
DATEADD(day, - 1, @StartDate) AND DATEADD(day, 1, @EndDate)) AND
(vManagedEntityMonitor.ManagedEntityMonitorRowId = @ManagedEntityMonitorRowId)
</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Code>
Const LocTableStringQuery As String = "R/S[@N='{0}']/text()"
Const TimeZoneParameterName As String = "TimeZone"
Const SD_BaseTypeParameterName As String = "StartDate_BaseType"
Const SD_BaseValueParameterName As String = "StartDate_BaseValue"
Const SD_OffsetTypeParameterName As String = "StartDate_OffsetType"
Const SD_OffsetValueParameterName As String = "StartDate_OffsetValue"
Const ED_BaseTypeParameterName As String = "EndDate_BaseType"
Const ED_BaseValueParameterName As String = "EndDate_BaseValue"
Const ED_OffsetTypeParameterName As String = "EndDate_OffsetType"
Const ED_OffsetValueParameterName As String = "EndDate_OffsetValue"
Const IsRelativeTimeSupported As Boolean = True
Const TimeTypeParameterName As String = "TimeType"
Const TimeWeekMapParameterName As String = "TimeWeekMap"
Const DataAggregationParameterName As String = "DataAggregation"
Dim LocTables As System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)
Dim ReportTimeZone As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation
Dim ReportStartDate As DateTime
Dim ReportEndDate As DateTime
Dim ReportTime As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
Dim ReportCulture As System.Globalization.CultureInfo
Dim ParameterProcessor As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor
Protected Overrides Sub OnInit()
LocTables = new System.Collections.Generic.Dictionary(Of String, Microsoft.EnterpriseManagement.Reporting.XmlStringTable)()
ReportTimeZone = Nothing
ReportStartDate = DateTime.MinValue
ReportEndDate = DateTime.MinValue
ReportTime = Nothing
ReportCulture = System.Globalization.CultureInfo.GetCultureInfo(Report.User("Language"))
ParameterProcessor = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor(ReportCulture)
End Sub
Public Function GetCallingManagementGroupId() As String
Return Microsoft.EnterpriseManagement.Reporting.ReportingConfiguration.ManagementGroupId
End Function
Public Function GetReportLocLanguageCode() As String
Return ReportCulture.ThreeLetterWindowsLanguageName
End Function
Public Function GetLocTable(Name As String) As Microsoft.EnterpriseManagement.Reporting.XmlStringTable
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 GetReportTimeZone() As Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation
If IsNothing(ReportTimeZone) Then ReportTimeZone = Microsoft.EnterpriseManagement.Reporting.TimeZoneCoreInformation.FromValueString(Report.Parameters(TimeZoneParameterName).Value)
Return ReportTimeZone
End Function
Public Function ToDbDate(ByVal DateValue As DateTime) As DateTime
return GetReportTimeZone.ToUniversalTime(DateValue)
End Function
Public Function ToReportDate(ByVal DateValue As DateTime) As DateTime
return GetReportTimeZone.ToLocalTime(DateValue)
End Function
Public Function GetReportStartDate() As DateTime
If (ReportStartDate = DateTime.MinValue) Then
If (IsRelativeTimeSupported) Then
ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)
Else
ReportStartDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(SD_BaseTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(SD_OffsetTypeParameterName).Value, Report.Parameters(SD_OffsetValueParameterName).Value)
End if
If (CInt(Report.Parameters(DataAggregationParameterName).Value) > 0) Then
ReportStartDate = ReportStartDate.Date
End If
End If
return ReportStartDate
End Function
Public Function GetReportEndDate() As DateTime
If (ReportEndDate = DateTime.MinValue) Then
If (IsRelativeTimeSupported) Then
ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value, Report.Parameters(TimeTypeParameterName).Value)
If IsBusinessHours(GetReportTimeFilter()) Then ReportEndDate = ReportCulture.Calendar.AddDays(ReportEndDate, 1)
Else
ReportEndDate = ParameterProcessor.GetDateTime(ToReportDate(DateTime.UtcNow), Report.Parameters(ED_BaseTypeParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, Report.Parameters(ED_OffsetTypeParameterName).Value, Report.Parameters(ED_OffsetValueParameterName).Value)
End if
If (CInt(Report.Parameters(DataAggregationParameterName).Value) > 0) Then
ReportEndDate = ReportEndDate.Date
End If
End If
return ReportEndDate
End Function
Public Function GetReportTimeFilter() As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
If IsNothing(ReportTime) Then
If (CInt(Report.Parameters(DataAggregationParameterName).Value) = 0)
ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Report.Parameters(TimeTypeParameterName).Value, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))
Else
ReportTime = New Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime(Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Regular, Report.Parameters(SD_BaseValueParameterName).Value, Report.Parameters(ED_BaseValueParameterName).Value, CStr(Join(Report.Parameters(TimeWeekMapParameterName).Value, ",")))
End if
End If
return ReportTime
End Function
Public Function IsBusinessHours(Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As Boolean
return (Not IsNothing(Value)) And (Value.TimeType = Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTimeType.Business)
End Function
Public Function FormatDateTime(Format As String, Value As DateTime) As String
return Value.ToString(Format, ReportCulture)
End Function
Public Function FormatNumber(Format As String, Value As Decimal) As String
return Value.ToString(Format, ReportCulture)
End Function
Public Function FormatString(Format As String, ParamArray Values() as Object) As String
return String.Format(ReportCulture, Format, Values)
End Function
Public Function NullFormatString(Format As String, Value as String) As String
return IIF(String.IsNullOrEmpty(Value), String.Empty, String.Format(ReportCulture, Format, Value))
End Function
Public Function FormatBusinessHours(Format As String, Value As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime) As String
Dim result As String
If IsBusinessHours(Value) Then
Dim firstDay As DayOfWeek
Dim days As System.Collections.Generic.List(Of String)
firstDay = ReportCulture.DateTimeFormat.FirstDayOfWeek
days = new System.Collections.Generic.List(Of String)()
For loopDay As DayOfWeek = DayOfWeek.Sunday To DayOfWeek.Saturday
Dim day As DayOfWeek
day = CType((CInt(loopDay) + CInt(firstDay)) Mod 7, DayOfWeek)
If value.WeekMap.Contains(day) Then days.Add(ReportCulture.DateTimeFormat.GetAbbreviatedDayName(day))
Next loopDay
result = FormatString(Format, DateTime.Today.Add(Value.StartTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), DateTime.Today.Add(Value.EndTime).ToString(ReportCulture.DateTimeFormat.ShortTimePattern), String.Join(",", days.ToArray()))
Else
result = String.Empty
End if
return result
End Function
Public Function BuildXmlValueList(ByVal ValueList() As Object) As String
Return Microsoft.EnterpriseManagement.Reporting.MultiValueParameter.ToXml("Data", "Value", ValueList)
End Function
REM ---------------------------------
Public Enum DataAggregationType
Hourly = 0
Daily = 1
End Enum
REM ---------------------------------
Const DownTimeParameterName As String = "DownTime"
Dim DownTimeTable As System.Collections.Generic.List(Of Integer)
Public Enum StateIntervalType
Red = 0
Green = 1
Yellow = 2
White = 3
Gray = 4
Black = 5
Blue = 6
ServiceGray = 7
End Enum
Public Function IsDownTime(time As StateIntervalType)
Select Case time
Case StateIntervalType.Red
Return True
Case StateIntervalType.Green
Return False
Case Else
If IsNothing(DownTimeTable) Then
DownTimeTable = New System.Collections.Generic.List(Of Integer)()
Dim val As String
For Each val in Report.Parameters(DownTimeParameterName).Value
DownTimeTable.Add(CInt(val))
Next
End If
Return DownTimeTable.Contains(CInt(time))
End Select
End Function
REM ---------------------------------
Public Function FormatTimeInterval(ByVal TimeInSeconds As Integer) As String
Dim Hours, Minutes, Seconds As Integer
Hours = Math.Floor(TimeInSeconds / 3600)
Minutes = Math.Floor((TimeInSeconds Mod 3600) / 60)
Seconds = TimeInSeconds Mod 60
Return FormatString("{0}:{1}:{2}", Hours.ToString(), Minutes.ToString("00"), Seconds.ToString("00"))
End Function
Public Function FormatChartLabel(ByVal LabelValue As Double, ByVal FormatCode As String, ByVal LowThreshold As Double, ByVal HighThreshold As Double, ByVal PointsCount As Double, ByVal PointsThreshold As Double) As String
Dim Result As String
If ((PointsCount <= PointsThreshold) And ((LowThreshold < 0) Or (LabelValue > LowThreshold)) And ((HighThreshold < 0) Or (LabelValue < HighThreshold))) Then
Result = LabelValue.ToString(FormatCode, ReportCulture)
Else
Result = String.Empty
End If
Return Result
End Function
REM ----------------------------------------
Public Enum AggregationType
Hourly = 0
Daily = 1
Monthly = 2
End Enum
Public Function FormatAggregatedTimeValue(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As DateTime
Dim Result As DateTime
Select Case (AggType)
Case AggregationType.Hourly
Result = New DateTime(TimeValue.Year, TimeValue.Month, TimeValue.Day, TimeValue.Hour, 0, 0, ReportCulture.Calendar)
Case AggregationType.Daily
Result = New DateTime(TimeValue.Year, TimeValue.Month, TimeValue.Day, ReportCulture.Calendar)
Case AggregationType.Monthly
Result = New DateTime(TimeValue.Year, TimeValue.Month, 1, ReportCulture.Calendar)
End Select
Return Result
End Function
Public Function FormatAggregatedTimeValueLabel(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As String
Dim Format As String
Select Case (AggType)
Case AggregationType.Hourly
Format = "g"
Case AggregationType.Daily
Format = "d"
Case AggregationType.Monthly
Format = "Y"
End Select
Return TimeValue.ToString(Format, ReportCulture)
End Function
Public Function GetStartDrillTimeValue(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As DateTime
Dim Result As DateTime
Dim StartDate As DateTime
StartDate = GetReportStartDate()
Select Case (AggType)
Case AggregationType.Hourly
Result = StartDate
Case AggregationType.Daily
If TimeValue.Date < StartDate Then Result = StartDate Else Result = TimeValue.Date
Case AggregationType.Monthly
If TimeValue.Date < StartDate Then Result = StartDate Else Result = TimeValue.Date
End Select
If (IsRelativeTimeSupported) Then
Dim TimeFilter As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
TimeFilter = GetReportTimeFilter()
If IsBusinessHours(TimeFilter) Then Result = Result.Add(TimeFilter.StartTime)
End If
Return Result
End Function
Public Function GetEndDrillTimeValue(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As DateTime
Dim Result, EndTimeValue As DateTime
Dim EndDate As DateTime
EndDate = GetReportEndDate()
Select Case (AggType)
Case AggregationType.Hourly
Result = EndDate
Case AggregationType.Daily
EndTimeValue = ReportCulture.Calendar.AddDays(TimeValue.Date, 1)
If EndTimeValue.Date > EndDate Then Result = EndDate Else Result = EndTimeValue.Date
Case AggregationType.Monthly
EndTimeValue = ReportCulture.Calendar.AddMonths(TimeValue.Date, 1)
If EndTimeValue.Date > EndDate Then Result = EndDate Else Result = EndTimeValue.Date
End Select
If (IsRelativeTimeSupported) Then
Dim TimeFilter As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
TimeFilter = GetReportTimeFilter()
If IsBusinessHours(TimeFilter) Then Result = ReportCulture.Calendar.AddDays(Result, -1).Add(TimeFilter.EndTime)
End If
Return Result
End Function
Public Function GetStartPointDrillTimeValue(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As DateTime
Dim Result As DateTime
Dim StartDate As DateTime
StartDate = GetReportStartDate()
Select Case (AggType)
Case AggregationType.Hourly
If TimeValue < StartDate Then Result = StartDate Else Result = TimeValue
Case AggregationType.Daily
If TimeValue.Date < StartDate Then Result = StartDate Else Result = TimeValue.Date
Case AggregationType.Monthly
If TimeValue.Date < StartDate Then Result = StartDate Else Result = TimeValue.Date
End Select
Return Result
End Function
Public Function GetEndPointDrillTimeValue(ByVal TimeValue As DateTime, ByVal AggType As AggregationType) As DateTime
Dim Result, EndTimeValue As DateTime
Dim EndDate As DateTime
EndDate = GetReportEndDate()
Select Case (AggType)
Case AggregationType.Hourly
EndTimeValue = ReportCulture.Calendar.AddHours(TimeValue, 1)
If EndTimeValue > EndDate Then Result = EndDate Else Result = EndTimeValue
Case AggregationType.Daily
EndTimeValue = ReportCulture.Calendar.AddDays(TimeValue.Date, 1)
If EndTimeValue.Date > EndDate Then Result = EndDate Else Result = EndTimeValue.Date
Case AggregationType.Monthly
EndTimeValue = ReportCulture.Calendar.AddMonths(TimeValue.Date, 1)
If EndTimeValue.Date > EndDate Then Result = EndDate Else Result = EndTimeValue.Date
End Select
Return Result
End Function
</Code>
<Width>10.85in</Width>
<Body>
<ReportItems>
<Rectangle Name="rectangle7">
<Left>0.05in</Left>
<ZIndex>9</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>ActionsBox</ToggleItem>
</Visibility>
<ReportItems>
<Rectangle Name="rectangle16">
<Left>0.1in</Left>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>=Parameters!Interactive.Value <> True</Hidden>
</Visibility>
<ReportItems>
<Textbox Name="textbox10">
<Top>0.25in</Top>
<Action>
<Hyperlink>= Microsoft.EnterpriseManagement.Reporting.ConsoleIntegration.CreateConsoleViewLink(First(Fields!ManagementGroupGuid.Value, "ReportObject"), "Microsoft.SystemCenter.HealthView", First(Fields!ManagedEntityTypeGuid.Value, "ReportObject"))</Hyperlink>
</Action>
<Width>1.85in</Width>
<Style>
<Color>Blue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Left>2.65in</Left>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.HealthViewLabel", "[Health View Label]")</Value>
</Textbox>
<Image Name="image2">
<Sizing>AutoSize</Sizing>
<Top>0.05in</Top>
<Width>0.2in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>3</ZIndex>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>../console_views_icon.png</Value>
</Image>
<Textbox Name="textbox43">
<Top>0.25in</Top>
<Action>
<Hyperlink>= Microsoft.EnterpriseManagement.Reporting.ConsoleIntegration.CreateConsoleViewLink(First(Fields!ManagementGroupGuid.Value, "ReportObject"), "Microsoft.SystemCenter.EventView", First(Fields!ManagedEntityGuid.Value, "ReportObject"))</Hyperlink>
</Action>
<Width>1.15in</Width>
<Style>
<Color>Blue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.4in</Left>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.EventViewLabel", "[Event View Label]")</Value>
</Textbox>
<Textbox Name="textbox44">
<Top>0.05in</Top>
<Action>
<Hyperlink>= Microsoft.EnterpriseManagement.Reporting.ConsoleIntegration.CreateConsoleViewLink(First(Fields!ManagementGroupGuid.Value, "ReportObject"), "Microsoft.SystemCenter.StateView", First(Fields!ManagedEntityGuid.Value, "ReportObject"))</Hyperlink>
</Action>
<Width>1.15in</Width>
<Style>
<Color>Blue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.4in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.StateViewLabel", "[State View Label]")</Value>
</Textbox>
<Textbox Name="textbox45">
<Top>0.05in</Top>
<Width>0.9in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>0.45in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.ViewTitle", "[Views]")</Value>
</Textbox>
</ReportItems>
<Top>0.7in</Top>
<Width>10.25in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>Gray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Top>1pt</Top>
</BorderWidth>
</Style>
</Rectangle>
<Rectangle Name="rectangle1">
<Left>0.1in</Left>
<ZIndex>1</ZIndex>
<Visibility>
<Hidden>=Parameters!Interactive.Value <> True</Hidden>
</Visibility>
<ReportItems>
<Image Name="image3">
<Sizing>AutoSize</Sizing>
<Top>0.05in</Top>
<Width>0.2in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>2</ZIndex>
<Left>0.2in</Left>
<Value>../console_tasks_icon.png</Value>
</Image>
<Textbox Name="textbox15">
<Top>0.05in</Top>
<Action>
<Hyperlink>= Microsoft.EnterpriseManagement.Reporting.ConsoleIntegration.CreateConsoleTaskLink(First(Fields!ManagementGroupGuid.Value, "ReportObject"), "Microsoft.SystemCenter.GetFailedWorkflows", First(Fields!ManagedEntityGuid.Value, "ReportObject"))</Hyperlink>
</Action>
<Width>3.05in</Width>
<Style>
<Color>Blue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.4in</Left>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.FailedMonitorsLabel", "[Report Instance failed rules/monitors task]")</Value>
</Textbox>
<Textbox Name="textbox16">
<Top>0.05in</Top>
<Width>0.9in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>0.45in</Left>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.TaskTitle", "[Tasks]")</Value>
</Textbox>
</ReportItems>
<Top>0.45in</Top>
<Width>10.25in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>Gray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Top>1pt</Top>
</BorderWidth>
</Style>
<Height>0.25in</Height>
</Rectangle>
<Rectangle Name="rectangle6">
<Left>0.1in</Left>
<ReportItems>
<Textbox Name="textbox13">
<Top>0.25in</Top>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityMonitor</ReportName>
<Parameters>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="LevelCount">
<Value>=1</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Parameters!StartDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Parameters!EndDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>3.1in</Width>
<Style>
<Color>Blue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.4in</Left>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.MonitorDrillLabel", "[Monitor Drill-Down Label]")</Value>
</Textbox>
<Textbox Name="textbox12">
<Top>0.05in</Top>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.ConfigurationChange</ReportName>
<Parameters>
<Parameter Name="ObjectList">
<Value>="<Data><Objects><Object Use=""Self"">" + First(Fields!ManagedEntityRowId.Value, "ReportObject").ToString() + "</Object></Objects></Data>"</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Parameters!StartDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Parameters!EndDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>3.1in</Width>
<Style>
<Color>Blue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.4in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.ChangesDrillLabel", "[Configuration Changes Drill-Down Report]")</Value>
</Textbox>
<Image Name="reportsImage">
<Sizing>AutoSize</Sizing>
<Top>0.05in</Top>
<Width>0.2in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>2</ZIndex>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>../reports_icon.png</Value>
</Image>
<Textbox Name="textbox38">
<Top>0.05in</Top>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.Downtime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Parameters!StartDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Parameters!EndDate_BaseValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>3.1in</Width>
<Style>
<Color>Blue</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>4.6in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.DowntimeDrillLabel", "[Down Time Drill-Down Report]")</Value>
</Textbox>
<Textbox Name="textbox39">
<Top>0.05in</Top>
<Width>0.9in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>0.45in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.ReportTitle", "[Reports]")</Value>
</Textbox>
</ReportItems>
<Width>10.25in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>Gray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Top>1pt</Top>
<Bottom>1pt</Bottom>
</BorderWidth>
</Style>
<Height>0.45in</Height>
</Rectangle>
</ReportItems>
<Top>3.35in</Top>
<Width>10.65in</Width>
<Height>1.15in</Height>
</Rectangle>
<Chart Name="ChangesChart">
<Legend>
<Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<Position>BottomCenter</Position>
<Layout>Row</Layout>
</Legend>
<CategoryAxis>
<Axis>
<Title/>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorInterval>1</MajorInterval>
<Margin>true</Margin>
</Axis>
</CategoryAxis>
<ZIndex>8</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<DataSetName>ConfigurationChangesData</DataSetName>
<PlotArea>
<Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
</Style>
</PlotArea>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<PointWidth>80</PointWidth>
<Filters>
<Filter>
<FilterExpression>=Code.GetReportTimeFilter().Contains(Code.ToReportDate(Fields!DateTime.Value)) or not (Fields!ManagedEntityPropertyRowId.Value Is Nothing)</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>=True</FilterValue>
</FilterValues>
</Filter>
</Filters>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Change</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Top>4.65in</Top>
<Subtype>Plain</Subtype>
<ValueAxis>
<Axis>
<Title>
<Style>
<FontSize>8pt</FontSize>
</Style>
</Title>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
<Max>10</Max>
<MajorInterval>20</MajorInterval>
<Margin>true</Margin>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<Type>Scatter</Type>
<Width>9.65in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup2">
<GroupExpressions>
<GroupExpression>=Fields!AggregatedDateTime.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!DateTime.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Label>=Code.FormatAggregatedTimeValueLabel(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Palette>SemiTransparent</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value/>
</DataValue>
<DataValue>
<Value>=IIF((COUNT(Fields!ManagedEntityPropertyRowId.Value) > 0), 5, -10)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<Color>Silver</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Rotation>-90</Rotation>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.ConfigurationChange</ReportName>
<Parameters>
<Parameter Name="ObjectList">
<Value>="<Data><Objects><Object Use=""Self"">" + Fields!ManagedEntityRowId.Value.ToString() + "</Object></Objects></Data>"</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartPointDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndPointDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>Goldenrod</BackgroundColor>
<BackgroundGradientEndColor>White</BackgroundGradientEndColor>
<BorderColor>
<Default>Black</Default>
</BorderColor>
<BorderWidth>
<Default>0.25pt</Default>
</BorderWidth>
</Style>
<Marker>
<Type>Triangle</Type>
<Size>10pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Title>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
</Style>
</Title>
<Height>0.2in</Height>
<Left>1in</Left>
</Chart>
<Chart Name="UpTimeChart">
<Legend>
<Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<Position>BottomCenter</Position>
<Layout>Row</Layout>
</Legend>
<CategoryAxis>
<Axis>
<Title/>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>=Min(Fields!AggregatedDateTime.Value)</Min>
<Max>=Max(Fields!AggregatedDateTime.Value)</Max>
<MajorInterval>1</MajorInterval>
<Margin>true</Margin>
</Axis>
</CategoryAxis>
<ZIndex>7</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<DataSetName>AvailabilityData</DataSetName>
<PlotArea>
<Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<PointWidth>80</PointWidth>
<Filters>
<Filter>
<FilterExpression>=Code.GetReportTimeFilter().Contains(Code.ToReportDate(Fields!DateTime.Value))</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>=True</FilterValue>
</FilterValues>
</Filter>
</Filters>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>UpTime</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Top>4.85in</Top>
<Subtype>Plain</Subtype>
<ValueAxis>
<Axis>
<Title>
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Report.UpTimeYLabel", "[Up Time Label]")</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</Title>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Max>100</Max>
<MajorInterval>20</MajorInterval>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<Type>Area</Type>
<Width>10.55in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!AggregatedDateTime.Value</GroupExpression>
</GroupExpressions>
<DataElementName>Value</DataElementName>
<DataCollectionName>Values</DataCollectionName>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!DateTime.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Label>=Code.FormatAggregatedTimeValueLabel(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Palette>SemiTransparent</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!UpTimeMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<Color>Silver</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Rotation>-90</Rotation>
</DataLabel>
<Style>
<BackgroundColor>DarkSeaGreen</BackgroundColor>
<BackgroundGradientEndColor>WhiteSmoke</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BorderColor>
<Default>DarkGreen</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>1.5pt</Default>
</BorderWidth>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Title>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
</Style>
</Title>
<DataElementName>UpTimeChart</DataElementName>
<Height>1.3in</Height>
<Left>0.15in</Left>
</Chart>
<Textbox Name="ActionsBox">
<DataElementOutput>NoOutput</DataElementOutput>
<Top>3.1in</Top>
<Width>10.55in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.15in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Actions.Title", "[Actions]")</Value>
</Textbox>
<Chart Name="AvailabilityChart">
<Legend>
<Visible>true</Visible>
<Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<Position>BottomCenter</Position>
<Layout>Table</Layout>
</Legend>
<CategoryAxis>
<Axis>
<Title/>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>=Min(Fields!AggregatedDateTime.Value)</Min>
<Max>=Max(Fields!AggregatedDateTime.Value)</Max>
<MajorInterval>1</MajorInterval>
<LogScale>true</LogScale>
<Margin>true</Margin>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<ZIndex>5</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<DataSetName>AvailabilityData</DataSetName>
<PlotArea>
<Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<PointWidth>80</PointWidth>
<Filters>
<Filter>
<FilterExpression>=Code.GetReportTimeFilter().Contains(Code.ToReportDate(Fields!DateTime.Value))</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>=True</FilterValue>
</FilterValues>
</Filter>
</Filters>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.White), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.White", "[White]"))</Label>
</StaticMember>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.Gray), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.Gray", "[Gray]"))</Label>
</StaticMember>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.ServiceGray), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.ServiceGray", "[Monitoring unavailable]"))</Label>
</StaticMember>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.Green), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.Green", "[Green]"))</Label>
</StaticMember>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.Yellow), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.Yellow", "[Yellow]"))</Label>
</StaticMember>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.Red), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.Red", "[Red]"))</Label>
</StaticMember>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.Black), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.Black", "[Black]"))</Label>
</StaticMember>
<StaticMember>
<Label>=Code.FormatString(Code.GetLocTable("LT_Report").GetString(IIF(Code.IsDownTime(Code.StateIntervalType.Blue), "R.DownTimeFormat", "R.UpTimeFormat"), "{0}"), Code.GetLocTable("LT_Table").GetString("RT.Legend.Blue", "[Blue]"))</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<Top>6.15in</Top>
<Subtype>PercentStacked</Subtype>
<ValueAxis>
<Axis>
<Title>
<Caption>=Code.GetLocTable("LT_Table").GetString("RT.Report.AvailYLabel", "[Availability Label]")</Caption>
<Style>
<FontSize>8pt</FontSize>
</Style>
</Title>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
</Style>
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Max>100</Max>
<MajorInterval>20</MajorInterval>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<Type>Column</Type>
<Width>10.55in</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="DateGroup">
<GroupExpressions>
<GroupExpression>=Fields!AggregatedDateTime.Value</GroupExpression>
</GroupExpressions>
<DataElementName>Value</DataElementName>
<DataCollectionName>Values</DataCollectionName>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!DateTime.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<Label>=Code.FormatAggregatedTimeValueLabel(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Palette>SemiTransparent</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!InWhiteStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!InWhiteStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>White</BackgroundColor>
<BackgroundGradientEndColor>LightGrey</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
<DataElementName>InWhiteState</DataElementName>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!InDisabledStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!InDisabledStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BackgroundGradientEndColor>Gray</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
<DataElementName>InDisabledState</DataElementName>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!HealthServiceUnavailableMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!HealthServiceUnavailableMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>DarkGray</BackgroundColor>
<BackgroundGradientEndColor>#404040</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
<DataElementName>InDisabledState</DataElementName>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!InGreenStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!InGreenStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Rotation>-90</Rotation>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>DarkSeaGreen</BackgroundColor>
<BackgroundGradientEndColor>ForestGreen</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
<DataElementName>InGreenState</DataElementName>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!InYellowStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!InYellowStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Rotation>-90</Rotation>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>Gold</BackgroundColor>
<BackgroundGradientEndColor>Olive</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
<DataElementName>InYellowState</DataElementName>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!InRedStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!InRedStateMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Rotation>-90</Rotation>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>IndianRed</BackgroundColor>
<BackgroundGradientEndColor>Firebrick</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
<DataElementName>InRedState</DataElementName>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!InUnplannedMaintenanceMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<Color>White</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!InUnplannedMaintenanceMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Rotation>-90</Rotation>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>DimGray</BackgroundColor>
<BackgroundGradientEndColor>Black</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
<DataElementName>InBlackState</DataElementName>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!InPlannedMaintenanceMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value)</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<Color>White</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<FontWeight>600</FontWeight>
</Style>
<Value>=Code.FormatChartLabel(Sum(Fields!InPlannedMaintenanceMilliseconds.Value) * 100 / Sum(Fields!IntervalDurationMilliseconds.Value), "F", 10, 100, CountDistinct(Fields!AggregatedDateTime.Value, "AvailabilityData"), 30)</Value>
<Visible>true</Visible>
</DataLabel>
<Action>
<Drillthrough>
<ReportName>EMC.SI.Report.AvailabilityTime</ReportName>
<Parameters>
<Parameter Name="DownTime">
<Value>=Parameters!DownTime.Value</Value>
</Parameter>
<Parameter Name="AggregationType">
<Value>=IIF(Parameters!AggregationType.Value > 0, Parameters!AggregationType.Value - 1, 0)</Value>
</Parameter>
<Parameter Name="ManagedEntityMonitorRowId">
<Value>=Parameters!ManagedEntityMonitorRowId.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="StartDate_BaseValue">
<Value>=Code.GetStartDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>Fixed</Value>
</Parameter>
<Parameter Name="EndDate_BaseValue">
<Value>=Code.GetEndDrillTimeValue(Fields!AggregatedDateTime.Value, Parameters!AggregationType.Value)</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>None</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>0</Value>
</Parameter>
<Parameter Name="TimeType">
<Value>=Parameters!TimeType.Value</Value>
</Parameter>
<Parameter Name="TimeWeekMap">
<Value>=Parameters!TimeWeekMap.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="Interactive">
<Value>=Parameters!Interactive.Value</Value>
</Parameter>
<Parameter Name="DataAggregation">
<Value>=Parameters!DataAggregation.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BackgroundColor>CornflowerBlue</BackgroundColor>
<BackgroundGradientEndColor>Blue</BackgroundGradientEndColor>
<BackgroundGradientType>LeftRight</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
<Title>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>12pt</FontSize>
<FontWeight>700</FontWeight>
</Style>
</Title>
<DataElementName>StateChart</DataElementName>
<Left>0.15in</Left>
</Chart>
<Rectangle Name="rectangle5">
<Left>0.15in</Left>
<ZIndex>4</ZIndex>
<Top>1.4in</Top>
<Width>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
</Style>
<Height>0.05in</Height>
</Rectangle>
<Rectangle Name="rectangle4">
<Left>0.15in</Left>
<ZIndex>3</ZIndex>
<ReportItems>
<Textbox Name="reportDescriptionTitle">
<DataElementOutput>NoOutput</DataElementOutput>
<Top>0.3in</Top>
<Width>10.5in</Width>
<Style>
<Color>DimGray</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Code.GetLocTable("LT_Report").GetString("R.DescriptionTitle", "[Report Description Title]")</Value>
</Textbox>
<Textbox Name="reportTitle">
<DataElementOutput>Output</DataElementOutput>
<Top>0.05in</Top>
<Width>10.3in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>11pt</FontSize>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<DataElementName>Title</DataElementName>
<Height>0.25in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Title", "[Report Title]")</Value>
</Textbox>
</ReportItems>
<Top>0.7in</Top>
<Width>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.5in</Height>
</Rectangle>
<Rectangle Name="rectangle3">
<Left>0.15in</Left>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>reportDescriptionTitle</ToggleItem>
</Visibility>
<ReportItems>
<Textbox Name="reportDescription">
<DataElementOutput>NoOutput</DataElementOutput>
<Width>10.3in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Value>=Code.GetLocTable("LT_Report").GetString("R.Description", "[Report Description]")</Value>
</Textbox>
</ReportItems>
<Top>1.2in</Top>
<Width>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.2in</Height>
</Rectangle>
<Rectangle Name="rectangle2">
<Left>0.15in</Left>
<ZIndex>1</ZIndex>
<ReportItems>
<Textbox Name="textbox93">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>26</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<DataElementName>Aggregation</DataElementName>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.AggregationValue_" + IIF(CInt(Parameters!AggregationType.Value) > 0, Parameters!DataAggregation.Value.ToString(), "0"), "[" + IIF(CInt(Parameters!AggregationType.Value) > 0, Parameters!DataAggregation.Value.ToString(), "0") + "]")</Value>
</Textbox>
<Textbox Name="textbox94">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>25</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox95">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>24</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.AggregationLabel", "[Data Aggregation]")</Value>
</Textbox>
<Textbox Name="textbox29">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>1.05in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>23</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.35in</Left>
<DataElementName>ManagementGroup</DataElementName>
<Height>0.2in</Height>
<Value>=First(Fields!ManagementGroupDefaultName.Value, "ReportObject")</Value>
</Textbox>
<Textbox Name="textbox24">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>1.05in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>22</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.3in</Left>
<DataElementName>Path</DataElementName>
<Height>0.2in</Height>
<Value>=First(Fields!Path.Value, "ReportObject")</Value>
</Textbox>
<Textbox Name="textbox25">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>1.05in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>21</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.25in</Left>
<DataElementName>Type</DataElementName>
<Height>0.2in</Height>
<Value>=First(Fields!DisplayName.Value, "ReportObject")</Value>
</Textbox>
<Textbox Name="textbox20">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>1.05in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>20</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<DataElementName>Name</DataElementName>
<Height>0.2in</Height>
<Value>=First(Fields!ManagedEntityDefaultName.Value, "ReportObject")</Value>
</Textbox>
<Textbox Name="textbox36">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>19</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.15in</Left>
<DataElementName>BusinessHours</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatBusinessHours("{2} {0}-{1}", Code.GetReportTimeFilter())</Value>
</Textbox>
<Textbox Name="textbox17">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>18</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.1in</Left>
<DataElementName>TimeZone</DataElementName>
<Height>0.2in</Height>
<Value>=Parameters!TimeZoneName.Value</Value>
</Textbox>
<Textbox Name="textbox18">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>17</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.05in</Left>
<DataElementName>EndDate</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.GetReportEndDate())</Value>
</Textbox>
<Textbox Name="textbox19">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.05in</Width>
<Style>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>16</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>StartDate</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.GetReportStartDate())</Value>
</Textbox>
<Textbox Name="textbox4">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1.25in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>15</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<DataElementName>Monitor</DataElementName>
<Height>0.2in</Height>
<Value>=First(Fields!MonitorDisplayName.Value, "ReportObject")</Value>
</Textbox>
<Textbox Name="textbox5">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1.25in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.MonitorLabel", "[Monitor Label]")</Value>
</Textbox>
<Textbox Name="textbox6">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1.25in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox3">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1.05in</Top>
<Width>8.25in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Left>2.15in</Left>
<DataElementName>DisplayName2</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.ObjectFormatLine2", "{0} {1}"), First(Fields!ManagementGroupDefaultName.Value, "ReportObject"), Code.NullFormatString(Code.GetLocTable("LT_Report").GetString("R.ObjectFormatLine2Path", "| {0}"), First(Fields!Path.Value, "ReportObject")))</Value>
</Textbox>
<Textbox Name="textbox27">
<DataElementOutput>NoOutput</DataElementOutput>
<Visibility>
<Hidden>=Not Code.IsBusinessHours(Code.GetReportTimeFilter())</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.65in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>11</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Value>=Code.FormatBusinessHours(Code.GetLocTable("LT_Report").GetString("R.BusinessTimeFormat", "{2} {0} - {1}"), Code.GetReportTimeFilter())</Value>
</Textbox>
<Image Name="parameterBottomImage">
<Sizing>AutoSize</Sizing>
<Top>1.5in</Top>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>10</ZIndex>
<Value>../gradient_landscape.gif</Value>
</Image>
<Textbox Name="textbox14">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<Width>8.25in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>9</ZIndex>
<CanGrow>true</CanGrow>
<Left>2.15in</Left>
<DataElementName>DisplayName1</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.ObjectFormatLine1", "{0}: {1}"), First(Fields!DisplayName.Value, "ReportObject"), First(Fields!ManagedEntityDefaultName.Value, "ReportObject"))</Value>
</Textbox>
<Textbox Name="textbox11">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>8</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="objectsParameterTitle">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.85in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ObjectLabel", "[Report Object Label]")</Value>
</Textbox>
<Textbox Name="textbox9">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<DataElementName>Created</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.ToReportDate(DateTime.UtcNow))</Value>
</Textbox>
<Textbox Name="textbox7">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox2">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<Width>0.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox1">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.GeneratedTimeLabel", "[Report Generated Time Label]")</Value>
</Textbox>
<Textbox Name="textbox28">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.StartEndTimeFormat", "{0} - {1}"), Code.FormatDateTime(IIf(Code.IsBusinessHours(Code.GetReportTimeFilter()) Or ((CInt(Parameters!DataAggregation.Value) > 0) And (CInt(Parameters!AggregationType.Value) > 0)), "d", "g"), Code.GetReportStartDate()), Code.FormatDateTime(IIf(Code.IsBusinessHours(Code.GetReportTimeFilter()) Or ((CInt(Parameters!DataAggregation.Value) > 0) And (CInt(Parameters!AggregationType.Value) > 0)), "d", "g"), Code.GetReportEndDate()))</Value>
</Textbox>
<Textbox Name="textbox26">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>1.65in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.StartEndTimeLabel", "[Report Start/End Time Label]")</Value>
</Textbox>
<Image Name="image1">
<Sizing>FitProportional</Sizing>
<Top>0.85in</Top>
<Width>0.2in</Width>
<MIMEType>image/png</MIMEType>
<Source>Database</Source>
<Style/>
<Left>1.95in</Left>
<Height>0.4in</Height>
<Value>=First(Fields!Image.Value, "ReportObject")</Value>
</Image>
</ReportItems>
<Top>1.45in</Top>
<Width>10.55in</Width>
<Height>1.55in</Height>
</Rectangle>
<Image Name="banner_image">
<Sizing>AutoSize</Sizing>
<Top>0.05in</Top>
<Width>10.55208in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<Left>0.15in</Left>
<Height>0.65in</Height>
<Value>..\banner_landscape.jpg</Value>
</Image>
</ReportItems>
<Height>10in</Height>
</Body>
<Language>en-US</Language>
<PageFooter>
<PrintOnFirstPage>true</PrintOnFirstPage>
<ReportItems>
<Textbox Name="textbox8">
<Top>0.1in</Top>
<Width>1.7in</Width>
<Style>
<Color>DimGray</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>8.95in</Left>
<Height>0.1875in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.PageFormat", "{0}/{1}"), Globals!PageNumber, Globals!TotalPages)</Value>
</Textbox>
<Textbox Name="textbox37">
<Top>0.1in</Top>
<Width>8.75in</Width>
<Style>
<Color>DimGray</Color>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>0.15in</Left>
<Height>0.1875in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.TimeZoneFormat", "{0}"), Parameters!TimeZoneName.Value)</Value>
</Textbox>
</ReportItems>
<Height>0.35in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
</PageFooter>
<PageHeight>8.5in</PageHeight>
</Report>
</Definition>
<ReportStrings>
<ReportString ID="R.AggregationLabel"/>
<ReportString ID="R.AggregationValue_0"/>
<ReportString ID="R.AggregationValue_1"/>
<ReportString ID="R.BusinessTimeFormat"/>
<ReportString ID="R.Description"/>
<ReportString ID="R.DescriptionTitle"/>
<ReportString ID="R.DownTimeFormat"/>
<ReportString ID="R.GeneratedTimeLabel"/>
<ReportString ID="R.MonitorLabel"/>
<ReportString ID="R.ObjectFormatLine1"/>
<ReportString ID="R.ObjectFormatLine2"/>
<ReportString ID="R.ObjectFormatLine2Path"/>
<ReportString ID="R.ObjectLabel"/>
<ReportString ID="R.PageFormat"/>
<ReportString ID="R.StartEndTimeFormat"/>
<ReportString ID="R.StartEndTimeLabel"/>
<ReportString ID="R.TimeZoneFormat"/>
<ReportString ID="R.Title"/>
<ReportString ID="R.UpTimeFormat"/>
<ReportString ID="RT.Actions.ChangesDrillLabel"/>
<ReportString ID="RT.Actions.DowntimeDrillLabel"/>
<ReportString ID="RT.Actions.EventViewLabel"/>
<ReportString ID="RT.Actions.FailedMonitorsLabel"/>
<ReportString ID="RT.Actions.HealthViewLabel"/>
<ReportString ID="RT.Actions.MonitorDrillLabel"/>
<ReportString ID="RT.Actions.ReportTitle"/>
<ReportString ID="RT.Actions.StateViewLabel"/>
<ReportString ID="RT.Actions.TaskTitle"/>
<ReportString ID="RT.Actions.Title"/>
<ReportString ID="RT.Actions.ViewTitle"/>
<ReportString ID="RT.Legend.Black"/>
<ReportString ID="RT.Legend.Blue"/>
<ReportString ID="RT.Legend.Gray"/>
<ReportString ID="RT.Legend.Green"/>
<ReportString ID="RT.Legend.Red"/>
<ReportString ID="RT.Legend.ServiceGray"/>
<ReportString ID="RT.Legend.White"/>
<ReportString ID="RT.Legend.Yellow"/>
<ReportString ID="RT.Report.AvailYLabel"/>
<ReportString ID="RT.Report.UpTimeYLabel"/>
</ReportStrings>
</Report>