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
Answers (1)
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 12 years ago
