Get-CMDatabaseProperty

Gets an object that represents a Configuration Manager database.

Syntax

Get-CMDatabaseProperty
   [-SiteCode <String>]
   [-DisableWildcardHandling]
   [-ForceWildcardHandling]
   [<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

DisableWildcardHandling treats wildcard characters as literal character values. Cannot be combined with ForceWildcardHandling.

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

ForceWildcardHandling processes wildcard characters and may lead to unexpected behavior (not recommended). Cannot be combined with DisableWildcardHandling.

Type:SwitchParameter
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
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False