How to update report URL in subscribed reports to use FQDN

Question

question

ChrisGray-8628 asked Nov 12, '20 ChrisGray-8628 edited Nov 13, '20

How to update report URL in subscribed reports to use FQDN

I was just asked yesterday if there was a way to have the report URL for ConfigMgr subscribed reports to use the FQDN of the server instead of the NetBIOS name of the server. I've searched around and see general SSRS questions on this, but nothing that I saw was ConfigMgr specific.

When we have a report that is sent out via email, a link to the report is included in that email.

An example is the link looks like this.
http://server/ReportServer?%2FConfigMgr_P00%2FOperating%20System%2FCount%20operating%20system%20versions&rs%3AParameterLanguage=en-US

I'm told this link doesn't work from some users (outside of our internal DNS)

Is it possible, and if so, what's required to have the URL look like this included with the email.?

http://server.domain.com/ReportServer?%2FConfigMgr_P00%2FOperating%20System%2FCount%20operating%20system%20versions&rs%3AParameterLanguage=en-US

Edit: CB 2006 / MP is 2012 R2 running SQL 2012 SP4 on the same server.

Thanks in advance.
-Chris

sql-server-reporting-services mem-analytics-reporting

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2020-11-13T07:00:50.697Z

Joyzhao-MSFT answered Nov 13, '20

Hi @ChrisGray-8628 ,
The report server e-mail delivery extension uses the UrlRoot setting in the configuration file to create the link.
And when UrlRoot is set to a specific value, the explicit value is used.
So you could set the UrlRoot with your FQDN address.
See reference : SSRS Subscriptions - report link from email does not use server Alias
Regards,
Joy

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2020-11-13T18:33:47.48Z

ChrisGray-8628 answered Nov 13, '20 ChrisGray-8628 edited Nov 13, '20

Thank you, I found this one too, which I ended up using.

After making the change to the URLRoot it had corrected my issue.

https://stackoverflow.com/questions/52320279/edit-url-link-to-report-server-within-ssrs-subscription

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question