/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


Newest / Current version of .NET framework

03/13/2018 848 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

3
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

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ