/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

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