SCCM Upload RDL File to Report Server

Nicolas PilonSCCM, SSRS63 Comments

There are many way to upload RDL file to report server (SSRS). This post will show how to do it with the web portal. A RDL file is an XML application and a standard proposed by Microsoft for defining reports. SCCM Upload Rdl file Requirements SSRS installed and all running components.  You can refer to install SCCM 2012 Reporting Services Point post. A healthy RDL file. A user account with enough access to upload a report. Please read predefined roles on MSDN for more detailed information. Upload the file We suggest uploading your file into a Test folder before releasing the report in production. The … Read More

Install SCCM 2012 Reporting Services Point

Benoit LecoursSCCM, SQL, SSRS21 Comments

In this part of SCCM 2012 and SCCM 1511 blog series, we will describe how to install a SCCM 2012 or SCCM 1511 reporting services point. This role can be installed on a remote machine, the process is the same but the logs location is different. Requirements Before you can install the reporting services point role you must configure SQL correctly. We’ll be using SQL 2012 on this post. We are assuming that SQL is already installed and that your SCCM site is up and healthy. During the initial SQL installation, you must select Reporting Services. If you have installed SQL … Read More

Reporting Point Error after R2 Upgrade

Benoit LecoursSCCM, SSRSLeave a Comment

This post explain how to fix Reporting Point Error after R2 Upgrade. Problem : After upgrading from SCCM 2012 SP1 CU2 to SCCM 2012 R2. You get the following error when running reports : An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow) Conversion failed when converting the nvarchar value ‘S-1-5-21-1010946700-728571707-39459515-134623’ to data type int. Removing and adding the “Reporting Service Role” did not fix the issue. SRSRP.log has Invalid Class errors : Invalid class SMS_SRS_REPORTING_POINT 07/7/2014 1:52:12 PM 6096 (0x17D0) Could not retrieve the reporting service name for instance ‘RPSERVER’ … Read More

Report Subscription in SSRS does not list Email in Drop Down Menu

Benoit LecoursSCCM, SQL, SSRS6 Comments

What can you do when your report subscription in SSRS does not list email in drop down menu? Symptoms When you first try to create an email subscription in SCCM 2012, you only have the Windows Share choice in the drop down menu. Email is missing from the list. Cause The principal cause of this issue is that your SSRS is not configured properly to send emails. Resolution 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 Verification Once completed, go back in SCCM … Read More

SCCM Query to identify who imported OSD Computers

Benoit LecoursSCCM, SQL, SSRSLeave a Comment

This query might be helpful to know who imported a specific computer. You can view this information in the Status Message Queries and search for MessageID #30213. But this query will target only the information you need. You can use this query to create a report or directly in SQL MS. select CASE smsgs.Severity WHEN -1073741824 THEN ‘Error’ WHEN 1073741824 THEN ‘Informational’ WHEN -2147483648 THEN ‘Warning’ ELSE ‘Unknown’ END As ‘SeverityName’, smsgs.MessageID, smsgs.Time, smwis.InsString1 as Username, smwis.InsString4 as ComputerName, smwis.InsString5 as MAC from v_StatusMessage smsgs join v_StatMsgWithInsStrings smwis on smsgs.RecordID = smwis.RecordID join v_StatMsgModuleNames modNames on smsgs.ModuleName = modNames.ModuleName where smsgs.MessageID … Read More

SSRS : SMS_SRS_Reporting_Point Failing with Error Message 7405

Nicolas PilonSCCM, SSRS5 Comments

I was configuring the reporting services on a dedicated server when I received a SMS_SRS_Reporting_Point failing with 7405 on the component status failure message. The error logs from reporting services is : ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/ConfigMgr_CAS’ cannot be found.; Cause: The datasource was not in the good directory. Resolution: Move the datasource on the SSRS website to the same place of the component configuration in SCCM 2012. SMS_SRS_Reporting_Point failing with 7405   Nicolas PilonFounder of System Center Dudes. Nick has been awarded in 2016 as a Microsoft MVP in Enterprise Mobility category. Working as a senior SCCM and Intune advisor as … Read More