Configuration Manager - Default URL for reports in the admin console

Unfortunately, no "Change URL" button is provided here, which would have been useful in the event of a switch to HTTPS, or at least for forcing the FQDN name of the reporting server in place of the NetBIOS name.

How to change the default URL without resorting to reinstalling the reporting server (SRS Reporting Point) or directly editing the data in the SQL table?

As usual, the control of Configuration Manager is provided by WMI. So you need to connect to the SMS WMI Provider (usually located on the CM Primary Site Server), to the namespace root\SMSSite_{SMSSITECODE}, and then using the WQL query to get the default URL.

The property of interest is stored in an instance of the SMS_EmbeddedProperty class as the Value2 property, which is fortunately specified as writable.[1]

Replacing the ReportManager (and then ReportServer) URL can be done using a Powershell script[2]:

#Changing the default URL in the CM console for reports

$property = "ReportManagerUri"

#$property = "ReportServerUri"

$SMSSITECODE = "P00"

$SMSWMIPROVIDER = "WIN-DCLAB-CM"

$str1 = "http://win-dclab-sql/"

$str2 = "http://win-dclab-sql.dc.lab/"

$NAMESPACE = "rootSMSSite_" + $SMSSITECODE

$QUERY = 'SELECT * FROM SMS_SCI_SYSRESUSE WHERE rolename = "SMS SRS Reporting Point"'.

$RP = get-wmiobject -Namespace $NAMESPACE -Computername $SMSWMIPROVIDER -Query $QUERY

$props = $RP.props

$prop = $props | WHERE {$_.PropertyName -eq $property}

$NewURL = $prop.Value2.Replace($str1, $str2)

$prop.Value2 = $NewURL

$RP.props = $props

$RP.Put()

In the script, change the values of the variables to correspond to the names used ($SMSWMIPROVIDER , $str1 , $str2), and insert the correct CM Site code ($SMSSITECODE).

As a result of using the script twice (once for $property = "ReportManagerUri" , and then $property = "ReportServerUri") we get:

[1] https://learn.microsoft.com/en-us/mem/configmgr/develop/reference/core/servers/configure/sms_embeddedproperty-server-wmi-class

[2] The value setting is based on the script described in https://techcommunity.microsoft.com/t5/configuration-manager-archive/content-distribution-priorities/ba-p/273393