Posted by Eswar Koneti on 24th May 2012
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/
Tags: add and remove programs MS office, add and remove programs with lower version, CM 12, cm 2012, Config mgr 2012, configuration Manager, lower version reports, SCCM, SCCM 2012, sccm collection, sccm report, WQL code
Posted in SCCM Reports, SQL Quiries | No Comments »
Posted by Eswar Koneti on 24th May 2012
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%"))
Tags: add and remove programs MS office, add and remove programs with lower version, CM 12, cm 2012, Config mgr 2012, configuration Manager, lower version collection, SCCM, SCCM 2012, sccm collection, WQL code
Posted in SCCM Reports, WQL Quiries | No Comments »
Posted by Eswar Koneti on 11th February 2010
In my last post http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ showed how to create sccm report to list computers with different versions of application installed on computers. This is to list the computers in collection rather report.
Create a collection and edit the query ,paste the following into it.
select * 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.DisplayName like “%Office1%” or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%Office2%”
Please replace the bold letters with the correct application name displayed from add and remove programs.
Tags: add and remove programs MS office, collection with MS Office application, Configmgr 2007, configmgr report, configMgr reports, MS office, MS office installed computers in collection, SCCM, SCCM 2007, sccm 2007 report, sccm collection, SCCM Reports, WQL Quiries
Posted in Collections, SCCM Reports, WQL Quiries | No Comments »
