Informes analíticos avanzados disponibles en Service Manager

Importante

Esta versión de Service Manager ha llegado al final del soporte técnico. Se recomienda actualizar a Service Manager 2022.

Los siguientes informes analíticos , que se presentan como cubos de datos de procesamiento analítico en línea (OLAP) de Microsoft, están disponibles en Service Manager. Los cubos de datos que se incluyen en Service Manager contienen medidas y dimensiones.

Dimensions

Las siguientes dimensiones están contenidas en varios cubos de datos. Sin embargo, no todos los cubos de datos contienen cada dimensión.

  • 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 (DimFecha)
  • DeletionStatusDim
  • OperatingSystemDim
  • ProcessorDim
  • NetworkAdapterDim
  • LogicalDiskDim
  • PhysicalDiskDim
  • ImplementadoComputerDim
  • SLAConfigurationDim
  • SLAMetricDim
  • SLADatePropertyTimeMetricDim
  • CalendarDim
  • WorkItemGroupDim
  • BillableTimeDim
  • IncidentDim
  • ProblemDim
  • ReleaseRecordDim
  • SLAInstanceStatus
  • IncidentStatus
  • IncidentSource
  • IncidentTierQueues
  • IncidentClassification
  • IncidentResolutionCategory
  • IncidentImpact
  • IncidentUrgency
  • ProblemStatus
  • ProblemSource
  • ProblemClassification -ProblemResolution
  • ReleaseStatus
  • ReleaseType
  • ReleaseCategory
  • ReleasePriority
  • ReleaseImpact
  • ReleaseRisk
  • ReleaseImplementionResults
  • ReleaseTemplate
  • ReviewActivityDim
  • ServiceRequestDim
  • RequestOfferingDim
  • ServiceOfferingDim
  • OfferingDim
  • ReviewActivityApproval
  • ServiceRequestStatus
  • ServiceRequestTemplate
  • ServiceRequestPriority
  • ServiceRequestUrgency
  • ServiceRequestSource
  • ServiceRequestImplementationResults
  • ServiceRequestArea
  • ServiceRequestSupportGroup
  • OfferingStatus
  • ServiceOfferingCategory
  • ConfigurationManagerCollectionDim
  • PowerActivityRecordEventType
  • SoftwareUpdateDim

Cubo de datos de elemento de trabajo

El cubo de datos de elementos de trabajo contiene las siguientes medidas:

  • 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

Cubo de datos de administración de energía

El cubo de datos de administración de energía contiene las siguientes medidas:

  • ComputerHostsOperatingSystemCount
  • DeployedComputerRunsWindowsComputerCount
  • ConfigManagerCollectionHasComputerCount
  • Hour0
  • Hour1
  • Hour2
  • Hour3
  • Hour4
  • Hour5
  • Hour6
  • Hour7
  • Hour8
  • Hour9
  • Hour10
  • Hour11
  • Hour12
  • Hour13
  • Hour14
  • Hour15
  • Hour16
  • Hour17
  • Hour18
  • Hour19
  • Hour20
  • Hour21
  • Hour22
  • Hour23
  • PowerActivityDayCount
  • PowerActivityRecordEventTypeCount
  • ServiceContainsConfigItemCount
  • ServiceContainsComputerCount
  • ComputerDimCount
  • OperatingSystemDimCount
  • DeployedComputerDimCount
  • ConfigurationManagerCollectionDimCount
  • ServiceDimCount
  • ConfigItemDimCount

Cubo de datos de actualizaciones de software

El cubo de datos de actualizaciones de software contiene las siguientes medidas:

ComputerHostsOperatingSystemCount

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

Cubo de datos del catálogo de servicios

El cubo de datos del catálogo de servicios contiene las siguientes medidas:

  • 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

Cubo de datos de elemento de configuración

El cubo de datos de elementos de configuración contiene las siguientes medidas:

  • 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

Cubo de datos de administración de cambios y actividades

El cubo de datos de administración de cambios y actividades contiene las siguientes medidas:

  • 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