Thursday, October 14, 2010

Query to find all machines with Internet Explorer 7 version

select distinct(c.FileDescription +' '+left(c.fileversion,3)) as 'Internet Explorer Version',c.Fileversion as 'IE version number',
a.Name0 as 'Host Name',a.User_name0 as 'User Name',b.Caption0 + ' ' + b.CSDVersion0 as 'Operating System Version'
from v_r_system a inner join v_gs_Operating_system b on a.resourceid=b.resourceid
inner join v_GS_SoftwareFile c on a.resourceid=c.resourceid
where c.FileName = 'iexplore.exe' AND c.FilePath like '%prog%internet%' and c.Fileversion like '7.%' and (a.client0=1 and a.Obsolete0=0 and a.Active0=1)
Group By c.FileDescription +' '+left(c.fileversion,3),c.Fileversion,a.Name0,a.User_name0,b.Caption0 + ' ' + b.CSDVersion0
ORDER BY c.FileDescription +' '+left(c.fileversion,3)


Blogger Rick said...

Nice One.. It Works...........

February 8, 2011 at 10:15 PM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home