Jump to content


  • 0
sixtec

Query Project 32/64 bits

Question

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

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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%"

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.