SCCM report subscription ssrs Symptoms
What can you do when your SCCM report subscription SSRS does not list email in the drop-down menu?
Microsoft definition :
A Reporting Services subscription is a configuration that delivers a report at a specific time or in response to an event, and in a file format that you specify. For example, every Wednesday, save the MonthlySales.rdl report as a Microsoft Word document to a file share. Subscriptions can be used to schedule and automate the delivery of a report and with a specific set of report parameter values.
You can create multiple subscriptions for a single report to vary the subscription options; for example, you can specify different parameter values to produce three versions of a report, such as a Western region sales report, Eastern region sales, and all sales.
When you first try to create an email subscription in your reporting server in SCCM 2012, you only have the Windows Share choice in the drop-down menu. Email is missing from the list.
The principal cause of this issue is that your SSRS is not configured properly to send emails.
- Log to your SSRS server
- Open Reporting Service Configuration Manager
- Click on the Email Settings tab
- Enter the settings of your sender address and SMTP server
- Click Apply
Once completed, go back in SCCM and create a new subscription. The “Email” option will now show in the drop down menu.
Founder of System Center Dudes. Based in Montreal, Canada, Senior Microsoft SCCM Consultant, 5 times Enterprise Mobility MVP. Working in the industry since 1999. His specialization is designing, deploying and configuring SCCM, mass deployment of Windows operating systems, Office 365 and Intunes deployments.