SCCM 2007 – All about Microsoft Endpoint Manager

SCCM report list collections with no deployments

Posted on December 5, 2022 by Eswar Koneti | 6 Comments | 2,919 Views

The following SQL query can be used to query the list of collections that doesn't have any deployments. you can review the number of collections with no deployments and you can further extend the query to exclude certain folders where you use these exception collections for troubleshooting or other purpose. select Col.Name, col.CollectionID, case when…

Tool for managing the import and export of SSRS report – ReportSync Tool

Posted on October 27, 2022 by Eswar Koneti | 4 Comments | 8,204 Views

Did you ever had difficulties importing, exporting or migrating the SSRS reports from one Configuration infra to other ConfigMgr infra? If so, how do you migrate reports ? When i work with my customers on the hardware migration of the SCCM and especially the SSRS reports, i always use the tool rather powershell scripts. To…

Troubleshooting Client that has NO SCCM Agent in Console BUT still receive deployments

Posted on August 31, 2018 by Eswar Koneti | 9 Comments | 29,725 Views

Introduction/Problem: Colleague mine has asked me , why is he getting applications /updates on his computer that he hasn't requested for. When i heard of this ,i verified in SCCM , based on the computer name provided and found ,the PC has no SCCM agent . If the PC has no SCCM agent ,there is…

How to deploy SCCM Remote Control Bits (standalone) to clients without ConfigMgr Console being installed

Posted on August 29, 2018 by Eswar Koneti | 1 Comment | 14,923 Views

Introduction/Problem: We are in process of completing office 365 project to all users which bring teams and other products as part of office 365. We are using Lync/Skype for business as collaboration tool prior to office 365 project but once the project started ,every one is on teams hence we can decom lync servers and…

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,694 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…

ConfigMgr How to use Compliance Settings to check the windows update policy settings like WUServer, UseWUServer,NoAutoUpdate on clients

Posted on October 30, 2017 by Eswar Koneti | 0 Comments | 12,481 Views

When you install configuration manager client to manage any windows device ,it will try to configure local group policy to set WSUS server settings (unless you have no GPO configured to set these settings) .If at all ,you have any GPO to configure the WSUS information ,local GPO that created by configmgr client will…

SCCM Configmgr How to Create collections based on OU that contains DEV UAT PROD etc

Posted on October 6, 2016 by Eswar Koneti | 3 Comments | 22,191 Views

Working on fine tuning collections to get the clients (DEV,UAT,PROD etc) from Active Directory based on OU for reporting purpose .Reporting can be either application deployment or software update compliance or anything that you want .In my case, all the OU’s in Active Directory are created based on BU( Business Unit) and business unit…

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,864 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…