Erweiterte analytische Berichte in Service Manager

Wichtig

Diese Version von Service Manager das Ende des Support erreicht hat. Es wird empfohlen, dass Sie ein Upgrade auf Service Manager 2019 durchführen.

Die folgenden analytischen Berichte, die als OLAP-Datencubes (Microsoft Online Analytical Processing) dargestellt werden, sind in Service Manager. Die Datencubes, die in der Service Manager enthalten sind, enthalten Measures und Dimensionen.

Dimensionen

Die folgenden Dimensionen sind in verschiedenen Datencubes enthalten. Allerdings enthalten nicht alle Datencubes jede Dimension.

  • WorkItemDim
  • ConfigItemDim
  • UserDim
  • ComputerDim
  • ChangeRequestDim
  • ReviewerDim
  • SerivceDim
  • ConfigItemObjectStatus
  • ConfigItemAssetStatus
  • ActivityStatus
  • ActivityPriority
  • ActivityArea
  • ActivityStage
  • ChangeStatus -Change Category
  • ChangePriority
  • ChangeImpact
  • ChangeRisk
  • ChangeImplementationResults
  • ChangeArea
  • ReviewerDecision
  • ServiceStatus
  • ServiceClassification
  • ServicePriority
  • DateDim
  • DeletionStatusDim
  • OperatingSystemDim
  • ProcessorDim
  • NetworkAdapterDim
  • LogicalDiskDim
  • PhysicalDiskDim
  • DeployedComputerDim
  • SLAConfigurationDim
  • SLAMetricDim
  • SLADatePropertyTimeMetricDim
  • CalendarDim
  • WorkItemGroupDim
  • BillableTimeDim
  • IncidentDim
  • ProblemDim
  • ReleaseRecordDim
  • SLAInstanceStatus
  • IncidentStatus
  • IncidentSource
  • IncidentTierQueues
  • IncidentClassification
  • IncidentResolutionCategory
  • IncidentImpact
  • IncidentEncy
  • ProblemStatus
  • ProblemSource
  • ProblemClassification -ProblemResolution
  • ReleaseStatus
  • ReleaseType
  • ReleaseCategory
  • ReleasePriority
  • ReleaseImpact
  • ReleaseRisk
  • ReleaseImplementionResults
  • ReleaseTemplate
  • ReviewActivityDim
  • ServiceRequestDim
  • RequestOfferingDim
  • ServiceOfferingDim
  • OfferingDim
  • ReviewActivityApproval
  • ServiceRequestStatus
  • ServiceRequestTemplate
  • ServiceRequestPriority
  • ServiceRequestEncy
  • ServiceRequestSource
  • ServiceRequestImplementationResults
  • ServiceRequestArea
  • ServiceRequestSupportGroup
  • OfferingStatus
  • ServiceOfferingCategory
  • ConfigurationManagerCollectionDim
  • PowerActivityRecordEventType
  • SoftwareUpdateDim

Arbeitselement-Datencube

Der Datencube für Arbeitselemente enthält folgende Measures:

  • SLAInstanceInformationCount
  • SLAInstanceStatusCount
  • SLAConfigurationHasMetricCount
  • SLAConfigurationHasCalendarCount
  • WorkItemGroupContainsWorkItemCount
  • WorkItemIsAboutConfigItemCount
  • WorkItemCreatedByUserCount
  • WorkItemAssignedToUserCount
  • WorkItemAffectedByUserCount
  • WorkItemRelatesToConfigItemCount
  • WorkItemRelatesToWorkItemCount
  • WorkItemHasBillableTimeCount
  • BillableTimeBilledByUserCount
  • TotalTimeMeasure
  • IncidentStatusDurationCount
  • IncidentStatusCount
  • IncidentResolutionByUserCount
  • IncidentPrimaryUserCount
  • IncidentIsAboutConfigItemCount
  • IncidentCreatedByUserCount
  • IncidentAssignedToUserCount
  • IncidentAffectedByUserCount
  • IncidentRelatesToConfigItemCount
  • IncidentRelatesToWorkItemCount
  • IncidentHasBillableTimeCount
  • IncidentRelatesToProblemCount
  • IncidentSLAInstanceInformationCount
  • WorkItemGroupContainsIncidentCount
  • ProblemResolutionByUserCount
  • ProblemIsAboutConfigItemCount
  • ProblemCreatedByUserCount
  • ProblemAssignedToUserCount
  • ProblemAffectedByUserCount
  • ProblemRelatesToConfigItemCount
  • ProblemRelatesToWorkItemCount
  • ProblemHasBillableTimeCount
  • ProblemSLAInstanceInformationCount
  • ReleaseIsAboutConfigItemCount
  • ReleaseCreatedByUserCount
  • ReleaseAssignedToUserCount
  • ReleaseSLAInstanceInformationCount
  • WorkItemIsAboutComputerCount
  • WorkItemIsAboutServiceCount
  • ServiceContainsConfigItemCount
  • ServiceContainsComputerCount
  • WorkItemDimCount
  • SLAConfigurationDimCount
  • SLAMetricDimCount
  • SLADatePropertyTimeMetricDimCount
  • CalendarDimCount
  • WorkItemGroupDimCount
  • ConfigItemDimCount
  • UserDimCount
  • BillableTimeDimCount
  • TimeWorkedSum
  • IncidentDimCount
  • IncidentsResolvedCount
  • IncidentsResolvedWithinTargetResolutionTimeCount -IncidentsResolutionTimeInHoursSum
  • IncidentsPastTargetResolutionTimeCount
  • ProblemDimCount
  • ReleaseRecordDimCount
  • ReleasesImplementedOnScheduleCount
  • ComputerDimCount
  • ServiceDimCount

Datencube für die Energieverwaltung

Der Datencube für die Energieverwaltung enthält folgende Measures:

  • ComputerHostsOperatingSystemCount
  • DeployedComputerRunsWindowsComputerCount
  • ConfigManagerCollectionHasComputerCount
  • Stunde0
  • Stunde1
  • Stunde2
  • Stunde3
  • Stunde4
  • Stunde5
  • Stunde6
  • Stunde7
  • Stunde8
  • Stunde9
  • Stunde10
  • Stunde11
  • Stunde12
  • Stunde13
  • Stunde14
  • Stunde15
  • Stunde16
  • Stunde17
  • Stunde18
  • Stunde19
  • Stunde20
  • Stunde21
  • Stunde22
  • Stunde23
  • PowerActivityDayCount
  • PowerActivityRecordEventTypeCount
  • ServiceContainsConfigItemCount
  • ServiceContainsComputerCount
  • ComputerDimCount
  • OperatingSystemDimCount
  • DeployedComputerDimCount
  • ConfigurationManagerCollectionDimCount
  • ServiceDimCount
  • ConfigItemDimCount

Datencube für Softwareupdates

Der Datencube für Softwareupdates enthält folgende Measures:

ComputerHostsOperatingSystemCount

  • DeployedComputerRunsWindowsComputerCount
  • ConfigurationManagerCollectionHasComputerCount
  • IsInstalled
  • IsMissing
  • IsUnknown
  • ComputerHasSoftwareUpdateCount
  • ServiceContainsConfigItemCount
  • ServiceContainsComputerCount
  • ComputerDimCount
  • OperatingSystemDimCount
  • DeployedComputerDimCount
  • ConfigurationManagerCollectionDimCount
  • SoftwareUpdateDimCount
  • ServiceDimCount
  • ConfigItemDimCount

Dienstkatalog-Datencube

Der Datencube für den Dienstkatalog enthält folgende Measures:

  • SLAConfigurationHasMetricCount
  • SLAConfigurationHasCalendarCount
  • ActivityIsAboutConfigItemCount
  • ActivityCreatedByUserCount
  • ActivityAssignedToUserCount
  • ActivityRelatesToConfigItemCount
  • ActivityRelatesToWorkItemCount
  • ActivityTotalTimeMeasure
  • ActivityStatusDurationCount
  • ActivityStatusCount
  • ReviewActivityHasReviewerCount
  • ReviewerIsReviewerUserCount
  • ReviewerVotedByUserCount
  • ReviewActivityRelatesToConfigItemCount
  • ReviewActivityAssignedToUserCount
  • ReviewActivityCreatedByUserCount
  • WorkItemGroupContainsServiceRequestCount
  • ServiceRequestIsAboutConfigItemCount
  • ServiceRequestCreatedByUserCount
  • ServiceRequestAssignedToUserCount
  • ServiceRequestRelatesToConfigItemCount
  • ServiceRequestRelatesToWorkItemCount
  • ServiceRequestAffectedUserCount
  • ServiceRequestContainsActivityCount
  • ServiceRequestTotalTimeMeasure
  • ServiceRequestStatusDurationCount
  • ServiceRequestStatusCount
  • ServiceRequestSLAInstanceInformationCount
  • SLAInstanceStatusCount
  • ServiceRequestRelatesToRequestOfferingCount
  • ServiceOfferingRelatesToRequestOfferingCount
  • ServiceOfferingPublishedByUserCount
  • RequestOfferingPublishedByUserCount
  • ServiceOfferingOwnerCount
  • RequestOfferingOwnerCount
  • ServiceRelatesToServiceOfferingCount
  • SLAConfigurationDimCount
  • SLAMetricDimCount
  • SLADatePropertyTimeMetricDimCount
  • CalendarDimCount
  • WorkItemDimCount
  • ConfigItemDimCount
  • ActivityDimCount
  • UserDimCount
  • ReviewerDimCount
  • ReviewActivityDimCount
  • WorkItemGroupDimCount
  • ServiceRequestDimCount
  • RequestOfferingDimCount
  • ServiceOfferingDimCount -OfferingDimCount
  • ServiceDimCount

Datencube für Konfigurationselement

Der Datencube für Konfigurationselemente enthält folgende Measures:

  • ConfigItemRelatesToConfigItemCount
  • ComputerPrimaryUserCount
  • ComputerHostsOperatingSystemCount
  • ComputerHostsProcessorCount
  • ComputerHostsNetworkAdapterCount
  • ComputerHostsLogicalDiskCount
  • ComputerHostsPhysicalDiskCount
  • ServiceImpactsUserCount
  • ConfigItemOwnedByUserCount
  • ConfigItemServicedByUserCount
  • ConfigItemImpactsCustomersCount
  • DeployedComputerRunsWindowsComputerCount
  • ServiceContainsConfigItemCount
  • ServiceContainsComputerCount
  • ConfigItemDimCount
  • ComputerDimCount
  • UserDimCount
  • OperatingSystemDimCount
  • TotalRAMInMB
  • ProcessorDimCount
  • TotalProcessorSpeed
  • NetworkAdapterDimCount
  • LogicalDiskDimCount
  • TotalDiskSpace
  • PhysicalDiskDimCount
  • ServiceDimCount
  • DeployedComputerDimCount

Änderungs- und Aktivitätsverwaltungsdatencube

Der Datencube für Change-Management und Aktivitätenverwaltung enthält folgende Measures:

  • WorkItemIsAboutConfigItemCount
  • WorkItemCreatedByUserCount
  • WorkItemAssignedToUserCount
  • WorkItemRelatesToWorkItemCount
  • ActivityIsAboutConfigItemCount
  • ActivityCreatedByUserCount
  • ActivityAssignedToUserCount
  • ActivityRelatesToWorkItemCount
  • ActivityIsAboutComputerCount
  • ChangeRequestIsAboutConfigItemCount
  • ChangeRequestCreatedByUserCount
  • ChangeRequestAssignedToUserCount
  • ChangeRequestRelatesToWorkItemCount
  • ChangeRequestContainsActivityCount
  • ChangeRequestIsAboutComputerCount
  • ReviewActivityHasReviewerCount
  • ReviewerIsReviewerUserCount
  • ReviewerVotedByUserCount
  • ReviewActivityRelatesToConfigItemCount
  • ReviewActivityAssignedToUserCount
  • ReviewActivityCreatedByUserCount
  • WorkItemIsAboutComputerCount
  • ActivityRelatesToChangeRequestCount
  • ServiceContainsConfigItemCount
  • ServiceContainsComputerCount
  • WorkItemDimCount
  • ConfigItemDimCount
  • UserDimCount
  • ActivityDimCount
  • ActivitiesImplementedCount
  • ActivitiesImplementedOnScheduleCount
  • ComputerDimCount
  • ChangeRequestDimCount
  • ChangeRequestsImplementedCount
  • ChangeRequestsImplementedOnScheduleCount
  • EmergencyChangeRequestsCount
  • ProcessTimePerChangeInDaysSum
  • ReviewerDimCount
  • ServiceDimCount