Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Link to Name

For full details see post here. https://myitforum.com/forums/tm.aspx?high=&m=234875&mpage=1#234894

 

select 
  ARP.resourceid, 
  CS.Name0,
  max(ARP.version0)as JavaVersion 
from 
  dbo.v_GS_COMPUTER_SYSTEM as CS
  join dbo.v_ADD_REMOVE_PROGRAMS as ARP on CS.ResourceID = ARP.ResourceID
 
where 
  ARP.DisplayName0 like 'Java(TM) 6 Update%' 
group by 
  ARP.resourceid, 
  CS.Name0


Share This Post

Leave a Reply