Jump to content


Polarman

Query and displaying the results

Recommended Posts

select distinct SMS_G_System_SYSTEM.Name from SMS_R_System as Sys full join SMS_G_System_ADD_REMOVE_PROGRAMS as ARP on ARP.ResourceID = Sys.ResourceId full join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = Sys.ResourceId where ARP.DisplayName like "Sigmaplot %"

 

This is the query, giving the right result. However, I want the result displaying me more info than just the machines having this installed. I want the result to show name of software, version and if possible how many times it has been used. As shown in the picture attached I want more info inside the red line

 

 

 

post-24888-0-30533600-1427195783_thumb.jpg

Share this post


Link to post
Share on other sites

Try this.. Watch out for typos.. I write this free hand.

 

select distinct
SMS_G_System_SYSTEM.Name,
ARP.DisplayName,
ARP.Version

from
SMS_R_System as Sys
full join SMS_G_System_ADD_REMOVE_PROGRAMS as ARP on ARP.ResourceID = Sys.ResourceId
full join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = Sys.ResourceId
where
ARP.DisplayName like "Sigmaplot %"

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

Loading...


×
×
  • Create New...