Full Details http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 This collection is created using sub selected queries http://eskonr.com/2011/12/sccm-collection-sub-selected-quiries/ select SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID not in (select SMS_R_SYSTEM.ResourceID from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceId = SMS_R_System.ResourceId where (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%project reader%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%project reader%") and (SMS_G_System_ADD_REMOVE_PROGRAMS.Version > "4%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version > "4%"))
Author: Eswar Koneti
Project Description The tool is designed for IT Professionals to troubleshoot SCCM/CM12 Client related Issues. The Client Center for Configuration Manager provides a quick and easy overview of client settings, including running services and Agent settings in a good easy to use, user interface. This Tool is currently an alpha Version. For testing purposes only... ! Requirements Windows Remote Management (WinRM) must be enabled and configured on all target computers. (Run "winrm quickconfig" in a command prompt.) Microsoft .NET Framework 4 (on the computer running the Tool) Configuration Manager 2012 Agent on the target computer (some features will also work…
In System Center 2012 Configuration Manager, you can no longer deploy a secondary site server using Setup (wizard or scripted). Instead, you must use the Configuration Manager console to create a new secondary site. This is less than ideal if you want to deploy several secondary sites or want to automate the process for any other reason. This project provides a script that will allow you to install a new System Center 2012 Configuration Manager secondary site server without using the Configuration Manager console. The script essentially performs the same actions as the Configuration Manager console, writing changes to the…
Unlike SCCM 2007,lot of changes with respect to sccm 2012 hierarchy, additional features,roles and look wise. Log files are most Coveted for any kind of troubleshooting in sccm without which troubleshooting is Problematic and they are heart for troubleshooting. Several log files are added in sccm 2012 because of its new features and added roles. CAS.log : Content Access service. Maintains the local package cache on the client. Ccm32BitLauncher.log :Records actions for starting applications on the client marked as "run as 32bit". CcmEval.log : Records Configuration Manager client status evaluation activities and details for components that are required by the…
Today's post is going to listing down computers assigned to specific site with count and this will be linked to another report that gives you computer asset information. If you have referred my previous post on computer asset information http://eskonr.com/2011/12/sccmconfigmgr-report-for-computer-asset-information-serialnumber-manufacturermodelprocessorip-addresshardaware-scan/ OR http://eskonr.com/2009/12/sccm-report-for-computers-asset-information-including-sn-number-and-model-name/ ,then it would be easy for you make it. You need to create 2 reports 1)Count of Computers from AD site 2) list the computers assigned to specific Site Create new report from reports node for 2) list the computers assigned to specific Site using the below SQL query(quotes posted in this blog are converted to fancy,please replace…
While working SCCM 2012,we come across many words and sometimes we look for the terms what does it mean. Listed terms below should give you what each does so call it as SCCM 2012 Dictionary. Active Directory Delta Discovery A discovery option that allows Configuration Manager to discover only new or changed resources in Active Directory independently of a full discovery cycle. Active Directory Forest Discovery method A Configuration Manager discovery method that searches for Active Directory sites and subnets in Active Directory forests. Active Directory Group Discovery method A Configuration Manager discovery method that searches for the group memberships…
We already know that Configuration Manager no longer uses the reporting point; the reporting services point is the only site system role that Configuration Manager now uses for reporting. The reporting services point is a site system role that is installed on a server that is running Microsoft SQL Server Reporting Services. The reporting services point copies the Configuration Manager report definitions to Reporting Services, creates report folders based on report categories, and sets security policy on the report folders and reports based on the role-based permissions for Configuration Manager administrative users. Configuration Manager provides report definitions for over 400…
When you have a Configuration Manager hierarchy, install and configure the software update point at the central administration site first, and then install and configure the software update points on other sites. Some settings are only available when you configure the software update point on a central administration site, or stand-alone primary site, and there are different options that you must consider depending on where the software update point is installed. Use the steps in the following table to install and configure the software update point, synchronize software updates, and configure the settings associated with software updates. I am running…