/build/static/layout/Breadcrumb_cap_w.png
03/13/2018 505 views
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

Don't be a Stranger!

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

Sign up! or login

Share