Jump to content

Search the Community

Showing results for tags 'SSRS'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Cloud
    • Azure
    • Microsoft Intune
    • Office 365
  • General Stuff
    • General Chat
    • Events
    • Site News
    • Windows News
    • Suggestion box
    • Jobs
  • MDT, SMS, SCCM, Current Branch &Technical Preview
    • How do I ?
    • Microsoft Deployment Toolkit (MDT)
    • Official Forum Supporters
    • SMS 2003
    • Configuration Manager 2007
    • Configuration Manager 2012
    • System Center Configuration Manager (Current Branch)
    • Packaging
    • scripting
    • Endpoint Protection
  • Windows Client
    • how do I ?
    • Windows 10
    • Windows 8
    • Windows 7
    • Windows Vista
    • Windows XP
    • windows screenshots
  • Windows Server
    • Active Directory
    • Microsoft SQL Server
    • System Center Operations Manager
    • KMS
    • Windows Deployment Services
    • NAP
    • Failover Clustering
    • PKI
    • Windows Server 2008
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Hyper V
    • Exchange
    • IIS/apache/web server
    • System Center Data Protection Manager
    • System Center Service Manager
    • System Center App Controller
    • System Center Virtual Machine Manager
    • System Center Orchestrator
    • Lync
    • Application Virtualization
    • Sharepoint
    • WSUS

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 11 results

  1. Just wondering if anyone has any ideas how to automate a software metering report for all future months, currently setup as an SSRS subscription. example, new rule created for Visio, if you run the built in software metering reports, you have to select the values, so software metering rule name (easy part), year (easy part too) then the month is required, now if I want future months, I have to edit the SSRS subscription parameters every month as that data/value isn’t available until a user/computer invokes that application. Invoke-cmreport cmdlet would launch the report but c
  2. I upgraded my SCCM 1511 infa to SCCM 1610 and reporting node stopped working for non admin users. Run as admin with same user ID works properly as before.Also accessing SCCM console from other terminal servers as a domain user works perfectly. Please help! Below is the log entries for SMSAdminUI.log [6, PID:9468][06/13/2017 09:09:19] :[XYZ.com] : System.Web.Services.Protocols.SoapException: The permissions granted to user 'ABC\abc' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted t
  3. Hi All. Long time lurker here but now is the first time I have been moved to create an account and ask for some advice. I’m looking for a bit of direction on how to proceed as I’m a bit stuck, I’d like to fix this without breaking anything else in SCCM. I’m running SCCM build 1606 – Last week we upgraded the SQL instance hosting all out SCCM databases from SQL 2008 SP3 to SQL 2014 (this because we plan to upgrade to SCCM 1702). The SQL upgrade wizard reported that it upgraded all components successfully to SQL 2014 but when I opened the SCCM console all the reports are missi
  4. I have a working SQL query courtesy of Eswar Koneti (https://gallery.technet.microsoft.com/office/SCCM-Configmgr-2012-SSRS-c482cca2/). Due to being new to SQL/SSRS custom report building, I am struggling with trying to limit the scope of these results to a specific collection. What I would like to do is add a statement in the query to limit the results to a specific collection ID(s). I am not looking to make a drop down of collections in the report. Here is what I have so far: SELECT COUNT (Total.Name0) AS 'Total Clients', COUNT (office2003.Name0) AS 'Office 2003', COUNT (Office2007.Name0)
  5. Hi Everyone, I wanted to let you know that this month's free report giveaway is Patch Compliance Progression by Collection For each PC within a collection, the Patch Compliance Progression by Collection report will provide you with a count of missing software updates (patches) and the last hardware inventory date. The deployed state report parameter allows you to select the deployed state of the software update. The deployed states are: Yes – The effected software update is deployed within your environment No – The effected software update is NOT deployed within your environment Both
  6. I am happy to announce that you can now pre-order my new book entitled, System Center Configuration Manager Reporting Unleashed. What I love about this book is that there are so many demonstrations. These demonstrations help reinforce the topics discussed within the chapters. Reporting Unleashed will show you from start to finish how to create a ConfigMgr report. Best practices for report design and creating report templates are noted, and all of the listings, code snippets and RDLs can be found within the online content. There is even a section on how to create Role-Based Admin
  7. Hello, I have been creating custom reports in SCCM using SSRS for a few months now. Just today, I was trying to back up all the reports and I can't find the custom reports folder under my **/Program Files/SMS_SRSRP/Reports folder. Are they saved under a different location? Thanks in advance!!! Sana
  8. Hi, I'm fairly new to SSRS . I'm trying to create a custom report which should give me a list of users for a specific application deployment(User based collection). Any help is greatly appreciated. Thanks much!! Sana
  9. Install SQL Server At this point, since we will be installing SQL Server on the same server that we will be installing our System Center product, it is expected that you have the VM created, the OS is installed, the appropriate networking has been configured, and it is joined to your lab domain. To avoid a specific installation error (see the end of the Install SQL Server section), you have to install the .NET Framework 3.5. So we’re going to complete this first before we start the installation of SQL. .NET Framework Installation To install the specific version of .NET that we requir
  10. I am trying to set up reporting on SCCM 2012 Sp1, mostly following this guide: http://www.windows-noob.com/forums/index.php?/topic/4550-using-sccm-2012-rc-in-a-lab-part-11-adding-the-reporting-services-point-role/. I had originally set up my CM Database on the same server as SCOM. --------------------------- Configuration Manager --------------------------- At least one report category must exist before a report can be created. Create a report folder, then try again. --------------------------- OK --------------------------- I saw this thread: http://social.technet.microsoft.com/Fo
  11. Hi everyone Did you know that Enhansoft is giving way a free SCCM SSRS report each month? Check out the site, this month’s report is Package Home Page. http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx BTW when you are on the site don’t forget to vote to next month’s give-away.
  • Create New...