Set-CMReportingServicePoint

Modifies a Configuration Manager reporting service point.

Syntax

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

Description

The Set-CMReportingServicePoint cmdlet modifies a 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.

Note

Configuration Manager cmdlets must be run from the Configuration Manager site drive. The examples in this article use the site name XYZ. For more information, see the getting started documentation.

Examples

Example 1: Set a reporting service point

PS XYZ:\> 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 XYZ:\> 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 XYZ:\> $RS = Get-CMReportingServicePoint -SiteSystemServerName "Contoso-Test.Contoso.Com" -SiteCode "CM4"
PS XYZ:\> 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.

Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

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

{{ Fill Force Description }}

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
-InputObject

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

Type:IResultObject
Aliases:ReportingServicePoint
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-PassThru

Returns the current working object. By default, this cmdlet does not generate any output.

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

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

Type:String
Aliases:Name, ServerName
Position:0
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
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
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False

Inputs

Microsoft.ConfigurationManagement.ManagementProvider.IResultObject

Outputs

IResultObject