/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: JasonEgg 6 years ago
Red Belt
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
 
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