This is the base report for the EMC SI Most Common Alerts report. It limits the alerts to the EMC SI management packs.
| Accessibility | Public |
| Visible | False |
Home
<Report ID="EMC.SI.Report.MostCommonAlerts" Accessibility="Public" Visible="false" Target="System!System.Entity">
<Dependencies>
<DataWarehouseScript>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.Script.MostCommonAlerts</DataWarehouseScript>
<DataWarehouseScript>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.Script.MostCommonAlertsGraph</DataWarehouseScript>
<DataWarehouseDataSet>DataWarehouse!Microsoft.SystemCenter.DataWarehouse.DataSet.Alert</DataWarehouseDataSet>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.CheckedListBox</ReportParameterControl>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.NumericUpDown</ReportParameterControl>
<ReportParameterControl>ReportLibrary!Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker</ReportParameterControl>
</Dependencies>
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="6">
<Controls>
<Control columnSpan="2" rowSpan="3" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker">
<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"/>
</ReportParameters>
</Control>
<Control columnSpan="2" rowSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.NumericUpDown">
<ReportParameters>
<ReportParameter name="AlertThreshold">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.TopAlgorithmParameter</Prompt>
</ReportParameter>
</ReportParameters>
<Properties>
<Property name="Minimum">
<Value>1</Value>
</Property>
<Property name="Maximum">
<Value>100</Value>
</Property>
</Properties>
</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="DataWarehouseAlert">
<rd:DataSourceID>f3cc9622-72b4-42e7-8cf7-eb5d33e39d43</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString>=Parameters!AlertConnectionString.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="AlertDataSetType">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>AlertDataSetType</DataSetName>
<ValueField>DatasetTypeId</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>AlertDataSetType</DataSetName>
<ValueField>DatasetTypeId</ValueField>
<LabelField>DatasetTypeId</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="AlertConnectionString">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>AlertDateSetConnection</DataSetName>
<ValueField>ConnectionString</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>AlertDateSetConnection</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="AlertThreshold">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>5</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Alert Threshold</Prompt>
</ReportParameter>
<ReportParameter Name="ManagementPackId">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>ManagementPackList</DataSetName>
<ValueField>ManagementPackRowId</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>[Management Pack]</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>ManagementPackList</DataSetName>
<ValueField>ManagementPackRowId</ValueField>
<LabelField>DisplayName</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
</ReportParameter>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<Prompt>[Start Date Base]</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseValue">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>=Now()</Value>
</Values>
</DefaultValue>
<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>
<DefaultValue>
<Values>
<Value>=Now()</Value>
</Values>
</DefaultValue>
<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="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>8f50a391-ada0-4f57-9df7-47abe174f994</rd:ReportID>
<CodeModules>
<CodeModule>Microsoft.EnterpriseManagement.Reporting.Code, Version=6.0.0.0, Culture=neutral</CodeModule>
</CodeModules>
<DataSets>
<DataSet Name="AlertDateSetConnection">
<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!AlertDataSetType.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="AlertDataSetType">
<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.Alert</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.MostCommonAlerts</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>
<rd:TypeName>System.String</rd:TypeName>
</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.MostCommonAlerts</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>RT.%</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="ObjectList">
<Fields>
<Field Name="ManagementPackRowId">
<DataField>ManagementPackRowId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="ManagementPackVersionIndependentGuid">
<DataField>ManagementPackVersionIndependentGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="ManagementPackSystemName">
<DataField>ManagementPackSystemName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="DisplayName">
<DataField>DisplayName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ManagementPackDefaultDescription">
<DataField>ManagementPackDefaultDescription</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="PublicKeyToken">
<DataField>PublicKeyToken</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="SealedInd">
<DataField>SealedInd</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="DWCreatedDateTime">
<DataField>DWCreatedDateTime</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="DWLastModifiedDateTime">
<DataField>DWLastModifiedDateTime</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="DWLastModifiedByManagementGroupGuid">
<DataField>DWLastModifiedByManagementGroupGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>
SELECT vManagementPack.ManagementPackRowId, vManagementPack.ManagementPackVersionIndependentGuid, vManagementPack.ManagementPackSystemName,
ISNULL(vDisplayString.Name, vManagementPack.ManagementPackDefaultName) AS DisplayName, vManagementPack.ManagementPackDefaultDescription,
vManagementPack.PublicKeyToken, vManagementPack.SealedInd, vManagementPack.DWCreatedDateTime, vManagementPack.DWLastModifiedDateTime,
vManagementPack.DWLastModifiedByManagementGroupGuid
FROM vManagementPack LEFT OUTER JOIN
vDisplayString ON vManagementPack.ManagementPackVersionIndependentGuid = vDisplayString.ElementGuid AND
vDisplayString.LanguageCode = @LanguageCode
WHERE (vManagementPack.ManagementPackRowId IN (@ManagementPackId))
</CommandText>
<QueryParameters>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@ManagementPackId">
<Value>=Parameters!ManagementPackId.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="CommonAlertsDetail">
<Fields>
<Field Name="WorkflowRowId">
<DataField>WorkflowRowId</DataField>
</Field>
<Field Name="AlertName">
<DataField>AlertName</DataField>
</Field>
<Field Name="AlertDescription">
<DataField>AlertDescription</DataField>
</Field>
<Field Name="ManagementPackRowId">
<DataField>ManagementPackRowId</DataField>
</Field>
<Field Name="MPName">
<DataField>MPName</DataField>
</Field>
<Field Name="ManagementPackDefaultDescription">
<DataField>ManagementPackDefaultDescription</DataField>
</Field>
<Field Name="MonitorGuid">
<DataField>MonitorGuid</DataField>
</Field>
<Field Name="MonitorName">
<DataField>MonitorName</DataField>
</Field>
<Field Name="RuleGuid">
<DataField>RuleGuid</DataField>
</Field>
<Field Name="RuleName">
<DataField>RuleName</DataField>
</Field>
<Field Name="TotalTTR">
<DataField>TotalTTR</DataField>
</Field>
<Field Name="AverageTTR">
<DataField>AverageTTR</DataField>
</Field>
<Field Name="RepeatCount">
<DataField>RepeatCount</DataField>
</Field>
<Field Name="TotalAlerts">
<DataField>TotalAlerts</DataField>
</Field>
<Field Name="ActivityPct">
<DataField>ActivityPct</DataField>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseAlert</DataSourceName>
<CommandText>
SET NOCOUNT ON
--===============================================================
-- DECLARE LOCAL VARIABLES
--===============================================================
DECLARE @TotalAlerts DECIMAL
DECLARE @Error INT
--===============================================================
-- CREATE TEMP TABLES
--===============================================================
CREATE TABLE #tmpObjectList (ManagementPackRowId INT)
CREATE TABLE #tmpAlertList ( AlertGuid UNIQUEIDENTIFIER )
--HANDLE ERRORS
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
--===============================================================
-- INSERT OBJECT ID's INTO TEMP TABLES
--===============================================================
DECLARE @ObjectListXml XML
SET @ObjectListXml = @ObjectList
INSERT INTO #tmpObjectList (ManagementPackRowId)
SELECT ObjectList.ManagementPackRowId.value('.', 'int')
FROM @ObjectListXml.nodes('/Data/Value') AS ObjectList(ManagementPackRowId)
--===============================================================
-- INSERT ALERT ID's INTO TEMP TABLES
--===============================================================
INSERT INTO #tmpAlertList ( AlertGuid )
SELECT DISTINCT vAlert.AlertGuid
FROM Alert.vAlert vAlert
LEFT OUTER JOIN dbo.vMonitor vMonitor ON (vAlert.WorkflowRowId = vMonitor.MonitorRowId)
AND (vAlert.MonitorAlertInd = 1)
LEFT OUTER JOIN dbo.vRule vRule ON (vAlert.WorkflowRowId = vRule.RuleRowId)
AND (vAlert.MonitorAlertInd = 0)
INNER JOIN dbo.vManagementPack vMP ON (CASE
WHEN vAlert.MonitorAlertInd = 1 THEN vMonitor.ManagementPackRowId
ELSE vRule.ManagementPackRowId
END) = vMP.ManagementPackRowId
INNER JOIN #tmpObjectList ON vMP.ManagementPackRowId = #tmpObjectList.ManagementPackRowId
WHERE --Filter by datetime
( (vAlert.RaisedDateTime >= @StartDate) AND (vAlert.RaisedDateTime < @EndDate) )
GROUP BY vAlert.AlertGuid
--HANDLE ERRORS
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
--===============================================================
-- SET LOCAL VARIABLES
--===============================================================
SET @TotalAlerts = (SELECT COUNT(*) FROM #tmpAlertList)
--===============================================================
-- FINAL RESULT SET
--===============================================================
SELECT _vAlert.WorkflowRowId,
_vAlert.AlertName,
_vAlert.ManagementPackRowId,
ISNULL(vDisplayStringMP.Name,vMP.ManagementPackDefaultName) AS MPName,
vMP.ManagementPackDefaultDescription,
_vAlert.MonitorGuid,
ISNULL(vDisplayStringMonitor.Name,vMonitor.MonitorDefaultName) AS MonitorName,
_vAlert.RuleGuid,
ISNULL(vDisplayStringRule.Name,vRule.RuleDefaultName) AS RuleName,
_vAlert.TotalTTR,
_vAlert.AverageTTR,
_vAlert.RepeatCount,
@TotalAlerts AS TotalAlerts,
CASE
WHEN ISNULL(@TotalAlerts,0) <> 0 THEN (_vAlert.RepeatCount/@TotalAlerts)
ELSE 0
END AS ActivityPct
FROM
(
SELECT subAlerts.WorkflowRowId,
subAlerts.AlertName,
vMP.ManagementPackRowId,
vMonitor.MonitorGuid,
vRule.RuleGuid,
SUM(vAlertRS.TimeFromRaisedSeconds) / 60 AS TotalTTR,
AVG(vAlertRS.TimeFromRaisedSeconds) / 60 AS AverageTTR,
COUNT(*) AS RepeatCount,
CASE
WHEN @Threshold=0 THEN 0
ELSE DENSE_RANK() OVER(PARTITION BY 1 ORDER BY COUNT(*) DESC)
END AS RowNum
FROM Alert.vAlert subAlerts
INNER JOIN #tmpAlertList ON subAlerts.AlertGuid = #tmpAlertList.AlertGuid
LEFT OUTER JOIN dbo.vMonitor vMonitor ON (subAlerts.WorkflowRowId = vMonitor.MonitorRowId)
AND (subAlerts.MonitorAlertInd = 1)
LEFT OUTER JOIN dbo.vRule vRule ON (subAlerts.WorkflowRowId = vRule.RuleRowId)
AND (subAlerts.MonitorAlertInd = 0)
LEFT OUTER JOIN Alert.vAlertResolutionState vAlertRS ON subAlerts.AlertGuid = vAlertRS.AlertGuid
AND vAlertRS.ResolutionState=255
INNER JOIN dbo.vManagementPack vMP ON (CASE
WHEN subAlerts.MonitorAlertInd = 1 THEN vMonitor.ManagementPackRowId
ELSE vRule.ManagementPackRowId
END) = vMP.ManagementPackRowId
GROUP BY subAlerts.WorkflowRowId,
subAlerts.AlertName,
vMP.ManagementPackRowId,
vMonitor.MonitorGuid,
vRule.RuleGuid
) AS _vAlert
LEFT OUTER JOIN dbo.vMonitor vMonitor ON _vAlert.MonitorGuid = vMonitor.MonitorGuid
LEFT OUTER JOIN dbo.vRule vRule ON _vAlert.RuleGuid = vRule.RuleGuid
INNER JOIN dbo.vManagementPack vMP ON _vAlert.ManagementPackRowId = vMP.ManagementPackRowId
LEFT OUTER JOIN dbo.vDisplayString vDisplayStringMonitor ON vMonitor.MonitorGuid = vDisplayStringMonitor.ElementGuid AND vDisplayStringMonitor.LanguageCode = @LanguageCode
LEFT OUTER JOIN dbo.vDisplayString vDisplayStringRule ON vRule.RuleGuid = vDisplayStringRule.ElementGuid AND vDisplayStringRule.LanguageCode = @LanguageCode
LEFT OUTER JOIN dbo.vDisplayString vDisplayStringMP ON vMP.ManagementPackVersionIndependentGuid = vDisplayStringMP.ElementGuid AND vDisplayStringMP.LanguageCode = @LanguageCode
WHERE _vAlert.RowNum <= @Threshold
ORDER BY vMP.ManagementPackDefaultName DESC
--HANDLE ERRORS
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
--===============================================================
-- ERROR HANDELING AND TEMP CLEANUP
--===============================================================
QuitError:
DROP TABLE #tmpObjectList
DROP TABLE #tmpAlertList
</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@Threshold">
<Value>=Parameters!AlertThreshold.Value</Value>
</QueryParameter>
<QueryParameter Name="@ObjectList">
<Value>=Code.BuildXmlValueList(Parameters!ManagementPackId.Value)</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="CommonAlertsSummary">
<Fields>
<Field Name="AlertGuid">
<DataField>AlertGuid</DataField>
</Field>
<Field Name="AlertProblemGuid">
<DataField>AlertProblemGuid</DataField>
</Field>
<Field Name="AlertName">
<DataField>AlertName</DataField>
</Field>
<Field Name="TotalTTR">
<DataField>TotalTTR</DataField>
</Field>
<Field Name="AverageTTR">
<DataField>AverageTTR</DataField>
</Field>
<Field Name="RepeatCount">
<DataField>RepeatCount</DataField>
</Field>
<Field Name="TotalAlerts">
<DataField>TotalAlerts</DataField>
</Field>
<Field Name="ActivityPct">
<DataField>ActivityPct</DataField>
</Field>
<Field Name="RowNum">
<DataField>RowNum</DataField>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseAlert</DataSourceName>
<CommandText>
SET NOCOUNT ON
--===============================================================
-- DECLARE LOCAL VARIABLES
--===============================================================
DECLARE @TotalAlerts DECIMAL
DECLARE @Error INT
--===============================================================
-- RESET @Threshold
--===============================================================
SET @Threshold = CASE
WHEN @Threshold = 0 OR @Threshold > 25 THEN 25
ELSE @Threshold
END
--===============================================================
-- CREATE TEMP TABLES
--===============================================================
CREATE TABLE #tmpObjectList (ManagementPackRowId INT)
CREATE TABLE #tmpAlertList ( AlertGuid UNIQUEIDENTIFIER )
--HANDLE ERRORS
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
--===============================================================
-- INSERT OBJECT ID's INTO TEMP TABLES
--===============================================================
DECLARE @ObjectListXml XML
SET @ObjectListXml = @ObjectList
INSERT INTO #tmpObjectList (ManagementPackRowId)
SELECT ObjectList.ManagementPackRowId.value('.', 'int')
FROM @ObjectListXml.nodes('/Data/Value') AS ObjectList(ManagementPackRowId)
--===============================================================
-- INSERT ALERT ID's INTO TEMP TABLES
--===============================================================
INSERT INTO #tmpAlertList ( AlertGuid )
SELECT DISTINCT vAlert.AlertGuid
FROM Alert.vAlert vAlert
LEFT OUTER JOIN dbo.vMonitor vMonitor ON (vAlert.WorkflowRowId = vMonitor.MonitorRowId)
AND (vAlert.MonitorAlertInd = 1)
LEFT OUTER JOIN dbo.vRule vRule ON (vAlert.WorkflowRowId = vRule.RuleRowId)
AND (vAlert.MonitorAlertInd = 0)
INNER JOIN dbo.vManagementPack vMP ON (CASE
WHEN vAlert.MonitorAlertInd = 1 THEN vMonitor.ManagementPackRowId
ELSE vRule.ManagementPackRowId
END) = vMP.ManagementPackRowId
INNER JOIN #tmpObjectList ON vMP.ManagementPackRowId = #tmpObjectList.ManagementPackRowId
WHERE --Filter by datetime
( (vAlert.RaisedDateTime >= @StartDate) AND (vAlert.RaisedDateTime < @EndDate) )
--HANDLE ERRORS
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
--===============================================================
-- SET LOCAL VARIABLES
--===============================================================
SET @TotalAlerts = (SELECT COUNT(*) FROM #tmpAlertList)
--===============================================================
-- FINAL RESULT SET
--===============================================================
SELECT _vAlert.RowNum,
_vAlert.AlertName,
_vAlert.RepeatCount,
_vAlert.TotalTTR,
_vAlert.AverageTTR,
@TotalAlerts AS TotalAlerts,
CASE
WHEN ISNULL(@TotalAlerts,0) <> 0 THEN (_vAlert.RepeatCount/@TotalAlerts)
ELSE 0
END AS ActivityPct
FROM
(
SELECT subAlerts.AlertName,
SUM(vAlertRS.TimeFromRaisedSeconds) / 60 AS TotalTTR,
AVG(vAlertRS.TimeFromRaisedSeconds) / 60 AS AverageTTR,
COUNT(*) AS RepeatCount,
RANK() OVER(PARTITION BY 1 ORDER BY COUNT(*) DESC) AS RowNum
FROM Alert.vAlert subAlerts
INNER JOIN #tmpAlertList ON subAlerts.AlertGuid = #tmpAlertList.AlertGuid
LEFT OUTER JOIN dbo.vMonitor vMonitor ON (subAlerts.WorkflowRowId = vMonitor.MonitorRowId)
AND (subAlerts.MonitorAlertInd = 1)
LEFT OUTER JOIN dbo.vRule vRule ON (subAlerts.WorkflowRowId = vRule.RuleRowId)
AND (subAlerts.MonitorAlertInd = 0)
LEFT OUTER JOIN Alert.vAlertResolutionState vAlertRS ON subAlerts.AlertGuid = vAlertRS.AlertGuid
AND vAlertRS.ResolutionState=255
INNER JOIN dbo.vManagementPack vMP ON (CASE
WHEN subAlerts.MonitorAlertInd = 1 THEN vMonitor.ManagementPackRowId
ELSE vRule.ManagementPackRowId
END) = vMP.ManagementPackRowId
GROUP BY subAlerts.AlertName
) AS _vAlert
WHERE _vAlert.RowNum <= @Threshold
ORDER BY CASE
WHEN ISNULL(@TotalAlerts,0) <> 0 THEN (_vAlert.RepeatCount/@TotalAlerts)
ELSE 0
END DESC
--HANDLE ERRORS
SET @Error = @@ERROR
IF @Error <> 0 GOTO QuitError
--===============================================================
-- ERROR HANDELING AND TEMP CLEANUP
--===============================================================
QuitError:
DROP TABLE #tmpObjectList
DROP TABLE #tmpAlertList
</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@Threshold">
<Value>=Parameters!AlertThreshold.Value</Value>
</QueryParameter>
<QueryParameter Name="@ObjectList">
<Value>=Code.BuildXmlValueList(Parameters!ManagementPackId.Value)</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="ManagementPackList">
<Fields>
<Field Name="ManagementPackRowId">
<DataField>ManagementPackRowId</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="DisplayName">
<DataField>DisplayName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>
SELECT vManagementPack.ManagementPackRowId, ISNULL(vDisplayString.Name, vManagementPack.ManagementPackDefaultName) AS DisplayName
FROM vManagementPack LEFT OUTER JOIN
vDisplayString ON vManagementPack.ManagementPackVersionIndependentGuid = vDisplayString.ElementGuid AND
vDisplayString.LanguageCode = @LanguageCode
WHERE vManagementPack.ManagementPackSystemName LIKE 'EMC.SI.Monitoring%'
ORDER BY vManagementPack.ManagementPackDefaultName
</CommandText>
<QueryParameters>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
</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 = False
Const TimeTypeParameterName As String = "TimeType"
Const TimeWeekMapParameterName As String = "TimeWeekMap"
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
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
End If
return ReportEndDate
End Function
Public Function GetReportTimeFilter() As Microsoft.EnterpriseManagement.Reporting.ParameterProcessor.RelativeTime
If IsNothing(ReportTime) Then 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, ",")))
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
</Code>
<Width>8.5in</Width>
<Body>
<ReportItems>
<Table Name="table1">
<ZIndex>7</ZIndex>
<DataSetName>CommonAlertsSummary</DataSetName>
<DetailDataElementName>Alert</DetailDataElementName>
<Top>5.6in</Top>
<Width>6.4in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<DataElementOutput>Output</DataElementOutput>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>RowNumber</DataElementName>
<Value>=RowNumber("CommonAlertsSummary")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<DataElementOutput>Output</DataElementOutput>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>AlertName</DataElementName>
<Value>=Fields!AlertName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox19">
<DataElementOutput>Output</DataElementOutput>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>AlertCount</DataElementName>
<Value>=Code.FormatNumber("G", Fields!RepeatCount.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox24">
<DataElementOutput>Output</DataElementOutput>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>ActivityPercent</DataElementName>
<Value>=Code.FormatNumber("P2", Fields!ActivityPct.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.2in</Height>
</TableRow>
</TableRows>
</Details>
<DetailDataCollectionName>Alerts</DetailDataCollectionName>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ColSpan>4</ColSpan>
<ReportItems>
<Textbox Name="textbox40">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>8</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Code.GetLocTable("LT_Report").GetString("R.GraphTableLabel", "[Graph Table Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox45">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<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>
<Value/>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox46">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<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>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AlertNameLabel", "[Alert Name Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox48">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<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>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AlertCountLabel", "[Alert Count Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox49">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<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>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.ActivityPctLabel", "[Activity Pct Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.2in</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>0.7191in</Width>
</TableColumn>
<TableColumn>
<Width>3.09214in</Width>
</TableColumn>
<TableColumn>
<Width>1.29438in</Width>
</TableColumn>
<TableColumn>
<Width>1.29438in</Width>
</TableColumn>
</TableColumns>
<DataElementName>CommonAlertsSummaryTable</DataElementName>
<Height>0.65in</Height>
<Left>1.3in</Left>
</Table>
<CustomReportItem Name="customReportItem1">
<DataElementOutput>NoOutput</DataElementOutput>
<CustomData>
<DataSetName>CommonAlertsSummary</DataSetName>
<DataColumnGroupings>
<DataGroupings>
<DataGrouping>
<Grouping Name="AlertName">
<GroupExpressions>
<GroupExpression>=Fields!AlertName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<CustomProperties>
<CustomProperty>
<Name>GroupLabel</Name>
<Value>=RowNumber("CommonAlertsSummary")</Value>
</CustomProperty>
</CustomProperties>
</DataGrouping>
</DataGroupings>
</DataColumnGroupings>
<DataRowGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
<CustomProperties>
<CustomProperty>
<Name>ID</Name>
<Value>fcedb228-862f-4df8-b384-edffae646097</Value>
</CustomProperty>
<CustomProperty>
<Name>ChartArea</Name>
<Value>Chart Area 1</Value>
</CustomProperty>
<CustomProperty>
<Name>Legend</Name>
<Value>Default</Value>
</CustomProperty>
<CustomProperty>
<Name>ShowInLegend</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Type</Name>
<Value>Column</Value>
</CustomProperty>
<CustomProperty>
<Name>SmartLabels.Enabled</Name>
<Value>true</Value>
</CustomProperty>
</CustomProperties>
</DataGrouping>
</DataGroupings>
</DataRowGroupings>
<DataRows>
<DataRow>
<DataCell>
<DataValue>
<Name>ID</Name>
<Value>fcedb228-862f-4df8-b384-edffae646097</Value>
</DataValue>
<DataValue>
<Name>Y0</Name>
<Value>=Sum(Fields!ActivityPct.Value) * 100</Value>
</DataValue>
<DataValue>
<Name>Color</Name>
<Value>160, 30, 144, 255</Value>
</DataValue>
<DataValue>
<Name>BackGradientType</Name>
<Value>LeftRight</Value>
</DataValue>
<DataValue>
<Name>BackGradientEndColor</Name>
<Value>230, 0, 114, 225</Value>
</DataValue>
<DataValue>
<Name>Label</Name>
<Value>=Code.FormatNumber("P2", Fields!ActivityPct.Value)</Value>
</DataValue>
<DataValue>
<Name>FontAngle</Name>
<Value>0</Value>
</DataValue>
<DataValue>
<Name>CustomAttributes</Name>
<Value>LabelStyle=Top</Value>
</DataValue>
<DataValue>
<Name>Font</Name>
<Value>Tahoma, 8pt</Value>
</DataValue>
<DataValue>
<Name>FontColor</Name>
<Value>Black</Value>
</DataValue>
</DataCell>
</DataRow>
</DataRows>
</CustomData>
<Top>3.15in</Top>
<Type>EnterpriseManagementChartControl</Type>
<Width>8.25in</Width>
<CustomProperties>
<CustomProperty>
<Name>CUSTOM_CODE_CS</Name>
<Value>dXNpbmcgU3lzdGVtOw0KdXNpbmcgU3lzdGVtLldlYjsNCnVzaW5nIFN5c3RlbS5EcmF3aW5nOw0KdXNpbmcgRHVuZGFzLkNoYXJ0aW5nLldlYkNvbnRyb2w7DQpuYW1lc3BhY2UgUmVwb3J0aW5nU2VydmljZXMuQ3VzdG9tQXNzZW1ibHkNCnsNCgkvLyBUaGlzIGlzIHRoZSBkZWZhdWx0IGNsYXNzIG5hbWUNCglwdWJsaWMgY2xhc3MgQ3VzdG9taXplDQoJew0KCQkvL2RlZmF1bHQgY29uc3RydWN0b3INCgkJcHVibGljIEN1c3RvbWl6ZSgpDQoJCXsNCgkJfQ0KDQoJCXB1YmxpYyB2b2lkIFBvc3RJbml0aWFsaXplKER1bmRhcy5DaGFydGluZy5XZWJDb250cm9sLkNoYXJ0IGNoYXJ0T2JqLCBTeXN0ZW0uQ29sbGVjdGlvbnMuSGFzaHRhYmxlIGNvZGVQYXJhbXMpDQoJCXsNCgkJdHJ5ew0KLy9ERUxJTS1TVEFSVC1Qb3N0SW5pdGlhbGl6ZQ0KLy8gUGFyYW1ldGVyOiBjaGFydE9iaiAgICAgLSByZXByZXNlbnRzIHRoZSBjaGFydCBvYmplY3QKLy8gUGFyYW1ldGVyOiBjb2RlUGFyYW1zICAgLSB1c2VyIGRlZmluZWQgY29kZSBwYXJhbWV0ZXJzCi8vREVMSU0tRU5ELVBvc3RJbml0aWFsaXplDQoJCX1jYXRjaCAoRXhjZXB0aW9uIHVzZXJFeGNlcHRpb24pIHsgDQoJCSAgICBjaGFydE9iai5Db2RlRXhjZXB0aW9uID0gIlBvc3RJbml0aWFsaXplOiAiK3VzZXJFeGNlcHRpb24uTWVzc2FnZTsNCgkJICAgIHRocm93Ow0KCQkgICAgfQ0KCQl9DQoNCgkJcHVibGljIHZvaWQgUG9zdEFwcGx5U2VyaWVzRGF0YShEdW5kYXMuQ2hhcnRpbmcuV2ViQ29udHJvbC5DaGFydCBjaGFydE9iaiwgRHVuZGFzLkNoYXJ0aW5nLldlYkNvbnRyb2wuU2VyaWVzIHNlcmllcywgU3lzdGVtLkNvbGxlY3Rpb25zLkhhc2h0YWJsZSBjb2RlUGFyYW1zKQ0KCQl7DQoJCXRyeXsNCi8vREVMSU0tU1RBUlQtUG9zdEFwcGx5U2VyaWVzRGF0YQ0KLy8gUGFyYW1ldGVyOiBjaGFydE9iaiAgICAgLSByZXByZXNlbnRzIHRoZSBjaGFydCBvYmplY3QKLy8gUGFyYW1ldGVyOiBzZXJpZXMgICAgICAgLSB0aGUgc2VyaWVzIHRoYXQgaXMgY3VycmVudGx5IGJlaW5nIHBvcHVsYXRlZAovLyBQYXJhbWV0ZXI6IGNvZGVQYXJhbXMgICAtIHVzZXIgZGVmaW5lZCBjb2RlIHBhcmFtZXRlcnMKLy9ERUxJTS1FTkQtUG9zdEFwcGx5U2VyaWVzRGF0YQ0KCQl9Y2F0Y2ggKEV4Y2VwdGlvbiB1c2VyRXhjZXB0aW9uKSB7IA0KCQkgICAgY2hhcnRPYmouQ29kZUV4Y2VwdGlvbiA9ICJQb3N0QXBwbHlTZXJpZXNEYXRhOiAiK3VzZXJFeGNlcHRpb24uTWVzc2FnZTsNCgkJICAgIHRocm93Ow0KCQkgICAgfQ0KCQl9DQoNCgl9Ly8gZW5kIGNsYXNzDQp9Ly8gZW5kIG5hbWVzcGFjZQ0K</Value>
</CustomProperty>
<CustomProperty>
<Name>CUSTOM_CODE_COMPILED_ASSEMBLY</Name>
<Value>TVqQAAMAAAAEAAAA//8AALgAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAAAAA4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1vZGUuDQ0KJAAAAAAAAABQRQAATAEDALqMCEUAAAAAAAAAAOAADiELAQgAAAYAAAAGAAAAAAAA3iQAAAAgAAAAQAAAAABAAAAgAAAAAgAABAAAAAAAAAAEAAAAAAAAAACAAAAAAgAAAAAAAAMAAAQAABAAABAAAAAAEAAAEAAAAAAAABAAAAAAAAAAAAAAAJAkAABLAAAAAEAAAKgCAAAAAAAAAAAAAAAAAAAAAAAAAGAAAAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAACAAAAAAAAAAAAAAACCAAAEgAAAAAAAAAAAAAAC50ZXh0AAAA5AQAAAAgAAAABgAAAAIAAAAAAAAAAAAAAAAAACAAAGAucnNyYwAAAKgCAAAAQAAAAAQAAAAIAAAAAAAAAAAAAAAAAABAAABALnJlbG9jAAAMAAAAAGAAAAACAAAADAAAAAAAAAAAAAAAAAAAQAAAQgAAAAAAAAAAAAAAAAAAAADAJAAAAAAAAEgAAAACAAUAeCAAABgEAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAB4CKAMAAAoqEzADAAEAAAABAAARKgAAABMwAwABAAAAAQAAESoAAABCU0pCAQABAAAAAAAMAAAAdjIuMC41MDcyNwAAAAAFAGwAAABQAQAAI34AALwBAACQAQAAI1N0cmluZ3MAAAAATAMAAFAAAAAjVVMAnAMAABAAAAAjR1VJRAAAAKwDAABsAAAAI0Jsb2IAAAAAAAAAAgAAAUcVAgAJAAAAAPoBMwAWAAABAAAACAAAAAIAAAADAAAABQAAAAYAAAACAAAAAQAAAAEAAAACAAAAAAAKAAEAAAAAAAYAUgBLAAoAiABtAAYAoQCOAAoAugBtAAYA9QDVAAYAFQHVAAYAUAFLAAYAZgFLAAAAAAABAAAAAAABAAEAAQAQABcAIQAFAAEAAQBQIAAAAACGGFkACgABAFggAAAAAIYAqwAXAAEAaCAAAAAAhgDBAB8AAwAAAAEAPAEAAAIARQEAAAEAPAEAAAIAhgEAAAMARQEpAFkAKQAxAFkACgAJAFkACgA5AFoBLgBBAG0BMgARAHQBOAAuAAsAQgAuABMASwA9AASAAAAAAAAAAAAAAAAAAAAAADMBAAACAAAAAAAAAAAAAAABAEIAAAAAAAIAAAAAAJUAAAAAAA4AXwAAAAAAAAAAPE1vZHVsZT4ANmUwcTQ3dGkuZGxsAEN1c3RvbWl6ZQBSZXBvcnRpbmdTZXJ2aWNlcy5DdXN0b21Bc3NlbWJseQBtc2NvcmxpYgBTeXN0ZW0AT2JqZWN0AC5jdG9yAER1bmRhc1JTQ2hhcnQARHVuZGFzLkNoYXJ0aW5nLldlYkNvbnRyb2wAQ2hhcnQAU3lzdGVtLkNvbGxlY3Rpb25zAEhhc2h0YWJsZQBQb3N0SW5pdGlhbGl6ZQBTZXJpZXMAUG9zdEFwcGx5U2VyaWVzRGF0YQBTeXN0ZW0uUnVudGltZS5Db21waWxlclNlcnZpY2VzAENvbXBpbGF0aW9uUmVsYXhhdGlvbnNBdHRyaWJ1dGUAUnVudGltZUNvbXBhdGliaWxpdHlBdHRyaWJ1dGUANmUwcTQ3dGkAY2hhcnRPYmoAY29kZVBhcmFtcwBFeGNlcHRpb24AZ2V0X01lc3NhZ2UAU3RyaW5nAENvbmNhdABzZXRfQ29kZUV4Y2VwdGlvbgBzZXJpZXMAAAAAACFQAG8AcwB0AEkAbgBpAHQAaQBhAGwAaQB6AGUAOgAgAAArUABvAHMAdABBAHAAcABsAHkAUwBlAHIAaQBlAHMARABhAHQAYQA6ACAAAADMCDCaGTjnQJzubpQF2MmDAAi3elxWGTTgiQMgAAEIEfsPLjcvwyYHIAIBEgkSDQkgAwESCRIREg0EIAEBCAMgAA4FAAIODg4EIAEBDgQHARIdCAEACAAAAAAAHgEAAQBUAhZXcmFwTm9uRXhjZXB0aW9uVGhyb3dzAQAAuCQAAAAAAAAAAAAAziQAAAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAMAkAAAAAAAAAABfQ29yRGxsTWFpbgBtc2NvcmVlLmRsbAAAAAAA/yUAIEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAEAAAABgAAIAAAAAAAAAAAAAAAAAAAAEAAQAAADAAAIAAAAAAAAAAAAAAAAAAAAEAAAAAAEgAAABYQAAATAIAAAAAAAAAAAAATAI0AAAAVgBTAF8AVgBFAFIAUwBJAE8ATgBfAEkATgBGAE8AAAAAAL0E7/4AAAEAAAAAAAAAAAAAAAAAAAAAAD8AAAAAAAAABAAAAAIAAAAAAAAAAAAAAAAAAABEAAAAAQBWAGEAcgBGAGkAbABlAEkAbgBmAG8AAAAAACQABAAAAFQAcgBhAG4AcwBsAGEAdABpAG8AbgAAAAAAAACwBKwBAAABAFMAdAByAGkAbgBnAEYAaQBsAGUASQBuAGYAbwAAAIgBAAABADAAMAAwADAAMAA0AGIAMAAAACwAAgABAEYAaQBsAGUARABlAHMAYwByAGkAcAB0AGkAbwBuAAAAAAAgAAAAMAAIAAEARgBpAGwAZQBWAGUAcgBzAGkAbwBuAAAAAAAwAC4AMAAuADAALgAwAAAAPAANAAEASQBuAHQAZQByAG4AYQBsAE4AYQBtAGUAAAA2AGUAMABxADQANwB0AGkALgBkAGwAbAAAAAAAKAACAAEATABlAGcAYQBsAEMAbwBwAHkAcgBpAGcAaAB0AAAAIAAAAEQADQABAE8AcgBpAGcAaQBuAGEAbABGAGkAbABlAG4AYQBtAGUAAAA2AGUAMABxADQANwB0AGkALgBkAGwAbAAAAAAANAAIAAEAUAByAG8AZAB1AGMAdABWAGUAcgBzAGkAbwBuAAAAMAAuADAALgAwAC4AMAAAADgACAABAEEAcwBzAGUAbQBiAGwAeQAgAFYAZQByAHMAaQBvAG4AAAAwAC4AMAAuADAALgAwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAwAAADgNAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Sizing</Name>
<Value>FitProportional</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.NoDataMessage.Visible</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.NoDataMessage.Text</Name>
<Value/>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.Name</Name>
<Value>Default</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.AutoFitText</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.DockInsideChartArea</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.Enabled</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.BackColor</Name>
<Value>230, 242, 252</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.BorderColor</Name>
<Value>80, 65, 140, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.BackGradientType</Name>
<Value>TopBottom</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.BackGradientEndColor</Name>
<Value>White</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.Alignment</Name>
<Value>Far</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Legends.0.Legend.Docking</Name>
<Value>Bottom</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Titles.0.Title.Name</Name>
<Value>Title1</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.Titles.0.Title.Text</Name>
<Value>=Code.GetLocTable("LT_Report").GetString("R.GraphTitleLabel", "[Graph Title Label]")</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.BackGradientEndColor</Name>
<Value>240, 240, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.BorderColor</Name>
<Value>220, 220, 220, 220</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.BorderStyle</Name>
<Value>Solid</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.BackGradientType</Name>
<Value>TopBottom</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.Name</Name>
<Value>Chart Area 1</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.LabelsAutoFit</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.LabelsAutoFitStyle</Name>
<Value>OffsetLabels, LabelsAngleStep30, LabelsAngleStep45, LabelsAngleStep90, WordWrap</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.Maximum</Name>
<Value>100</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.Minimum</Name>
<Value>0</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.MajorGrid.LineColor</Name>
<Value>220, 220, 220, 220</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.MinorGrid.LineColor</Name>
<Value>220, 220, 220, 220</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.MinorGrid.Disabled</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.MajorTickMark.LineColor</Name>
<Value>220, 220, 220, 220</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.MinorTickMark.Style</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.MinorTickMark.LineColor</Name>
<Value>220, 220, 220, 220</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.MinorTickMark.Disabled</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY.LabelStyle.Font</Name>
<Value>Tahoma, 8.25pt</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.LabelsAutoFitStyle</Name>
<Value>DecreaseFont, OffsetLabels, LabelsAngleStep30, LabelsAngleStep45, LabelsAngleStep90, WordWrap</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.Interval</Name>
<Value>1</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.StartFromZero</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.MajorGrid.LineColor</Name>
<Value>80, 65, 140, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.MajorGrid.Enabled</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.MinorGrid.LineColor</Name>
<Value>50, 65, 140, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.MajorTickMark.Enabled</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.MinorTickMark.Style</Name>
<Value>None</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX.LabelStyle.Font</Name>
<Value>Tahoma, 8.25pt</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX2.Margin</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX2.MajorGrid.LineColor</Name>
<Value>80, 65, 140, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisX2.MinorGrid.LineColor</Name>
<Value>50, 65, 140, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY2.MajorGrid.LineColor</Name>
<Value>80, 65, 140, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.AxisY2.MinorGrid.LineColor</Name>
<Value>50, 65, 140, 240</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.RightAngleAxes</Name>
<Value>False</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.Clustered</Name>
<Value>True</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.Light</Name>
<Value>Realistic</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.Perspective</Name>
<Value>1</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.XAngle</Name>
<Value>50</Value>
</CustomProperty>
<CustomProperty>
<Name>Chart.ChartAreas.0.ChartArea.Area3DStyle.YAngle</Name>
<Value>50</Value>
</CustomProperty>
</CustomProperties>
<ZIndex>6</ZIndex>
<Left>0.15in</Left>
<Height>2.45in</Height>
</CustomReportItem>
<List Name="list1">
<DataInstanceName>ManagementPack</DataInstanceName>
<Sorting>
<SortBy>
<SortExpression>=Fields!ActivityPct.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<ZIndex>5</ZIndex>
<DataElementOutput>Output</DataElementOutput>
<Left>0.15in</Left>
<DataSetName>CommonAlertsDetail</DataSetName>
<ReportItems>
<Textbox Name="ManagementPackDefaultName">
<rd:DefaultName>ManagementPackDefaultName</rd:DefaultName>
<DataElementOutput>Output</DataElementOutput>
<Width>8.1in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>AttributeNormal</DataElementStyle>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>Name</DataElementName>
<Height>0.25in</Height>
<Value>=Fields!MPName.Value</Value>
</Textbox>
<Table Name="table2">
<DataElementOutput>Output</DataElementOutput>
<DataSetName>CommonAlertsDetail</DataSetName>
<DetailDataElementName>Alert</DetailDataElementName>
<Top>0.35in</Top>
<Width>8.20753in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>5</ZIndex>
<DataElementName>Name</DataElementName>
<Value>=Fields!AlertName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<rd:DefaultName>textbox18</rd:DefaultName>
<DataElementOutput>Output</DataElementOutput>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>MonitorOrRuleName</DataElementName>
<Value>=Fields!MonitorName.Value + IIF(IsNothing(Fields!MonitorName.Value) OR IsNothing(Fields!RuleName.Value),"","/") + Fields!RuleName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>3</ZIndex>
<DataElementName>AlertCount</DataElementName>
<Value>=Code.FormatNumber("G", Fields!RepeatCount.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox16">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Format>#.00</Format>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>2</ZIndex>
<DataElementName>ActivityPercent</DataElementName>
<Value>=Code.FormatNumber("P2", Fields!ActivityPct.Value )</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox20">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>1</ZIndex>
<DataElementName>AverageTTR</DataElementName>
<Value>=Code.FormatNumber("N2", Fields!AverageTTR.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox21">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Style>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<BorderWidth>
<Default>0.5pt</Default>
</BorderWidth>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<DataElementName>TotalTTR</DataElementName>
<Value>=Code.FormatNumber("N2", Fields!TotalTTR.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.2in</Height>
</TableRow>
</TableRows>
<Sorting>
<SortBy>
<SortExpression>=Fields!ActivityPct.Value</SortExpression>
<Direction>Descending</Direction>
</SortBy>
</Sorting>
</Details>
<DetailDataCollectionName>Alerts</DetailDataCollectionName>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox22">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>11</ZIndex>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!AlertName.Value</SortExpression>
</UserSort>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AlertNameLabel", "[Alert Name Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>10</ZIndex>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!MonitorName.Value + "/" + Fields!RuleName.Value</SortExpression>
</UserSort>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.MonitorRuleNameLabel", "[Monitor Rule Name Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>9</ZIndex>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Code.FormatNumber("G", Fields!RepeatCount.Value)</SortExpression>
</UserSort>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AlertCountLabel", "[Alert Count Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox25">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>8</ZIndex>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Code.FormatNumber("P2", Fields!ActivityPct.Value )</SortExpression>
</UserSort>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.ActivityPctLabel", "[Activity Pct Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox27">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Code.FormatNumber("N2", Fields!AverageTTR.Value)</SortExpression>
</UserSort>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.AverageTTRLabel", "[Average TTR Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox29">
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Code.FormatNumber("N2", Fields!TotalTTR.Value)</SortExpression>
</UserSort>
<Value>=Code.GetLocTable("LT_Table").GetString("RT.Column.TotalTTRLabel", "[Total TTR Column Label]")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>3.1in</Width>
</TableColumn>
<TableColumn>
<Width>1.7in</Width>
</TableColumn>
<TableColumn>
<Width>0.8in</Width>
</TableColumn>
<TableColumn>
<Width>0.8in</Width>
</TableColumn>
<TableColumn>
<Width>0.90753in</Width>
</TableColumn>
<TableColumn>
<Width>0.9in</Width>
</TableColumn>
</TableColumns>
<DataElementName>CommonAlertsDetailTable</DataElementName>
</Table>
</ReportItems>
<Top>6.35in</Top>
<Width>8.25in</Width>
<Grouping Name="ManagementPack">
<GroupExpressions>
<GroupExpression>=Fields!ManagementPackRowId.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<DataElementName>ManagementPacks</DataElementName>
<Height>0.8in</Height>
</List>
<Rectangle Name="RptSpacerHeader">
<Left>0.15in</Left>
<ZIndex>4</ZIndex>
<Top>1.5in</Top>
<Width>8.05in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>DarkGray</Default>
</BorderColor>
<BorderStyle>
<Bottom>Solid</Bottom>
</BorderStyle>
</Style>
<Height>0.05in</Height>
</Rectangle>
<Rectangle Name="RptHeader">
<Left>0.15in</Left>
<ZIndex>3</ZIndex>
<ReportItems>
<Textbox Name="reportDescriptionTitle">
<DataElementOutput>NoOutput</DataElementOutput>
<Top>0.3in</Top>
<Width>8in</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>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.DescriptionTitle", "[Report Description Title]")</Value>
</Textbox>
<Textbox Name="reportTitle">
<DataElementOutput>Output</DataElementOutput>
<Top>0.05in</Top>
<Width>7.8in</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.75in</Top>
<Width>8.05in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.55in</Height>
</Rectangle>
<Rectangle Name="RptExtdHeader">
<Left>0.15in</Left>
<ZIndex>2</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>reportDescriptionTitle</ToggleItem>
</Visibility>
<ReportItems>
<Textbox Name="reportDescription">
<DataElementOutput>NoOutput</DataElementOutput>
<Width>7.8in</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.3in</Top>
<Width>8.05in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.2in</Height>
</Rectangle>
<Image Name="banner_image">
<Sizing>AutoSize</Sizing>
<Top>0.1in</Top>
<Width>8.05in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>1</ZIndex>
<Left>0.15in</Left>
<Height>0.64583in</Height>
<Value>..\banner_portrait.jpg</Value>
</Image>
<Rectangle Name="RptParamHeader">
<Left>0.15in</Left>
<ReportItems>
<Rectangle Name="ObjectListHeader">
<ZIndex>16</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>objectsParameterTitle</ToggleItem>
</Visibility>
<ReportItems>
<List Name="objectParameterList">
<Sorting>
<SortBy>
<SortExpression>=Fields!ManagementPackSystemName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!DisplayName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<DataSetName>ObjectList</DataSetName>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>objectsParameterTitle</ToggleItem>
</Visibility>
<ReportItems>
<Textbox Name="textbox35">
<CanShrink>true</CanShrink>
<Width>6in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Bottom</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.ObjectFormatLine1", "{0}: {1}"), Fields!DisplayName.Value, Fields!DisplayName.Value)</Value>
</Textbox>
</ReportItems>
<Top>0.05in</Top>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<DataInstanceElementOutput>NoOutput</DataInstanceElementOutput>
<Height>0.206in</Height>
</List>
</ReportItems>
<Top>0.65in</Top>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.3in</Height>
</Rectangle>
<Textbox Name="textbox28">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>6.05in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>15</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("g", Code.GetReportStartDate()),
Code.FormatDateTime("g", Code.GetReportEndDate())
)
</Value>
</Textbox>
<Textbox Name="report_EventID">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1in</Top>
<Width>6.05in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<DataElementName>Threshold</DataElementName>
<Height>0.2in</Height>
<Value>=Parameters!AlertThreshold.Value</Value>
</Textbox>
<Textbox Name="textbox13">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1in</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>13</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.2in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.AlertThresholdLabel", "[Alert Threshold Label]")</Value>
</Textbox>
<Textbox Name="textbox15">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1in</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>12</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="textbox17">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.25in</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>11</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.1in</Left>
<DataElementName>TimeZone</DataElementName>
<Height>0.2in</Height>
<Value>=Parameters!TimeZoneName.Value</Value>
</Textbox>
<Textbox Name="textbox9">
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.25in</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>10</ZIndex>
<CanGrow>true</CanGrow>
<Left>0.05in</Left>
<DataElementName>EndDate</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.GetReportEndDate())</Value>
</Textbox>
<Image Name="parameterBottomImage">
<Sizing>AutoSize</Sizing>
<Top>1.2in</Top>
<Width>8.05in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>9</ZIndex>
<Height>0.05in</Height>
<Value>../gradient_portrait.gif</Value>
</Image>
<Textbox Name="textbox14">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<Width>6.05in</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.95in</Left>
<Height>0.2in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.ObjectsFormat", "{0}"), Code.FormatNumber("G", CountRows("ObjectList")))</Value>
</Textbox>
<Textbox Name="textbox11">
<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>7</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.45in</Top>
<Width>1.85in</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>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ObjectsLabel", "[Report Objects Label]")</Value>
</Textbox>
<Textbox Name="ReportGeneratedTime">
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<Width>6.05in</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>5</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.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>4</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>3</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>2</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="textbox26">
<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>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>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<DataElementOutput>Output</DataElementOutput>
<Visibility>
<Hidden>true</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Top>0.25in</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>
<CanGrow>true</CanGrow>
<DataElementName>StartDate</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.GetReportStartDate())</Value>
</Textbox>
</ReportItems>
<Top>1.55in</Top>
<Width>8.1in</Width>
<Height>1.3in</Height>
</Rectangle>
</ReportItems>
<Height>7.25in</Height>
</Body>
<DataElementStyle>ElementNormal</DataElementStyle>
<Language>en-US</Language>
<PageFooter>
<PrintOnFirstPage>true</PrintOnFirstPage>
<ReportItems>
<Textbox Name="textbox62">
<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>6.5in</Left>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.PageFormat", "{0}/{1}"), Globals!PageNumber, Globals!TotalPages)</Value>
</Textbox>
<Textbox Name="textbox63">
<Top>0.1in</Top>
<Width>6.25in</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>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.TimeZoneFormat", "{0}"), Parameters!TimeZoneName.Value)</Value>
</Textbox>
</ReportItems>
<Height>0.2875in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
</PageFooter>
</Report>
</Definition>
<ReportStrings>
<ReportString ID="R.ActionsFormat"/>
<ReportString ID="R.AlertThresholdLabel"/>
<ReportString ID="R.AlgFormat"/>
<ReportString ID="R.AlgFormatBottom"/>
<ReportString ID="R.AlgFormatTop"/>
<ReportString ID="R.AlgLabel"/>
<ReportString ID="R.AlgParamBottom"/>
<ReportString ID="R.AlgParamTop"/>
<ReportString ID="R.BusinessTimeFormat"/>
<ReportString ID="R.Description"/>
<ReportString ID="R.DescriptionTitle"/>
<ReportString ID="R.GeneratedTimeLabel"/>
<ReportString ID="R.GraphTableLabel"/>
<ReportString ID="R.GraphTitleLabel"/>
<ReportString ID="R.MonitorLabel"/>
<ReportString ID="R.ObjectFormatLine1"/>
<ReportString ID="R.ObjectFormatLine2"/>
<ReportString ID="R.ObjectFormatLine2Path"/>
<ReportString ID="R.ObjectsFormat"/>
<ReportString ID="R.ObjectsLabel"/>
<ReportString ID="R.PageFormat"/>
<ReportString ID="R.StartEndTimeFormat"/>
<ReportString ID="R.StartEndTimeLabel"/>
<ReportString ID="R.TimeZoneFormat"/>
<ReportString ID="R.Title"/>
<ReportString ID="RT.Column.ActivityPctLabel"/>
<ReportString ID="RT.Column.AlertCountLabel"/>
<ReportString ID="RT.Column.AlertNameLabel"/>
<ReportString ID="RT.Column.AverageTTRLabel"/>
<ReportString ID="RT.Column.MonitorRuleNameLabel"/>
<ReportString ID="RT.Column.TotalTTRLabel"/>
</ReportStrings>
</Report>