Newest / Current version of .NET framework
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
Answers (1)
Please log in to answer
Posted by:
JasonEgg
6 years ago
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
