How to update report URL in subscribed reports to use FQDN

Question

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

Answer 1

Hi @ChrisGray ,
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.

Answer 2

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