Query Project 32/64 bits

[sixtec]

I want to do in one query with computers that have Microsoft Project 32 bits and 64 bits using the following results:

• Class: System Resource - attribute: Name
  
• Class: Add/remove programs - attribute : Display Name
  
• Class: Add/remove programs (64) - attribute : Display Name
  

 

it is possible?

 

 

thanks

[Peter33]

Rather use the class SMS_InstalledSoftware. They are the same on both systems, and you don't have to query two classes.

[Eswar Koneti]

Yes it is possible.you can do OR operation with 32 bit and 64 bit something like below: change the bold letters (untested 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 "%Adobe Acrobat%" OR

select SMS_R_System.ResourceID from SMS_R_System 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_64.

DisplayName like "%Adobat%"

[sixtec]

I had to change the option from Asset Intelligence SMS_InstalledSoftware.

 

Once activated launch a full inventory of all computers and I can create querys with this option.

 

Thank you Peter33 very much has been of great help.

[sixtec]

Your query does not work, Eswar Koneti