SQL code – Page 3 – All about Microsoft Endpoint Manager

SCCM report User member of What collections For Application Deployment

Posted on September 18, 2012 by Eswar Koneti | 1 Comment | 4,114 Views

If you in environment where in the deployment of Application is User Based and you are sometimes getting issues if User doesn’t get apps so you will have to check if User member of AD Security groups and then check if user added to right collection with right advertisement. Here is Simple report that give…

SCCM Configmgr Report find Computers for the list of selected users

Posted on August 31, 2012 by Eswar Koneti | 1 Comment | 7,123 Views

You have Username but unsure what is their computer name where they logged into to track it(this all happens if and only if sccm client is healthy else you see old information). This report gives you all the machines name with your supplied user names if you have bulk users to know all . Create…

SCCM report Count packages with no advertisements

Posted on August 23, 2012 by Eswar Koneti | 4 Comments | 2,523 Views

This blog post will help you to identify packages (count) for which there is no advertisement created and not used these packages in any task sequence.Once you have the packages ,you can further take action whether you really need these packages to exist in SCCM or cleanup to save disk space and avoid unused packages…

SCCM report all applications with dependency programs

Posted on July 11, 2012 by Eswar Koneti | 3 Comments | 7,125 Views

I had requirement to check for some specific packages if their programs are used in any other packages or not . Take an example that ,Microsoft visual C++ is prereq for multiple applications and to know what packages used this specific VC++ ,it will be hard to find all parent packages using VC++ as…

SCCM report Computer information with Boundary added

Posted on July 10, 2012 by Eswar Koneti | 2 Comments | 4,297 Views

Full Details : http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/188bb324-9217-4fa6-b814-06a3d353bf52 Boundary information (AD Site) added . select distinct v_GS_SYSTEM.Name0 as 'Computer Name',A.AD_Site_Name0, substring(AccountName0,charindex('Domain=',Accountname0)+8,(charindex('Name=',Accountname0)-charindex('Domain=',Accountname0)-10)) as 'Domain Name', substring(AccountName0,len(AccountName0)-charindex('"',reverse(AccountName0),2)+2,charindex('"',reverse(AccountName0),2)-2) as 'User Name' from v_GS_SYSTEM INNER JOIN v_GS_LocalAdmins ON v_GS_SYSTEM.ResourceID = v_GS_LocalAdmins.ResourceID INNER JOIN v_R_System A ON v_GS_SYSTEM.ResourceID=A.ResourceID JOIN v_FullCollectionMembership FCM on v_gs_system.ResourceID = FCM.ResourceID where (AccountName0 not like '%Administrator%' AND AccountName0 not like…

SCCM report for Site System status and Hierarchy Design

Posted on July 10, 2012 by Eswar Koneti | 0 Comments | 179 Views

Did you ever find difficulty in identifying the site system information when you have multi-tier hierarchy like central,multiple primary sites and each primary has primary and secondary sites. It is difficult to identify and check for site settings (like discovery,Site maintenance Tasks etc.) OR Site Component Information until you know all site verywell . To…