Is there a report that shows the version of .NET that is installed on the ITMS Site Servers?

Products

• Client Management Suite
• IT Management Suite
• Server Management Suite

Issue/Introduction

With the release of 8.7.1, .NET 4.8 is required for the Notification Server, and also Package and Task Services.  Is there a report that can show us the .NET version on our servers?

Environment

ITMS 8.x

Resolution

This SQL query will show what version of .NET is installed.

select distinct c.name, ca.[Agent Name], max (net.exactnetversion) as [.Net Version]
from vComputer c
join Inv_AeX_AC_Client_Agent ca
on ca._ResourceGuid = c.Guid
join Inv_AeX_AC_NetFrameworkVersions net
on net._ResourceGuid = c.Guid
where 
  ca.[Agent Name] = 'Altiris Client Task Server Agent'
  OR ca.[Agent Name] = 'Package Server'

group by c.name, ca.[Agent Name]
order by 1

 

Additional Information

If checking a server manually for .NET version, use this Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Client