Set-CMReportingServicePoint

Set-CMReportingServicePoint

Modifies a System Center 2012 Configuration Manager reporting service point.

Syntax

Parameter Set: SetByName
Set-CMReportingServicePoint -SiteCode <String> -SiteSystemServerName <String> [-DatabaseName <String> ] [-DatabaseServerName <String> ] [-UserName <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameter Set: SetByValue
Set-CMReportingServicePoint -InputObject <IResultObject> [-DatabaseName <String> ] [-DatabaseServerName <String> ] [-UserName <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed Description

The Set-CMReportingServicePoint cmdlet modifies a Microsoft System Center 2012 SP1 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.

Parameters

-DatabaseName<String>

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.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-DatabaseServerName<String>

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

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-InputObject<IResultObject>

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

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-SiteCode<String>

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

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-SiteSystemServerName<String>

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

Aliases

none

Required?

true

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-UserName<String>

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.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-Confirm

Prompts you for confirmation before running the cmdlet.

Required?

false

Position?

named

Default Value

false

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WhatIf

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

Required?

false

Position?

named

Default Value

false

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see    about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

Examples

Example 1: Set a reporting service point

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

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

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

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

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

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

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.

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"

Add-CMReportingServicePoint

Get-CMReportingServicePoint

Remove-CMReportingServicePoint