Tech How To Information. Configuring Email Notification for Configuration Manager Reports. This blog is a step by step example for the configuration of email notification for Configuration Manager Reports and well as for deleting the email subscriptions. We will also cover a bit of background changes like in database SSRS Config file when things are implemented. IntroductionEmail notification of Reports, as the name suggests, is used to create a notification for any report we need to get on specific time or on repeated intervals. You can get a report link over an email or you can get report itself mailed to you. You can use a local SMTP service or a remote SMTP server or forwarder to support e mail delivery. If you have access to an existing remote SMTP server, you should consider using it. Configuration Manager Software Metering Report' title='Configuration Manager Software Metering Report' />System Center Configuration Manager SCCM ist ein SoftwareProdukt aus der System Center 2012 Suite von Microsoft. Es lst frhere Versionen mit dem Namen Systems. ConfigMgr SQL queries for helping the IT Pro report on KBs related to MS17010. Review a list of reports that are supplied with Configuration Manager. The reports appear in various categories. Hi. I have installed SCCM 2012. While viewing a report for software metering date and year are not available for selection. TCP Ports TCP 0 Reserved TCP 1 Port Service Multiplexer TCP 2 Management Utility TCP 3 Compression Process TCP 4 Unassigned TCP 5 Remote Job Entry TCP 6. Technology keeps you connected everywhere you go, helps you capture every moment makes your life a bit easier stay uptodate with tips tricks from eHow. Register for Exam 70243 and view official preparation materials to get handson experience with System Center 2012 Configuration Manager. Configuration Manager Software Metering Report' title='Configuration Manager Software Metering Report' />Steps to create email subscription. Browse to MonitoringOverviewReportingReports on SCCM console. Select any report for which you want to create email subscription and click on the Create Subscription at the top on console as shown below When Create Subscription Wizard is open, Report delivered by will have only one option, Windows File Share. You will not see any option for creating Email Notification. To get Email option, we need to configure SSRS SQL Server Reporting Services first. Open Reporting Services Configuration Manager console and go to E mail Settings. Configure Sender Address and SMTP Server details, click on Apply and I will be configured as shown below When the E mail Settings are applied, this information will be written into rsreportserver. Installation Drive Program. FilesMicrosoft SQL ServerMSRS1. MSSQSERVERReporting ServicesReport. Server Value of MSRS1. MSSQSERVER will vary as per the version of SQL Server, for example MSRS1. MSSQSERVER If we open this file rsreportserver. SMTP Server, we will find the updated information here, as shown below NOTE Please do not open this file because if you make any irrelevant change by mistake in this file, you will end up messing your SSRS SQL Server Reporting Services. The only reason to include screenshot is just to share the information for troubleshooting scenarios for example you configured the e mail settings in SSRS but its not getting reflected or fails to Apply, etc. Go back to SCCM console and try to create the Subscription again. Now you will get an option for creating email subscription Select Email and it will appear like below Now configure the required fields as shown below, also select whether you need just the Report Link, Reports itself or both as well as the Report Format Click Next and specify the scheduled as required. Select the parameter value for which you need the Report. Check the Summary and proceed further. Complete the Setup and its done. If you enable the Verbose logging for SCCM Console, you see the below information in logs. I have copied only few lines and highlighted the important once. You can see the following highlighted information Report Name. Available delivery extension. Comic Stars Fighting 4 Hacked Arcadeprehacks. Parameters you selected for Report. Do. Work and Run. Worker. Complete steps. SMSAdmin. UI. log. XML loaded from C Program Files x. Microsoft Configuration ManagerAdmin. ConsoleXml. StorageFormscreatereportsubscriptionwizard. PRI1. contoso. local Retrieving report parameters for Config. Ware Software Winzip. MgrPRIAdministrative SecurityAdministration activity log. PRI1. Found delivery extension Report Server File. Share. PRI1. contoso. Found delivery extension Report Server Email. Parameter. Presenter Retreiving parameters for report Administration activity log. Parameter. Presenter Loading parameters for report Config. MgrPRIAdministrative SecurityAdministration activity log. PRI1. Retrieving report parameters for Config. MgrPRIAdministrative SecurityAdministration activity log. Parameter. Control admin Initializing default values. Parameter. Control admin Adding parameter value lt All values to the list of values. Parameter. Control type Initializing default values. Parameter. Control type Adding parameter value 0 to the list of values. Parameter. Control Date. Range Initializing default values. Worker. Post. ApplyDo. Workbackground. Worker. Post. ApplyRun. Worker. Completed. This new Subscription info will be inserted in Report Server Database with a unique Subscription. ID You can verify the same by running the query Select from Subscriptions in Report Server Database as shown below Browse to MonitoringOverviewReportingSubscriptions to check the Subscription you created. You can also make any changes to the subscription you created by going into the properties of the same. Now you can receive Configuration Manager Reports on emails as scheduled automatically. Steps to remove email subscription. The purpose of additionally including this step is simply to save you from console crash issue. It appears very simple to delete the subscriptions and it is, but it must be done in correct order as specified below. Delete the subscriptions from SCCM Console 2. Delete the Email Settings from SSRSReason If you will delete the Email Settings from SSRS first, then every time when you will click on Subscription at Configuration Manager Console, it will crash. Then you must either reconfigure the Email Settings in SSRS or you must manually delete all the existing Subscriptions from Report Server Database to resolve the Configuration Manager Console crash issue. So, its better to follow the correct steps. Hope this helpful to you. Happy Learning Additional Information. Configure a Report Server for E Mail Delivery SSRS Configuration Manager https msdn. Rafid Ali, Support Engineer, Microsoft Enterprise Cloud Group.