Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 select sys.name0,sys.AD_Site_Name0,FCM.SiteCode,ARP.DisplayName0,ARP.Version0,ARP.InstallDate0 from V_R_system sys inner join v_Add_Remove_Programs ARP on arp.resourceID=sys.ResourceID inner join v_FullCollectionMembership FCM on FCM.ResourceID=sys.ResourceID and arp.DisplayName0 like '%project reader%' and ARP.Version0 < '4%' For collection ,follow the post here on http://eskonr.com/2012/05/sccm-collection-computers-with-lower-version-application/

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…

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…

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…

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…

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/…

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…

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…

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…

Have been using nice SCCM 2007 right click tools by Rick Houchins available from http://myitforum.com/cs2/blogs/rhouchins/archive/2008/04/09/sccm-right-click-tools.aspx that will help troubleshooting sccm clients and make them healthy with minimal steps… and now Configuration manager 2012 is out so we need SCCM 2012…