_ap_ufes{"success":true,"siteUrl":"eskonr.com","urls":{"Home":"http://eskonr.com","Category":"http://eskonr.com/category/net-framework-4-0/","Archive":"http://eskonr.com/2014/12/","Post":"http://eskonr.com/2014/12/configmgr-2012-query-how-to-get-list-of-applications-that-requires-approval/","Page":"http://eskonr.com/orchestrator-scorch-guides/","Wpcf7_contact_form":"http://eskonr.com/?post_type=wpcf7_contact_form&p=1610","Wpdmpro":"http://eskonr.com/download/hypervhostinformation/","Safecss":"http://eskonr.com/?safecss=safecss"}}_ap_ufee ESwar KONeti

ESwar KONeti

All about Configmgr and its Connected Objects….

  • About Author
      View eswar koneti's LinkedIn profile
  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 260 other subscribers

  • Archives

  • Meta

  • #Configmgr Tweets

  • Copyright!

    All the blog posts in this website are owned by Eswar Koneti and may not be reused in any mode without prior approval of Eswar Koneti. You may quote one paragraph from the blog posts if you link to the original blog post.
    Happy Reading!

  • Like us on FaceBook

  • Awards


Configmgr 2012 query how to get list of applications that requires approval

Eswar Koneti / December 18th, 2014

This is quick post on how to get list of Applications that are deployed to users requires approval . more Details ,refer https://social.technet.microsoft.com/Forums/en-US/644ff540-4eb0-49b6-97f4-094cada74c6a/viewing-deployments-that-require-approval?forum=configmanagerapps Run the following SQL query to know apps that require Approval. select app.displayname [Application Name],app.manufacturer [Manufacturer],app.numberofdeviceswithapp [No of Devices with this App],app.numberofuserswithrequest [No of Requests] from fn_ListApplicationCIs(1033) app, v_UserTargetedApps uta where uta.ci_id=app.ci_id…… Read Full Article »

SCCM Configmgr 2012 How to get list of VMs running on each Hyper-V server in your environment?

Eswar Koneti / December 1st, 2014

I got a request asking for “is there a way to find out the VM’s that are configured on each Hyper-V server ,if so ,how to I generate a report with its Base/Host Name and its VMS running on it with its possible VM setting info “. hmm..Getting VM’s that are running on Hyper-V and…… Read Full Article »

SCCM Configmgr How to Import Export Migrate upload reports to CM12 easy way using ReportSync Tool

Eswar Koneti / November 27th, 2014

Did you ever had difficulties importing, exporting or migrating the reports from Configuration manager 2007  (SSRS ) to Configuration manager 2012 ? If so,how do you migrate reports to Configmgr 2012 ? To get the SSRS Reports from Configmgr 2007 to Configmgr 2012,you will have to download each report (.RDL) manually and upload it your…… Read Full Article »

SCCM Configmgr 2012 SSRS Report Overall Compliance Per Update Group Per Collection will help to troubleshoot the clients

Eswar Koneti / November 26th, 2014

Over the past few weeks,I posted several patch Compliance reports because ,the default report do not meet the requirements what I need thus ,created custom reports that would help the team to analyze the patch Statistics and troubleshooting non compliant machines. Software update compliance report month Wise: http://eskonr.com/2013/11/sccm-configmgr-2012-patch-compliance-summary-report-month-wise/ Software update Compliance report month Wise for…… Read Full Article »

SCCM Configmgr 2012 Software Update Scan failed OnSearchComplete – Failed to end search job. Error = 0xc8000222

Eswar Koneti / November 17th, 2014

Trying to run the patch compliance report based on OU per Software update Group (For October 2014) ,report is available to download from http://eskonr.com/2014/11/sccm-configmgr-2012-patch-report-ou-based-compliance-status-per-update-group/ . Report shows some good success rate but still there are computers with unknown status .Unknown status means,these clients do not report anything to CM DB whether they required patches or…… Read Full Article »

SCCM Configmgr 2012 Patch Report – OU based Compliance status per Update Group

Eswar Koneti / November 4th, 2014

Question asked in the forum ,if it is possible to get patch compliance /deployment status report (installed,required,not applicable and unknown) based on OU for specific software update group instead of collection. Long ago,I posted patch compliance report for specific collection month wise http://eskonr.com/2014/09/configmgr-2012-summary-of-patch-compliance-status-report-month-wise-for-specific-collection-ssrs-report/ but it gives you overall compliance for each month for past 12…… Read Full Article »

SCCM Configmgr 2012 Report Get the Status of Software Update Scan results

Eswar Koneti / October 31st, 2014

In this blog post,I will show you ,how to know /monitor the clients with software update scan status results . For patch management,all Configmgr Managed clients should do successful software update scan else,client will not be able to get updates from SCCM and thus ,SUP compliance go down the SLA. I looked at the default…… Read Full Article »

SCCM Configmgr 2012 How to Create Collection to get list of computers from Users OU using UDA

Eswar Koneti / October 30th, 2014

I had a requirement to deploy patches (part of patch testing) to Department (group of user around 200+) who resides in one OU in Active Directory .The computers used by them are different due to their work nature and they keep moving with different computers (with different apps). I need to get list of computers…… Read Full Article »

SCCM Configmgr 2012 Software Update Scan error Group policy settings were overwritten by a higher authority Error Code 0x87d00692

Eswar Koneti / October 27th, 2014

Started working with New Customer since few weeks ago ,running Configmgr 2012 R2 CU1 ,yet to upgrade to Latest CU . since few days,I have been running lot of SQL Queries ,reports checking the SCCM client health and analyzing the existing setup for some improvements. For everything what ever you do in SCCM,the first and…… Read Full Article »

How to Install and upgrade clients to Configmgr 2012 R2 Cumulative Update 3 (CU3)

Eswar Koneti / September 24th, 2014

In this post, i will discuss about how to install CU3 update and  How to Upgrade clients to CU3 with query based collections. Installation of CU3 is not so difficult ,it is straight forward .If you need step by step with screenshots ,you can refer my previous post http://eskonr.com/2014/03/how-to-install-configmgr-2012-r2-cu1-part-1/  So,as i discussed in my previous…… Read Full Article »