/build/static/layout/Breadcrumb_cap_w.png
I am trying to create a report that shows the newest version of .NET framework installed on all devices.

Does anyone have experience with that?
0 Comments   [ + ] Show comments

Comments


All Answers

2
Quick-and-dirty report (might not report latest in every single case):
SELECT   M.ID, M.NAME, MAX(S.DISPLAY_NAME) AS SOFTWARE_NAME, S.DISPLAY_VERSION AS SOFTWARE_VERSION
FROM     MACHINE M
         JOIN MACHINE_SOFTWARE_JT JT ON M.ID = JT.MACHINE_ID
         JOIN SOFTWARE S ON S.ID = JT.SOFTWARE_ID
WHERE    S.DISPLAY_NAME LIKE 'Microsoft .NET Framework%'
GROUP BY M.ID

This will give you all versions for each computer (so there are sometimes multiple lines for one computer):
SELECT   M.ID, M.NAME, S.DISPLAY_NAME AS SOFTWARE_NAME, S.DISPLAY_VERSION AS SOFTWARE_VERSION
FROM     MACHINE M
         JOIN MACHINE_SOFTWARE_JT JT ON M.ID = JT.MACHINE_ID
         JOIN SOFTWARE S ON S.ID = JT.SOFTWARE_ID
WHERE    S.DISPLAY_NAME LIKE 'Microsoft .NET Framework%'
ORDER BY M.ID
Answered 04/04/2018 by: JasonEgg
Red Belt