Get-CMDatabaseProperty

Gets an object that represents a Configuration Manager database.

Syntax

Get-CMDatabaseProperty
   [-DisableWildcardHandling]
   [-ForceWildcardHandling]
   [-SiteCode <String>]
   [<CommonParameters>]

Description

The Get-CMDatabaseProperty cmdlet gets an object that represents a Microsoft System Center Configuration Manager database. Use the site code for a site to specify a database.

When this cmdlet returns a database object in the console, it displays current settings for data compression, Broker port for the computer that runs Microsoft SQL Server, and the length of time that the database keeps data. You can use the Set-CMDatabaseProperty cmdlet to change these values.

Examples

Example 1: Get a database property

PS C:\> Get-CMDatabaseProperty -SiteCode "CM2"
Key                                     Value
---                                     -----
SQL Server Service Broker Port          80 
Retention Period                        10 
IsCompression                           0

This command gets the database property for the site that has the site code CM2.

Optional Parameters

-DisableWildcardHandling

Indicates that wildcard handling is disabled.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ForceWildcardHandling

Indicates that wildcard handling is enabled.

Type:SwitchParameter
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-SiteCode

Specifies the site code for a Configuration Manager site.

Type:String
Required:False
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False