All Data Warehouse Scripts in category: System Center Service Manager 2019 - Management Packs

IDManagement Pack NameManagement Pack Version
ADOInterfaceMicrosoft.SystemCenter.Warehouse.System10.19.1035.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.AlertMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.AlertDetailMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.AlertLoggingLatencyMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.AvailabilityMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.AvailabilityMonitorMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.AvailabilityTimeMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.ConfigurationChangeMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.CustomConfigurationMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.CustomConfigurationColumnMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.CustomPerformanceMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.EventAnalysisMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.EventTemplateMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.GetRulesByObjectsAndCountersMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.GetUnitsListMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.LicenseMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.MostCommonAlertsMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.MostCommonAlertsGraphMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.MostCommonEventsMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.MostCommonEventsGraphMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.ObjectListMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.ObjectListParseMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.OverrideMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.PerformanceMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.PerformanceTopMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Report.Script.PerformanceTopInstanceMicrosoft.SystemCenter.DataWarehouse.Report.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Script.DatasetDebuggingSupportMicrosoft.SystemCenter.DataWarehouse.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Script.MemberDatabaseMicrosoft.SystemCenter.DataWarehouse.Library10.19.10040.0
Microsoft.SystemCenter.DataWarehouse.Script.StandardDatasetSupportMicrosoft.SystemCenter.DataWarehouse.Library10.19.10040.0
ServiceManager.Report.ActivityManagement.SP.ActivitiesDistribution.ScriptServiceManager.ActivityManagement.Report.Library10.19.1035.0
ServiceManager.Report.ActivityManagement.SP.GetListOfManualActivities.ScriptServiceManager.ActivityManagement.Report.Library10.19.1035.0
ServiceManager.Report.ActivityManagement.SP.GetListOfReviewActivities.ScriptServiceManager.ActivityManagement.Report.Library10.19.1035.0
ServiceManager.Report.ActivityManagement.SP.GetManualActivityDetails.ScriptServiceManager.ActivityManagement.Report.Library10.19.1035.0
ServiceManager.Report.ActivityManagement.SP.GetReviewActivityDetails.ScriptServiceManager.ActivityManagement.Report.Library10.19.1035.0
ServiceManager.Report.ActivityManagement.SP.ReportOptimizations.ScriptServiceManager.ActivityManagement.Report.Library10.19.1035.0
ServiceManager.Report.ChangeManagement.SP.GetChangeManagementKPITrendData.ScriptServiceManager.ChangeManagement.Report.Library10.19.1035.0
ServiceManager.Report.ChangeManagement.SP.GetListOfRFCs.ScriptServiceManager.ChangeManagement.Report.Library10.19.1035.0
ServiceManager.Report.ChangeManagement.SP.ReportOptimizations.ScriptServiceManager.ChangeManagement.Report.Library10.19.1035.0
ServiceManager.Report.Common.Function.fn_CSVToTableInt.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.Common.Function.fn_CSVToTableString.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.Common.SP.GetCIsImpactedByWI.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.Common.SP.GetCIsRelatedToWI.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.Common.SP.GetServicesAffectedByWI.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.Common.SP.GetServicesImpactedByWI.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.Common.SP.GetWIsRelatedToWI.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.Common.SP.ReportOptimizations.ScriptServiceManager.Common.Report.Library10.19.1035.0
ServiceManager.Report.ConfigurationManagement.SP.ComputerInventoryGetData.ScriptServiceManager.ConfigurationManagement.Report.Library10.19.1035.0
ServiceManager.Report.ConfigurationManagement.SP.GetComputerDetails.ScriptServiceManager.ConfigurationManagement.Report.Library10.19.1035.0
ServiceManager.Report.ConfigurationManagement.SP.GetListOfServices.ScriptServiceManager.ConfigurationManagement.Report.Library10.19.1035.0
ServiceManager.Report.ConfigurationManagement.SP.GetServiceSummary.ScriptServiceManager.ConfigurationManagement.Report.Library10.19.1035.0
ServiceManager.Report.ConfigurationManager.SP.GetPowerActivityData.ScriptServiceManager.ConfigurationManager.Report.Library10.19.1035.0
ServiceManager.Report.IncidentManagement.Optimizations.ScriptServiceManager.IncidentManagement.Report.Library10.19.1035.0
ServiceManager.Report.IncidentManagement.SP.GetIncidentDetails.ScriptServiceManager.IncidentManagement.Report.Library10.19.1035.0
ServiceManager.Report.IncidentManagement.SP.GetIncidentKPITrendData.ScriptServiceManager.IncidentManagement.Report.Library10.19.1035.0
ServiceManager.Report.IncidentManagement.SP.GetIncidentMetrics.ScriptServiceManager.IncidentManagement.Report.Library10.19.1035.0
ServiceManager.Report.IncidentManagement.SP.GetIncidentResolutionData.ScriptServiceManager.IncidentManagement.Report.Library10.19.1035.0
ServiceManager.Report.IncidentManagement.SP.GetListOfIncidents.ScriptServiceManager.IncidentManagement.Report.Library10.19.1035.0
ServiceManager.Report.IncidentManagement.SP.IncidentAnalystGetData.ScriptServiceManager.IncidentManagement.Report.Library10.19.1035.0
ServiceManager.Report.ProblemManagement.SP.GetCIsWithMostIncidentsData.ScriptServiceManager.ProblemManagement.Report.Library10.19.1035.0
ServiceManager.Report.ProblemManagement.SP.GetListOfProblems.ScriptServiceManager.ProblemManagement.Report.Library10.19.1035.0
ServiceManager.Report.ReleaseManagement.SP.GetAllActivitiesOfReleaseRecord.ScriptServiceManager.ReleaseManagement.Report.Library10.19.1035.0
ServiceManager.Report.ReleaseManagement.SP.GetListOfReleaseRecords.ScriptServiceManager.ReleaseManagement.Report.Library10.19.1035.0
ServiceManager.Report.ReleaseManagement.SP.ReportOptimizations.ScriptServiceManager.ReleaseManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetCMCollectionContainsComputersMap.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetCMCollectionGroupData.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetCMCollectionSummaryData.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetOMGroupContainsComputersMap.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetOMGroupGroupData.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetOMGroupSummaryData.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetServiceContainsComputersMap.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetSMServiceGroupData.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
ServiceManager.Report.ServiceManagement.SP.GetSMServiceSummaryData.ScriptServiceManager.ServiceManagement.Report.Library10.19.1035.0
TransformAlertCategoryProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertCustomFieldDimProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertCustomFieldFactProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertDimProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertInstanceDimProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertInstanceFactProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertParameterDimProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertParameterFactProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertPriorityProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertResolutionStateFactProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertSeverityProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformAlertSiteProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformComputerHasSoftwareUpdateInstalledFactProcMicrosoft.SystemCenter.ConfigurationManager.Datawarehouse10.19.1035.0
TransformDataSourceDimProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformDisplayStringDimProcMicrosoft.SystemCenter.Warehouse.System10.19.1035.0
TransformEntityDimProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformEntityManagedTypeFactProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformEntityRelatesToEntityFactProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformGroupContainsConfigItemFactProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformInfraChargebackDailyFactProcServiceManager.Chargeback.DataWarehouse.Infrastructure10.19.1035.0
TransformInfraChargebackMonthlyFactProcServiceManager.Chargeback.DataWarehouse.Infrastructure10.19.1035.0
TransformManagedTypeDimProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformManagementPackDimProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformMonitorDimProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformPowerActivityDayFactProcMicrosoft.SystemCenter.ConfigurationManager.Datawarehouse10.19.1035.0
TransformPricesheetDetailDailyFactProcServiceManager.Chargeback.DataWarehouse.Common10.19.1035.0
TransformRelationshipTypeDimProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformResolutionStateDimProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformRuleProcMicrosoft.SystemCenter.Datawarehouse.OM10.19.1035.0
TransformServiceContainsConfigItemFactProcMicrosoft.SystemCenter.Datawarehouse.Base10.19.1035.0
TransformSLAInstanceInformationFactProcServiceManager.SLAManagement.Library.Datawarehouse10.19.1035.0
TransformVirtualDiskDriveSnapshotFactProcServiceManager.Chargeback.DataWarehouse.Infrastructure10.19.1035.0
TransformVirtualNicSnapshotFactProcServiceManager.Chargeback.DataWarehouse.Infrastructure10.19.1035.0