Jump to content


Add 32/64 bit Column to Query?

Recommended Posts

Hello all,

I have a query to show me what computers do not have a certain software installed. It returns the computer name and the last logged in user. I would like to add if the machine is 32 or 64 bit. The reason why is because I want to sort by 32/64 bit so I can easily select all the 32 bit machines for example and throw them into the proper collection to get the software.


Here is the query I have...

select SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName from SMS_R_System where SMS_R_System.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 where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Traps") and SMS_R_System.ResourceId not in (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 = "Traps") order by SMS_R_System.NetbiosName


Again, I just want to add a column that shows if the computer is 32 or 64 bit.




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.

Reply to this topic...

×   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.


  • Create New...