question

ChrisGray-8628 avatar image
0 Votes"
ChrisGray-8628 asked ChrisGray-8628 edited

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-servicesmem-analytics-reporting
5 |1600 characters needed characters left characters exceeded

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

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

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

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

ChrisGray-8628 avatar image
0 Votes"
ChrisGray-8628 answered ChrisGray-8628 edited

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

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