Configuration Items (CIs) with Most Incidents

ServiceManager.Report.ProblemManagement.CIsWithIncidents (Report)

This report provides a list of configuration items which have a minimum number of associated incidents. It also includes the number of change requests and problems associated with the specific configuration item.

Element properties:

Accessibility	Public
Visible	True

Report Localization:

*ReportName*	Configuration Items (CIs) with Most Incidents
*ReportDescriptionLabel*	Expand this section to see a full description of this report and any applicable filter criteria
*ReportDescription*	This report provides a list of configuration items which have a minimum number of associated incidents. It also includes the number of change requests and problems associated with the specific configuration item.
*ReportGeneratedLabel*	Report generated
*StartEndDateLabel*	Start and End Date
*DateFilterLabel*	Date Filter
*Classification*	Classification Category
*Source*	Source
*IncidentsPerCI*	Incidents per Configuration Item
*Priority*	Priority
*Urgency*	Urgency
*Impact*	Impact
*AffectedCIs*	Configuration Item
*IncidentCount*	Incidents
*ChangeRequestLinkedToCI*	Change Requests
*ProblemsLinkedToCI*	Problems
*NoData*	No Data
*DateFilter.CreatedOn*	Created Date
*DateFilter.ResolvedOn*	Resolved Date
*DateFilter.ClosedOn*	Closed Date
*All*	(All)
*NoCIsMessage*	No Configuration Items to display

Source Code:

<Report ID="ServiceManager.Report.ProblemManagement.CIsWithIncidents" Accessibility="Public" Target="Problem!System.WorkItem.Problem" Visible="true">

  <Dependencies>

    <Dimension>DWBase!UserDim</Dimension>

    <Dimension>ProblemDW!ProblemDim</Dimension>

    <DataWarehouseScript>ServiceManager.Report.ProblemManagement.SP.GetCIsWithMostIncidentsData.Script</DataWarehouseScript>

    <DataWarehouseScript>SMReportCommon!ServiceManager.Report.Common.Function.fn_CSVToTableString.Script</DataWarehouseScript>

    <DataWarehouseScript>SMReportCommon!ServiceManager.Report.Common.Function.fn_CSVToTableInt.Script</DataWarehouseScript>

    <ReportResource>SMReportCommon!Report_Header_Potrait.png</ReportResource>

    <ReportResource>SMReportCommon!Report_Header_Landscape.png</ReportResource>

    <ReportResource>SMReportCommon!horizontal_line_gradient.png</ReportResource>

  </Dependencies>

  <ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="3">

    <Controls>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.SingleValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="DateFilter">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.DateFilter</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="2" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDatePickerValueEditor">

        <ReportParameters>

          <ReportParameter name="TimeZone" binding="TimeZone">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.TimeZone</Prompt>

          </ReportParameter>

          <ReportParameter name="TimeZoneName" binding="TimeZoneName"/>

          <ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>

          <ReportParameter name="StartDate_BaseValue" binding="StartDate_BaseValue">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.StartDate</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>ServiceManager.ProblemManagement.Report.Library!ReportParameter.EndDate</Prompt>

          </ReportParameter>

          <ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>

          <ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.StringValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="IncidentsPerCI">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.IncidentsPerCI</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Source">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.Source</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>IncidentSource</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.IncidentManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Classification">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.Classification</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>IncidentClassification</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.IncidentManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Impact">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.Impact</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>IncidentImpact</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.IncidentManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.OutriggerPickerValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Urgency">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.Urgency</Prompt>

          </ReportParameter>

        </ReportParameters>

        <Properties>

          <Property name="MinHeight">

            <Value>40</Value>

          </Property>

          <Property name="MinWidth">

            <Value>100</Value>

          </Property>

          <Property name="OutriggerTypeName">

            <Value>IncidentUrgency</Value>

          </Property>

          <Property name="OutriggerTypeMPName">

            <Value>ServiceManager.IncidentManagement.Library.Datawarehouse</Value>

          </Property>

          <Property name="OutriggerSelectAllValue">

            <Value>-1</Value>

          </Property>

        </Properties>

      </Control>

      <Control rowSpan="1" columnSpan="1" type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.MultiValueParameterEditor">

        <ReportParameters>

          <ReportParameter name="Priority">

            <Prompt>ServiceManager.ProblemManagement.Report.Library!ReportParameter.Priority</Prompt>

          </ReportParameter>

        </ReportParameters>

      </Control>

    </Controls>

  </ParameterBlock>

  <ReportDefinition>ServiceManager.Report.ProblemManagement.CIsWithIncidents.ReportRdl</ReportDefinition>

  <ReportStrings>

    <ReportString ID="ReportName"/>

    <ReportString ID="ReportDescriptionLabel"/>

    <ReportString ID="ReportDescription"/>

    <ReportString ID="ReportGeneratedLabel"/>

    <ReportString ID="StartEndDateLabel"/>

    <ReportString ID="DateFilterLabel"/>

    <ReportString ID="Classification"/>

    <ReportString ID="Source"/>

    <ReportString ID="IncidentsPerCI"/>

    <ReportString ID="Priority"/>

    <ReportString ID="Urgency"/>

    <ReportString ID="Impact"/>

    <ReportString ID="AffectedCIs"/>

    <ReportString ID="IncidentCount"/>

    <ReportString ID="ChangeRequestLinkedToCI"/>

    <ReportString ID="ProblemsLinkedToCI"/>

    <ReportString ID="NoData"/>

    <ReportString ID="DateFilter.CreatedOn"/>

    <ReportString ID="DateFilter.ResolvedOn"/>

    <ReportString ID="DateFilter.ClosedOn"/>

    <ReportString ID="All"/>

    <ReportString ID="NoCIsMessage"/>

  </ReportStrings>

</Report>