/build/static/layout/Breadcrumb_cap_w.png

Report to show IE8 installed on just windows XP (Partial sql code inside)

I need a report to show all IE8 installed but only on Windows XP machines, which this report below gives the IE8 Installed part. Can anyone help in getting the part I need added?

select S.DISPLAY_NAME as SOFTWARE_NAME,
S.DISPLAY_VERSION as VERSION,
M.NAME as MACHINE_NAME,
M.USER_FULLNAME as LAST_USER
FROM SOFTWARE S
left join MACHINE_SOFTWARE_JT MSJ on S.ID = MSJ.SOFTWARE_ID
left join MACHINE M on MSJ.MACHINE_ID = M.ID
where S.DISPLAY_NAME like 'Windows Internet Explorer 8%'
and not IS_PATCH
order by S.DISPLAY_NAME, S.DISPLAY_VERSION, M.NAME

 


0 Comments   [ + ] Show comments

Answers (1)

Posted by: WhitzEnd 11 years ago
7th Degree Black Belt
2

Give this a shot.  This has been tested on a K1000 running version 5.4.

 

Select

  ORG1.SOFTWARE.DISPLAY_NAME As Software_Name,

  ORG1.SOFTWARE.DISPLAY_VERSION As Version,

  ORG1.MACHINE.NAME As Name,

  ORG1.MACHINE.OS_NAME As OS,

  ORG1.MACHINE.USER_NAME As Last_User

From

  ORG1.MACHINE Inner Join

  ORG1.MACHINE_SOFTWARE_JT On ORG1.MACHINE.ID =

    ORG1.MACHINE_SOFTWARE_JT.MACHINE_ID Inner Join

  ORG1.SOFTWARE On ORG1.SOFTWARE.ID = ORG1.MACHINE_SOFTWARE_JT.SOFTWARE_ID

Where

  ORG1.SOFTWARE.DISPLAY_NAME Like '%Windows Internet Explorer 8%' And

  ORG1.MACHINE.OS_NAME Like '%XP%'

Order By

  ORG1.SOFTWARE.DISPLAY_NAME, ORG1.SOFTWARE.DISPLAY_VERSION, ORG1.MACHINE.NAME


Comments:
  • I realized that my KBOX has ORGS enabled. So you may need to take the ORG1 off of the front of each field. - WhitzEnd 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ