Query and displaying the results

[Polarman]

I have made a query which gives how many have a specific software installed.

However, I want to display the result on which machine has the software, what version and product. And maybe when it was installed.

 

How to build this query??

 

Knut

[GarthMJ]

Without having your first query it is impossible to answer this question.

[Polarman]

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

 

 

 

[GarthMJ]

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

[Polarman]

"Free hand"?? Well, it worked like a charm! Got versions up and name of software

 

Thanks Garth!