SCCM Upload RDL File to Report Server

Nicolas PilonSCCM, SSRS62 Comments

There are many ways to upload RDL file to the report server (SSRS). This post will show how to upload an Rdl file to an SCCM Reporting Point 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 … Read More

Install SCCM 2012 Reporting Services Point

Benoit LecoursSCCM, SQL, SSRS22 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

SCCM Reporting Point Error after R2 Upgrade

Benoit LecoursSCCM, SSRS1 Comment

This post explains how to fix SCCM Reporting Point Error after R2 Upgrade. SCCM 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 … Read More

SCCM report subscription ssrs does not list Email in Drop Down Menu

Benoit LecoursSCCM, SQL, SSRS6 Comments

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 … Read More

sccm query imported computer

Benoit LecoursSCCM, SQL, SSRSLeave a Comment

This sccm query imported computer might be helpful to know which user imported a specific computer. You add a new computer directly to the SCCM database by calling the ImportMachineEntry Method in Class SMS_Site. This can be used to deploy operating systems to computers that have not yet been discovered automatically by SCCM. 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. This query won’t work to create a collection since it’s … Read More