Service Manager Data Warehouse Cmdlets

The following list contains links to the help topics for the data warehouse cmdlets:

Name Description

Disable-SCDWJob

Disables a data warehouse job to prevent it from running in the future.

Disable-SCDWJobCategory

Disables all jobs within a job category.

Disable-SCDWJobSchedule

Disables a Data Warehouse job schedule, which causes the job schedule to stop initiating jobs. Disabling the job schedule retains the job schedule settings. To modify the job schedule settings, you run the Set-SCDWJobSchedule cmdlet.

Disable-SCDWSource

Disables all jobs that are affiliated with the specified data source.

Enable-SCDWJob

Enables a data warehouse job, which allows it to run according to its specified schedule or to be started manually with the Start-SCDWJob cmdlet.

Enable-SCDWJobCategory

Enables all data warehouse jobs within the specified category.

Enable-SCDWJobSchedule

Enables a job schedule so that a job runs according to its specified schedule.

Enable-SCDWSource

Enables all jobs that are associated with the specified data source.

Get-SCDWEntity

Gets the list of fact tables, dimensions, tables, and outriggers that exist in a data warehouse.

Get-SCDWJob

Gets the list of all data warehouse jobs, displaying information such as the status of these jobs.

Get-SCDWJobModule

Returns detailed status information about the modules of the specified job.

Get-SCDWJobSchedule

The Get-SCDWJobSchedule cmdlet displays scheduling information for data warehouse jobs.

Get-SCDWRetentionPeriod

Gets the data retention period in minutes for either a specific fact table within a specific data warehouse database or the default for fact tables within the database.

Get-SCDWSource

Gets specific instances of data sources which are registered to the data warehouse.

Get-SCDWSourceType

Gets the types of data sources that can be registered to the data warehouse.

Get-SCDWWatermark

Gets the latest watermark for the specified job module.

New-SCDWSourceType

Creates a new type of data source that can be registered to the data warehouse. Each data source type is defined by the classes and the relationships in the management pack bundle that is imported when you define the data source type.

Register-SCDWSource

Registers instances of data source types, such as Service Manager, Operations Manager, and Configuration Manager, to the data warehouse.

Set-SCDWJobSchedule

Sets the schedule for a data warehouse job.

Set-SCDWRetentionPeriod

Sets the data retention period in minutes for either a specific fact table within a specific data warehouse database, or sets the default for fact tables within the database. Data that is eligible for grooming and older than the retention period will be groomed out of the database.

Set-SCDWSource

Updates the definition of classes and relationships that can be populated for an instance of a data source.

Set-SCDWWatermark

Sets the watermark from which subsequent data processing should continue.

Start-SCDWJob

Starts a data warehouse job.

Stop-SCDWJob

Stops a data warehouse job.

Unregister-SCDWManagementPack

Removes a management pack directly from the data warehouse.

Unregister-SCDWSource

Unregisters a data source from the data warehouse.