Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Monday, June 18, 2012 4:19 PM
I'm attempting to build a query rule for a collection that contain Microsoft Office Professional Plus 2010 from 32-bit add/remove programs (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName) and 64-bit add/remove programs (SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName). I built the following query below, but when I run it, no computers are added to the collection. About half of the computers have Microsoft Office Professional Plus 2010 installed, and the other half do not. 32-bit Windows XP/7 systems have 32-bit Office installed, and 64-bit Windows 7 systems have 64-bit Office installed. Any idea why my query is not returning any results?
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 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 "%Microsoft Office Professional Plus 2010%" or SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Microsoft Office Professional Plus 2010%"
All replies (6)
Monday, June 18, 2012 6:23 PM âś…Answered
You can use v_GS_installed_Software which has both x86 and x64. I'm using a third party add-in from BDNA that makes this much easier. http://www.bdna.com/page/index/bdna-normalize-cm
John Marcum | http://myitforum.com/cs2/blogs/jmarcum/|
Monday, June 18, 2012 5:44 PM
Your query works like, but I just could check x64 installations.
To you: Which is your "Limiting Collection". And more necessary, have you activated the "Hardware Inventory" in Client Settings? And how often does it run.
Monday, June 18, 2012 6:48 PM
Using the BDNA Software Data, you won't have to worry about the 32 and 64-bit table, everything is combined in a single class.
select SMS_R_System.ResourceId, 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_BDNA_BDNASOFTWAREDATA_1_1 on SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1.ResourceId = SMS_R_System.ResourceId where SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1.Publisher = "Microsoft" and SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1.SoftwareName = "Office" and SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1.Edition = "Professional Plus" and SMS_G_System_BDNA_BDNASOFTWAREDATA_1_1.MajorVersion = "2010"
You can try-it at http://sccm.bdna.com
Julien Moreau
Tuesday, June 19, 2012 1:22 PM
Your query works like, but I just could check x64 installations.
To you: Which is your "Limiting Collection". And more necessary, have you activated the "Hardware Inventory" in Client Settings? And how often does it run.
My limiting collection is "All Desktop and Server Clients". Hardware inventory runs daily at 12:00am.
Tuesday, June 19, 2012 1:30 PM
Whe you create the query manually, and then choose "Values", do you got a list of installes software? Like this:
If not, the Inventory Data is not reported to SCCM. If you find Software, but Office is not in the list, make sure, that hardware inventory on the clients is activated. If you find Office in the list, that would be strange...
/edit: thorsten is right, like i was in my first post.
Tuesday, June 19, 2012 1:49 PM | 1 vote
If you find Software, but Office is not in the list, make sure, that software inventory on the clients is activated. If you find Office in the list, that would be strange...
Add/remove programs data is reported using hardware inventory. The values list would be completely empty if HINV was not activated at all (given that there are no custom client agent settings deployed to a subset of computers).
Torsten Meringer | http://www.mssccmfaq.de