Allmän anpassad händelserapport
Den här rapporten visar händelsedata som filtrerats efter alla valda parametrar
Beskrivning:
Ett hanteringspaket innehåller händelseinsamlingsregler som samlar in specifik händelseinformation. Listan med händelseinformation definieras av de regler som samlar in händelserna. Om en kryssruta för en detalj i händelsen är markerad skrivs den ut till rapporten. Med kontrollerna till höger kan du definiera ordningen för de valda objekten från vänster (högre i parameterlistan) till höger (lägre i parameterlistan).
Parametrar:
Val av datum/tid: Här kan du definiera en tidsperiod för rapporten med relativa eller fasta datum.
Objektväljare: Här kan du välja grupper eller objekt att visa aviseringar för.
Om du använder objektväljaren och väljer Lägg till grupp returneras gruppen och alla objekt som den innehåller. Om du väljer Lägg till objekt returneras endast det valda objektet.
Rapportfält: Här kan du definiera vilka egenskaper du vill filtrera efter, vilka som ska skrivas ut och i vilken ordning
Exempel:
Scenario: Rapport om alla Operations Manager 1210-händelser från rothanteringsserveremulatorn under måndag-fredag i föregående vecka. Kör rapporten för att visa händelse-ID, Datum och Kanal.
Instruktioner: (Parameterval visas med fetstil)
Öppna den anpassade händelserapporten
Öppna listrutan Från och välj Föregående vecka > Måndag
Öppna listrutan Till och välj Föregående vecka > Fredag
Klicka på Lägg till grupp
Skriv Rothantering i sökrutan och klicka på Sök
Markera gruppen Datorgrupp för rothanteringsserveremulator och klicka på Lägg till
Klicka på OK när du är klar.
Vid Rapportfält väljer du Händelse-ID, Datum, Kanal
Markera Händelse-ID och klicka på Filtrera
Lägg till villkoret Händelse-ID = 1210
Klicka på Kör så visas rapporten.
Rapportutdata:
Kolumnrubrik > | Händelse-ID | Datum | Kanal |
Kolumnbeskrivning > | Angivet händelse-ID | Datum då händelsen aktiverades | Källogg för händelsen. |
Accessibility | Public |
Visible | True |
R.ActionsLabel | Åtgärder | |
R.AllLabel | (Alla) | |
R.BusinessTimeFormat | {2} från {0} till {1} | |
R.Description | Den här rapporten visar händelsedata som filtrerats efter alla valda parametrar | |
R.DescriptionTitle | Klicka på plustecknet så visas en fullständig beskrivning av den här rapporten | |
R.GeneratedTimeLabel | Rapporttid | |
R.GroupByLabel | Gruppera efter | |
R.ObjectFilterLabel | Objekt filtrerade efter | |
R.ObjectFormatLine1 | {0}: {1} | |
R.ObjectFormatLine2 | {0} {1} | |
R.ObjectFormatLine2Path | | {0} | |
R.ObjectsFormat | {0} objekt inkluderas i den här rapporten | |
R.ObjectsLabel | Objekt | |
R.ObjectUseContainment | Alla objekt omfattade av: | |
R.PageFormat | Sida {0} av {1} | |
R.StartEndTimeFormat | Från {0} till {1} | |
R.StartEndTimeLabel | Rapportens giltighetstid | |
R.TimeZoneFormat | Alla datum och tider visas i {0} | |
R.Title | Anpassad händelserapport | |
RT.Column.ComputerName | Loggdator | |
RT.Column.DateTime | Datum | |
RT.Column.EventCategoryTitle | Kategori | |
RT.Column.EventChannelTitle | Kanal | |
RT.Column.EventDisplayNumber | Händelse-ID | |
RT.Column.EventLevelTitle | Nivå | |
RT.Column.EventPublisherName | Utgivare | |
RT.Column.ManagedEntityDefaultName | Objekt | |
RT.Column.ManagedEntityTypeDefaultName | Objekttyp | |
RT.Column.ManagementGroupDefaultName | Hanteringsgrupp | |
RT.Column.Parameter | Parameter {0} | |
RT.Column.RuleDefaultName | Regelnamn | |
RT.Column.UserName | Användarnamn | |
D.EventType.Undefined | Information | |
D.EventType.Error | Fel | |
D.EventType.Warning | Varning | |
D.EventType.Information | Information | |
D.EventType.Success_Audit | Lyckad granskning | |
D.EventType.Failure_Audit | Fel vid granskning |
<Report ID="Microsoft.SystemCenter.DataWarehouse.Report.EventTemplate" Accessibility="Public" Visible="true">
<Dependencies>
<DataWarehouseScript>Microsoft.SystemCenter.DataWarehouse.Report.Script.EventTemplate</DataWarehouseScript>
<DataWarehouseScript>Microsoft.SystemCenter.DataWarehouse.Report.Script.ObjectListParse</DataWarehouseScript>
<DataWarehouseScript>Microsoft.SystemCenter.DataWarehouse.Report.Script.ObjectList</DataWarehouseScript>
<ReportParameterControl>Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker</ReportParameterControl>
<ReportParameterControl>Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringObjectXmlPicker</ReportParameterControl>
<ReportParameterControl>Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.TextBox</ReportParameterControl>
</Dependencies>
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="7">
<Controls>
<Control rowSpan="4" columnSpan="2" 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 rowSpan="4" columnSpan="3" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MonitoringObjectXmlPicker">
<ReportParameters>
<ReportParameter name="ObjectList">
<Prompt>Microsoft.SystemCenter.DataWarehouse.Report.Library!Microsoft.SystemCenter.DataWarehouse.Report.ParameterPrompt.ObjectList</Prompt>
</ReportParameter>
<ReportParameter name="ManagementGroupId" binding="GroupList"/>
</ReportParameters>
</Control>
<Control columnSpan="2" rowSpan="4" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.ReportColumnPicker">
<ReportParameters>
<ReportParameter name="Columns"/>
<ReportParameter name="ColumnList" binding="ColumnList"/>
</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="DataWarehouseMain">
<rd:DataSourceID>e4235c51-407f-4065-8519-a1e57374bc45</rd:DataSourceID>
<DataSourceReference>Data Warehouse Main</DataSourceReference>
</DataSource>
</DataSources>
<InteractiveHeight>11in</InteractiveHeight>
<ReportParameters>
<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="LT_DisplayString">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>LT_DisplayString_Query</DataSetName>
<ValueField>ValueXml</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>LT_DisplayString_Query</DataSetName>
<ValueField>ValueXml</ValueField>
<LabelField>ValueName</LabelField>
</DataSetReference>
</ValidValues>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="MAXPARAMETERS">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>=30</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Report_Parameter_17</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ManagementGroupId">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>NeighborManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>ManagementGroupId</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>NeighborManagementGroups</DataSetName>
<ValueField>ManagementGroupGuid</ValueField>
<LabelField>ManagementGroupName</LabelField>
</DataSetReference>
</ValidValues>
<MultiValue>true</MultiValue>
<Hidden>true</Hidden>
</ReportParameter>
<ReportParameter Name="ColumnList">
<DataType>String</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>ColumnPickerList</DataSetName>
<ValueField>PropertyID</ValueField>
</DataSetReference>
</DefaultValue>
<ValidValues>
<DataSetReference>
<DataSetName>ColumnPickerList</DataSetName>
<ValueField>PropertyID</ValueField>
<LabelField>PropertyLabel</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>
<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="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>
<ReportParameter Name="ObjectList">
<DataType>String</DataType>
<Prompt>[Objects]</Prompt>
</ReportParameter>
<ReportParameter Name="Columns">
<DataType>String</DataType>
<Prompt>[Columns]</Prompt>
</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="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.EventTemplate</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.EventTemplate</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="LT_DisplayString_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.EventTemplate</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@Scope">
<Value>D.%</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="ObjectList">
<Fields>
<Field Name="ManagedEntityDefaultName">
<DataField>ManagedEntityDefaultName</DataField>
</Field>
<Field Name="Path">
<DataField>Path</DataField>
</Field>
<Field Name="DisplayName">
<DataField>DisplayName</DataField>
</Field>
<Field Name="ManagedEntityRowId">
<DataField>ManagedEntityRowId</DataField>
</Field>
<Field Name="ManagementGroupDefaultName">
<DataField>ManagementGroupDefaultName</DataField>
</Field>
<Field Name="ManagedEntityUse">
<DataField>ManagedEntityUse</DataField>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>Microsoft_SystemCenter_DataWarehouse_Report_Library_ReportObjectList</CommandText>
<QueryParameters>
<QueryParameter Name="@ObjectList">
<Value>=Parameters!ObjectList.Value</Value>
</QueryParameter>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="NeighborManagementGroups">
<Fields>
<Field Name="ManagementGroupGuid">
<DataField>ManagementGroupGuid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="ManagementGroupName">
<DataField>ManagementGroupName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>SELECT ManagementGroupGuid, ManagementGroupDefaultName AS ManagementGroupName
FROM vManagementGroup</CommandText>
</Query>
</DataSet>
<DataSet Name="Event_List">
<Fields>
<Field Name="EventOriginId">
<DataField>EventOriginId</DataField>
</Field>
<Field Name="ManagedEntityRowId">
<DataField>ManagedEntityRowId</DataField>
</Field>
<Field Name="EventDisplayNumber">
<DataField>EventDisplayNumber</DataField>
</Field>
<Field Name="EventPublisherName">
<DataField>EventPublisherName</DataField>
</Field>
<Field Name="PropertyID">
<DataField>PropertyID</DataField>
</Field>
<Field Name="PropertyValue">
<DataField>PropertyValue</DataField>
</Field>
<Field Name="Position">
<DataField>Position</DataField>
</Field>
<Field Name="FormattedDateTime">
<Value>=Code.GetFormattedDateTime(Fields!PropertyValue.Value)</Value>
</Field>
<Field Name="LocalisedPropertyValue">
<Value>=IIf(Fields!PropertyID.Value.ToString().Equals("EventLevelTitle"),
Code.GetLocTable("LT_DisplayString").GetString("D.EventType." & Fields!PropertyValue.Value.ToString().Replace(" ", "_")),
Fields!PropertyValue.Value)</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<CommandText>Microsoft_SystemCenter_DataWarehouse_Report_Library_EventTemplateReportDataGet</CommandText>
<QueryParameters>
<QueryParameter Name="@LanguageCode">
<Value>=Code.GetReportLocLanguageCode()</Value>
</QueryParameter>
<QueryParameter Name="@StartDate">
<Value>=Code.ToDbDate(Code.GetReportStartDate())</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.ToDbDate(Code.GetReportEndDate())</Value>
</QueryParameter>
<QueryParameter Name="@InputXML">
<Value>=Parameters!Columns.Value</Value>
</QueryParameter>
<QueryParameter Name="@ObjectList">
<Value>=Parameters!ObjectList.Value</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="Filters">
<Fields>
<Field Name="PropertyID">
<DataField>PropertyID</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Visible">
<DataField>Visible</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FilterValue">
<DataField>FilterValue</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FilterType">
<DataField>FilterType</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="FilterText">
<Value>= IIF(Fields!PropertyID.Value LIKE "Parameter*",
Code.FormatString(Code.GetLocTable("LT_Table").GetString("RT.Column." & "Parameter","[Parameter {0}]"),Replace(Fields!PropertyID.Value,"Parameter","",1,-1,1)),
Code.GetLocTable("LT_Table").GetString("RT.Column." & Fields!PropertyID.Value,"[" & Fields!PropertyID.Value & "]")
) & " " & Fields!FilterType.Value & " " & Chr(34) & Fields!FilterValue.Value & Chr(34)</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>DECLARE @InputXML xml
SET @InputXML = @Columns
Select
Input.ColumnXML.query('ID').value('.','nvarchar(100)') AS PropertyID,
Input.ColumnXML.value('@Visible','nvarchar(16)') AS Visible,
Input.ColumnXML.query('Filter').value('.','nvarchar(256)') AS FilterValue,
Input.ColumnXML.value('./Filter[1]/@Type','nvarchar(100)') AS FilterType
FROM (Select @InputXML AS X) AS InputTemp(X)
CROSS APPLY X.nodes('/Data/Columns/Column') Input(ColumnXML)</CommandText>
<QueryParameters>
<QueryParameter Name="@Columns">
<Value>=Parameters!Columns.Value</Value>
</QueryParameter>
</QueryParameters>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
<DataSet Name="ColumnPickerList">
<Fields>
<Field Name="PropertyID">
<DataField>PropertyID</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="i">
<DataField>i</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="PropertyLabel">
<Value>= IIF(Fields!PropertyID.Value LIKE "Parameter*",
Code.FormatString(Code.GetLocTable("LT_Table").GetString("RT.Column." & "Parameter","[Parameter {0}]"),Replace(Fields!PropertyID.Value,"Parameter","",1,-1,1)),
Code.GetLocTable("LT_Table").GetString("RT.Column." & Fields!PropertyID.Value,"[" & Fields!PropertyID.Value & "]")
)</Value>
</Field>
</Fields>
<Query>
<DataSourceName>DataWarehouseMain</DataSourceName>
<CommandText>DECLARE @counter int
Create table #ColumnList (PropertyID nvarchar(255),Counter tinyint)
Insert #ColumnList
SELECT 'EventDisplayNumber' , 0 UNION
SELECT 'DateTime',1 UNION
SELECT 'RuleDefaultName' ,2 UNION
SELECT 'EventLevelTitle' ,3 UNION
SELECT 'EventChannelTitle' ,4 UNION
SELECT 'EventCategoryTitle', 5 UNION
SELECT 'EventPublisherName' ,6 UNION
SELECT 'ManagedEntityDefaultName', 7 UNION
SELECT 'ManagedEntityTypeDefaultName', 8 UNION
SELECT 'ManagementGroupDefaultName',9 UNION
SELECT 'ComputerName',10 UNION
SELECT 'UserName',11
SET @counter = 1
while @counter <= @MAXPARAMETERS
begin
insert #ColumnList
SELECT 'Parameter' + CONVERT(NVARCHAR(4),@counter),MAX(Counter)+1 from #ColumnList
SET @counter = @counter + 1
end
Select * from #ColumnList order by Counter
drop table #ColumnList</CommandText>
<QueryParameters>
<QueryParameter Name="@MAXPARAMETERS">
<Value>=Parameters!MAXPARAMETERS.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 = 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
Public Function GetFormattedDateTime(ByVal PropertyValue As String) As String
Dim DateResult As DateTime
If (DateTime.TryParse(PropertyValue, DateResult)) Then
Return FormatDateTime("g", ToReportDate(DateResult))
Else
Return String.Empty
End If
End Function
</Code>
<Width>10.85in</Width>
<Body>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>1.3in</Width>
</MatrixColumn>
</MatrixColumns>
<ZIndex>5</ZIndex>
<DataSetName>Event_List</DataSetName>
<RowGroupings>
<RowGrouping>
<Width>0.35208in</Width>
<DynamicRows>
<Grouping Name="matrix1_EventOriginId">
<GroupExpressions>
<GroupExpression>=Fields!EventOriginId.Value</GroupExpression>
</GroupExpressions>
<DataElementName>Event</DataElementName>
<DataCollectionName>Events</DataCollectionName>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=CINT(Fields!EventDisplayNumber.Value)</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!FormattedDateTime.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!EventPublisherName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!ManagedEntityRowId.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!LocalisedPropertyValue.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<ReportItems>
<Rectangle Name="rectangle1">
<ZIndex>1</ZIndex>
<DataElementOutput>NoOutput</DataElementOutput>
<Visibility>
<Hidden>=IIF(Parameters!Interactive.Value,false,true)</Hidden>
</Visibility>
<ReportItems>
<Image Name="image1">
<Sizing>AutoSize</Sizing>
<Top>0.1in</Top>
<Action>
<Drillthrough>
<ReportName>Microsoft.SystemCenter.DataWarehouse.Report.EventAnalysis</ReportName>
<Parameters>
<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>
<Parameter Name="ObjectList">
<Value>="<Data><Objects><Object>" & Fields!ManagedEntityRowId.Value & "</Object></Objects></Data>"</Value>
</Parameter>
<Parameter Name="EventSource">
<Value>=Fields!EventPublisherName.Value</Value>
</Parameter>
<Parameter Name="EventID">
<Value>=Fields!EventDisplayNumber.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Width>0.16667in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<Left>0.1in</Left>
<Height>0.16667in</Height>
<Value>../reports_icon.png</Value>
</Image>
</ReportItems>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
<BorderColor>
<Default>Gray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Rectangle>
</ReportItems>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<Top>3.6in</Top>
<ColumnGroupings>
<ColumnGrouping>
<Height>0.2in</Height>
<DynamicColumns>
<Grouping Name="matrix1_PropertyID">
<GroupExpressions>
<GroupExpression>=Fields!PropertyID.Value</GroupExpression>
</GroupExpressions>
<DataElementName>Property</DataElementName>
<DataCollectionName>Properties</DataCollectionName>
</Grouping>
<Sorting>
<SortBy>
<SortExpression>=Fields!Position.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<ReportItems>
<Textbox Name="PropertyID">
<rd:DefaultName>PropertyID</rd:DefaultName>
<DataElementOutput>Output</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>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>Name</DataElementName>
<Value>= IIF(Fields!PropertyID.Value LIKE "Parameter*",
Code.FormatString(Code.GetLocTable("LT_Table").GetString("RT.Column." & "Parameter","[Parameter {0}]"),Replace(Fields!PropertyID.Value,"Parameter","",1,-1,1)),
Code.GetLocTable("LT_Table").GetString("RT.Column." & Fields!PropertyID.Value,"[" & Fields!PropertyID.Value & "]")
)</Value>
</Textbox>
</ReportItems>
</DynamicColumns>
</ColumnGrouping>
</ColumnGroupings>
<Width>1.65208in</Width>
<Corner>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<DataElementOutput>NoOutput</DataElementOutput>
<Visibility>
<Hidden>=IIF(Parameters!Interactive.Value,false,true)</Hidden>
</Visibility>
<Style>
<Color>White</Color>
<BackgroundColor>Gray</BackgroundColor>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<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>
<Value/>
</Textbox>
</ReportItems>
</Corner>
<CellDataElementName>PropertyItem</CellDataElementName>
<MatrixRows>
<MatrixRow>
<Height>0.4in</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="PropertyValue">
<rd:DefaultName>PropertyValue</rd:DefaultName>
<DataElementOutput>Output</DataElementOutput>
<Style>
<Color>=Switch
(
Fields!PropertyID.Value = "DateTime",
"Gray",
Fields!PropertyID.Value = "EventDisplayNumber",
"Gray",
Fields!PropertyID.Value = "EventLevelTitle",
"Gray",
Fields!PropertyID.Value Like "Parameter*",
"DimGray",
true,
"Black"
)</Color>
<BackgroundColor>=IIF(IsNothing(First(Fields!LocalisedPropertyValue.Value)),"Gainsboro",
IIF(RowNumber("matrix1_PropertyID") mod 2,"WhiteSmoke","Transparent"))</BackgroundColor>
<BorderColor>
<Default>Gray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontFamily>tahoma</FontFamily>
<FontSize>8pt</FontSize>
<TextAlign>=Switch
(
Fields!PropertyID.Value = "DateTime",
"Center",
Fields!PropertyID.Value = "EventLevelTitle",
"Center",
Fields!PropertyID.Value = "EventDisplayNumber",
"Center",
true,
"General"
)</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Value</DataElementName>
<Value>=IIF(Fields!PropertyID.Value="DateTime",Fields!FormattedDateTime.Value,Fields!LocalisedPropertyValue.Value)</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
<DataElementName>PropertyTable</DataElementName>
<Left>0.15in</Left>
</Matrix>
<Rectangle Name="rectangle5">
<Left>0.15in</Left>
<ZIndex>4</ZIndex>
<Top>1.5in</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.35in</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>10.15in</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>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.55in</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.15in</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>10.55in</Width>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.2in</Height>
</Rectangle>
<Image Name="banner_image">
<Sizing>AutoSize</Sizing>
<Top>0.1in</Top>
<Width>10.55208in</Width>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>1</ZIndex>
<Left>0.15in</Left>
<Height>0.64583in</Height>
<Value>../banner_landscape.jpg</Value>
</Image>
<Rectangle Name="rectangle2">
<Left>0.15in</Left>
<ReportItems>
<Rectangle Name="rectangle6">
<ZIndex>16</ZIndex>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>objectsParameterTitle</ToggleItem>
</Visibility>
<ReportItems>
<Line Name="line3">
<Top>0.04in</Top>
<Width>8.45in</Width>
<Style>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<ZIndex>1</ZIndex>
<Left>1.95in</Left>
<Height>0in</Height>
</Line>
<List Name="objectParameterList">
<Sorting>
<SortBy>
<SortExpression>=Fields!ManagementGroupDefaultName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!DisplayName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
<SortBy>
<SortExpression>=Fields!ManagedEntityDefaultName.Value</SortExpression>
<Direction>Ascending</Direction>
</SortBy>
</Sorting>
<DataSetName>ObjectList</DataSetName>
<Visibility>
<Hidden>true</Hidden>
<ToggleItem>objectsParameterTitle</ToggleItem>
</Visibility>
<ReportItems>
<Textbox Name="textbox43">
<Visibility>
<Hidden>=Fields!ManagedEntityUse.Value <> "Containment"</Hidden>
</Visibility>
<CanShrink>true</CanShrink>
<Width>8.45in</Width>
<Style>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Bottom</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<Height>0.2in</Height>
<Value>=Code.GetLocTable("LT_Report").GetString("R.ObjectUseContainment", "[All objects contained by:]")</Value>
</Textbox>
<Line Name="line1">
<Top>0.6in</Top>
<Width>8.45in</Width>
<Style>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<ZIndex>2</ZIndex>
<Left>1.95in</Left>
<Height>0in</Height>
</Line>
<Textbox Name="textbox10">
<CanShrink>true</CanShrink>
<Top>0.4in</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>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.95in</Left>
<Height>0.19in</Height>
<Value>=Code.FormatString(Code.GetLocTable("LT_Report").GetString("R.ObjectFormatLine2", "{0} {1}"), Fields!ManagementGroupDefaultName.Value, Code.NullFormatString(Code.GetLocTable("LT_Report").GetString("R.ObjectFormatLine2Path", "| {0}"), Fields!Path.Value))</Value>
</Textbox>
<Textbox Name="textbox36">
<CanShrink>true</CanShrink>
<Top>0.2in</Top>
<Width>8.45in</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!ManagedEntityDefaultName.Value)</Value>
</Textbox>
</ReportItems>
<Top>0.05in</Top>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<DataInstanceElementOutput>NoOutput</DataInstanceElementOutput>
</List>
</ReportItems>
<Top>0.65in</Top>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.7in</Height>
</Rectangle>
<Textbox Name="textbox28">
<DataElementOutput>NoOutput</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>
<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="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>14</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>13</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.65in</Top>
<MIMEType/>
<Source>External</Source>
<Style/>
<ZIndex>12</ZIndex>
<Value>../gradient_landscape.gif</Value>
</Image>
<Textbox Name="textbox14">
<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>11</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>10</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>9</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>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>8</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>7</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>6</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>5</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>4</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>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<DataElementName>StartDate</DataElementName>
<Height>0.2in</Height>
<Value>=Code.FormatDateTime("g", Code.GetReportStartDate())</Value>
</Textbox>
<Textbox Name="textbox22">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1.35in</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.ObjectFilterLabel", "[Objects Filtered By]")</Value>
</Textbox>
<Textbox Name="textbox19">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>1.35in</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>1</ZIndex>
<CanGrow>true</CanGrow>
<Left>1.85in</Left>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<List Name="objectFilterList">
<DataInstanceName>Filter</DataInstanceName>
<NoRows>---</NoRows>
<DataElementOutput>Output</DataElementOutput>
<Left>1.95in</Left>
<DataSetName>Filters</DataSetName>
<ReportItems>
<Textbox Name="textbox18">
<DataElementOutput>Output</DataElementOutput>
<Width>7.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>
<CanGrow>true</CanGrow>
<DataElementName>Value</DataElementName>
<Value>=Fields!FilterText.Value</Value>
</Textbox>
</ReportItems>
<Filters>
<Filter>
<FilterExpression>=IsNothing(Fields!FilterType.Value)</FilterExpression>
<Operator>Equal</Operator>
<FilterValues>
<FilterValue>=false</FilterValue>
</FilterValues>
</Filter>
</Filters>
<Top>1.35in</Top>
<Width>7.2in</Width>
<DataElementName>FilterList</DataElementName>
<Height>0.2in</Height>
</List>
</ReportItems>
<Top>1.55in</Top>
<Width>10.55in</Width>
<Height>1.7in</Height>
</Rectangle>
</ReportItems>
<Height>4.2in</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>=string.Format(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>=string.Format(Code.GetLocTable("LT_Report").GetString("R.TimeZoneFormat", "{0}"), Parameters!TimeZoneName.Value)</Value>
</Textbox>
</ReportItems>
<Height>0.35in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
</PageFooter>
<TopMargin>0.2in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>
</Definition>
<ReportStrings>
<ReportString ID="R.Title"/>
<ReportString ID="R.Description"/>
<ReportString ID="R.DescriptionTitle"/>
<ReportString ID="R.PageFormat"/>
<ReportString ID="R.TimeZoneFormat"/>
<ReportString ID="R.GeneratedTimeLabel"/>
<ReportString ID="R.StartEndTimeLabel"/>
<ReportString ID="R.StartEndTimeFormat"/>
<ReportString ID="R.BusinessTimeFormat"/>
<ReportString ID="R.ObjectsLabel"/>
<ReportString ID="R.ObjectsFormat"/>
<ReportString ID="R.ObjectFormatLine1"/>
<ReportString ID="R.ObjectFormatLine2"/>
<ReportString ID="R.ObjectFormatLine2Path"/>
<ReportString ID="R.ObjectUseContainment"/>
<ReportString ID="R.ObjectFilterLabel"/>
<ReportString ID="R.GroupByLabel"/>
<ReportString ID="R.ActionsLabel"/>
<ReportString ID="R.AllLabel"/>
<ReportString ID="RT.Column.EventDisplayNumber"/>
<ReportString ID="RT.Column.DateTime"/>
<ReportString ID="RT.Column.RuleDefaultName"/>
<ReportString ID="RT.Column.EventLevelTitle"/>
<ReportString ID="RT.Column.EventChannelTitle"/>
<ReportString ID="RT.Column.EventCategoryTitle"/>
<ReportString ID="RT.Column.EventPublisherName"/>
<ReportString ID="RT.Column.ManagedEntityDefaultName"/>
<ReportString ID="RT.Column.ManagedEntityTypeDefaultName"/>
<ReportString ID="RT.Column.ManagementGroupDefaultName"/>
<ReportString ID="RT.Column.ComputerName"/>
<ReportString ID="RT.Column.UserName"/>
<ReportString ID="RT.Column.Parameter"/>
<ReportString ID="D.EventType.Undefined"/>
<ReportString ID="D.EventType.Error"/>
<ReportString ID="D.EventType.Warning"/>
<ReportString ID="D.EventType.Information"/>
<ReportString ID="D.EventType.Success_Audit"/>
<ReportString ID="D.EventType.Failure_Audit"/>
</ReportStrings>
</Report>