Set-CMReportingServicePoint

Modifies a System Center Configuration Manager reporting service point.

Syntax

Set-CMReportingServicePoint
   [-Confirm]
   [-DatabaseName <String>]
   [-DatabaseServerName <String>]
   [-DisableWildcardHandling]
   [-ForceWildcardHandling]
   -InputObject <IResultObject>
   [-PassThru]
   [-UserName <String>]
   [-WhatIf]
   [<CommonParameters>]
Set-CMReportingServicePoint [-SiteSystemServerName]  [-Confirm] [-DatabaseName ]
 [-DatabaseServerName ] [-DisableWildcardHandling] [-ForceWildcardHandling] [-PassThru]
 [-SiteCode ] [-UserName ] [-WhatIf] []

Description

The Set-CMReportingServicePoint cmdlet modifies a Microsoft System Center Configuration Manager reporting service point. A reporting service point is a site system role that is installed on a server that is running Microsoft SQL Server Reporting Services.

Examples

Example 1: Set a reporting service point

PS C:\> Set-CMReportingServicePoint -SiteSystemServerName "Contoso-Test.Contoso.Com" -SiteCode "CM4" -UserName "Contoso\DavidChew"

The command sets a reporting service point by using the SiteSystemServerName parameter.

Example 2: Set a reporting service point by using a site system server name

PS C:\> Set-CMReportingServicePoint -SiteSystemServerName "Contoso-Test.Contoso.Com" -SiteCode "CM4" -DatabaseServerName "Contoso-TestDB.Contoso.Com" -DatabaseName "CM_CM2"

The command sets a reporting service point by using the SiteSystemServerName parameter.

Example 3: Set a reporting service point by using an input object

PS C:\> $RS = Get-CMReportingServicePoint -SiteSystemServerName "Contoso-Test.Contoso.Com" -SiteCode "CM4" 
PS C:\> Set-CMReportingServicePoint -InputObject $RS -DatabaseServerName "Contoso-TestDB.Contoso.Com" -DatabaseName "CM_CM4"

The first command uses the Get-CMReportingServicePoint cmdlet to get a reporting service point, by using the SiteSystemServerName parameter.

The second command uses the Set-CMReportingServicePoint cmdlet to set the reporting point by using the input object.

Required Parameters

-InputObject

Specifies an input object. To obtain an input object, use the Get-CMReportingServicePoint cmdlet.

Type:IResultObject
Aliases:ReportingServicePoint
Required:True
Position:Named
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-SiteSystemServerName

Specifies the name of a server hosting the site system role.

Type:String
Aliases:Name, ServerName
Required:True
Position:0
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Required:False
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-DatabaseName

Specifies the name of the Configuration Manager database that you want to use as the data source for reports from Microsoft SQL Server Reporting Services.

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

Specifies the name of the Configuration Manager database server that you want to use as the data source for the reports from Microsoft SQL Server Reporting Services. To specify a database instance, use the format <Server Name>\<Instance Name>.

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

Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.

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

Specifies a site code of a Configuration Manager site that hosts this system role.

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

Specifies a user name that Configuration Manager uses to connect with Microsoft SQL Server Reporting Services and that gives this user access to the site database.

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

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Required:False
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False