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

Comments

Please log in to comment

Answers

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

Answered 11/30/2012 by: WhitzEnd
Seventh Degree Black Belt

  • I realized that my KBOX has ORGS enabled. So you may need to take the ORG1 off of the front of each field.
Please log in to comment
Answer this question or Comment on this question for clarity

Share