SSRS – Page 2 – All about Microsoft Endpoint Manager

Configmgr report for count of MS office versions with architecture type 32bit and 64bit

Posted on November 2, 2017 by Eswar Koneti | 17 Comments | 17,144 Views

This blog post is going to be version 3 on the same topic (report for MS office versions) but with different requirements.My previous posts on ssrs report for count of MS office versions and drilled report to see client names etc will have some limitations like they will not give you bit type(architecture) like 32bit…

SCCM Configmgr Software Update Compliance Report for Specific Collection within Specific Time Frame

Posted on July 20, 2017 by Eswar Koneti | 30 Comments | 15,795 Views

In this post, i will discuss about the requirement that i have got recently. Local team /manager wants to run the software update compliance report for their LBU machines (collections) to see if all the clients in collection are compliant or not for all the patches with released date between X date to Y date.…

SCCM Configmgr Get count of software updates with its severity (Critical,Important,Moderate and Low)

Posted on July 18, 2017 by Eswar Koneti | 6 Comments | 5,316 Views

Quick post on how to get count of list of updates or count of updates in your Configuration Manager with severity categorised as Critical,Important,Moderate and Low. In order to get this information count of updates with severity, you first need to identify what the SQL views that store this information about software updates. Get the…

SCCM Configmgr Unable to run SSRS reports due to HTTP 500 Internal Server Error

Posted on July 14, 2017 by Eswar Koneti | 0 Comments | 8,849 Views

Setting up Configuration Manager current branch (1702) lab for testing. While running the Configmgr reports using IE browser ,http://servername/Reports/Pages/Folder.aspx ,it failed with error code HTTP 500 Internal Server Error. SQL server installed locally on Configmgr box . I have seen this error couple of time but i don't remember what was the solution to get…

SCCM SSRS The report parameter has a default value or valid value that depends on the report parameter UserSIDs.Forward dependencies are not valid

Posted on May 4, 2017 by Eswar Koneti | 8 Comments | 12,077 Views

Other day,I was trying to create my first SCCM Configmgr SSRS report with RBA (role based administration) what it means is ,data for all reports included with Configuration Manager is filtered based on the permissions of the administrative user who runs the report. Administrative users with specific roles can only view information defined for…

SCCM Configmgr How to get clients maintenance window with custom dates (Past and Future )

Posted on January 24, 2017 by Eswar Koneti | 6 Comments | 5,593 Views

Introduction: Maintenance windows in Configmgr help to ensure that client configuration changes occur during periods that do not affect the productivity of the organization. Following Operations can be performed during the Maintenance window: Software update deployments Compliance settings deployment and evaluation Operating system deployments Task sequence deployments More about MW https://technet.microsoft.com/en-us/library/hh508762.aspx?f=255&MSPPError=-2147217396 Problem: So ,If you…

SCCM Configmgr how to find applications with no deployments as part of maintenance tasks

Posted on December 21, 2016 by Eswar Koneti | 10 Comments | 7,133 Views

Introduction: One of my blog reader asked question about ‘There is report in your blog to find out packages that has no advertisements created,but is there similar report to find applications with no deployments created’. I found this question is valid and is needed if you want to perform maintenance tasks like cleanup packages,applications,collections…

SCCM Configmgr Report for Count of MS Office Versions updated with list of clients

Posted on September 7, 2016 by Eswar Koneti | 37 Comments | 13,541 Views

Update: I have another post that shows the count of ms office version with architecture type 32 or 64 for specific collection on http://eskonr.com/2017/11/configmgr-report-for-count-of-ms-office-versions-with-architecture-type-32bit-and-64bit/ I wrote a blog post year ago on how to get count of MS Office Editions with versions installed across my environment using SCCM Configmgr. This report consists of 2 reports .1st…