PRUEBA AHORA

.NET End of Life Audit

Security Software

Find End of Life .NET Installations

.NET (formerly .NET Core) is a free, open-source, development platform by Microsoft. The framework is cross-platform, meaning that it runs on Windows, macOS, and Linux operating systems. This allows developers to more easily create an application that supports multiple platforms. .NET Core supports building different types of applications like mobile, desktop, web, cloud, IoT, machine learning, microservices, games, and much more.

To help you get an overview of the .NET end-of-life status, you can use the report below to get a list of all machines in your environment that have a .NET core installation. You can read more about the end of life in the .NET core end-of-life blog post.

Run the .NET End of Life Audit Now!

.NET End of life Audit report

.NET End of Life Audit Lansweeper Classic Query

SELECT DISTINCT TOP 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename AS AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 AS icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname AS OS,
tblAssets.SP,
subquery1.Software,
subquery1.Version,
subquery1.Publisher,
subquery1.EOLDate,
CASE
WHEN GETDATE() < subquery1.EOLDate
THEN CAST(DATEDIFF(DAY, GETDATE(), subquery1.EOLDate) AS NVARCHAR) + ' days remaining'
END AS [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
CASE
WHEN GETDATE() > subquery1.EOLDate
THEN '#ffadad'
ELSE '#d4f4be'
END AS backgroundcolor
FROM tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tsysIPLocations ON tsysIPLocations.LocationID = tblAssets.LocationID
INNER JOIN tblState ON tblState.State = tblAssetCustom.State
LEFT JOIN tsysOS ON tsysOS.OScode = tblAssets.OScode
LEFT JOIN
(
SELECT tblSoftwareUni.softwareName AS Software,
tblsoftware.softwareVersion AS Version,
tblSoftwareUni.SoftwarePublisher AS Publisher,
CASE
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 10
THEN '2019-06-27'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 11
THEN '2019-06-27'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 20
THEN '2018-10-01'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 22
THEN '2019-12-23'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 30
THEN '2020-03-03'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 21
THEN '2021-08-21'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 31
THEN '2022-12-13'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 50
THEN '2022-06-01'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 60
THEN '2024-11-12'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 70
THEN '2024-05-14'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 80
THEN '2026-11-10'
END AS EOLDate,
tblsoftware.AssetID
FROM tblsoftware
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblsoftware.softID
WHERE(tblSoftwareUni.softwareName LIKE 'Microsoft .NET%Core%'
OR tblSoftwareUni.softwareName LIKE 'Microsoft Windows Desktop Runtime%' OR tblSoftwareUni.softwareName LIKE 'Microsoft .NET%Runtime%')
) AS subquery1 ON subquery1.AssetID = tblAssets.AssetID
WHERE(subquery1.Software LIKE 'Microsoft .NET%Core%'
OR subquery1.Software LIKE 'Microsoft Windows Desktop Runtime%' OR subquery1.Software LIKE 'Microsoft .NET%Runtime%')
AND tblState.Statename = 'Active'
UNION
SELECT DISTINCT TOP 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename AS AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 AS icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblLinuxSystem.OSRelease AS OS,
tblAssets.SP,
subquery1.Software,
subquery1.Version,
subquery1.Publisher,
subquery1.EOLDate,
CASE
WHEN GETDATE() < subquery1.EOLDate
THEN CAST(DATEDIFF(DAY, GETDATE(), subquery1.EOLDate) AS NVARCHAR) + ' days remaining'
END AS [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
CASE
WHEN GETDATE() > subquery1.EOLDate
THEN '#ffadad'
ELSE '#d4f4be'
END AS backgroundcolor
FROM tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tsysIPLocations ON tsysIPLocations.LocationID = tblAssets.LocationID
INNER JOIN tblState ON tblState.State = tblAssetCustom.State
INNER JOIN tblLinuxSystem ON tblAssets.AssetID = tblLinuxSystem.AssetID
LEFT JOIN
(
SELECT tblSoftwareUni.softwareName AS Software,
tblLinuxSoftware.Version AS Version,
tblSoftwareUni.SoftwarePublisher AS Publisher,
CASE
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 10
THEN '2019-06-27'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 11
THEN '2019-06-27'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 20
THEN '2018-10-01'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 22
THEN '2019-12-23'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 30
THEN '2020-03-03'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 21
THEN '2021-08-21'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 31
THEN '2022-12-13'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 50
THEN '2022-06-01'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 60
THEN '2024-11-12'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 70
THEN '2024-05-14'
WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 80
THEN '2026-11-10'
END AS EOLDate,
tblLinuxSoftware.AssetID
FROM tblLinuxSoftware
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID
WHERE tblSoftwareUni.softwareName LIKE '%dotnet%') AS subquery1 ON subquery1.AssetID = tblAssets.AssetID
WHERE subquery1.Software LIKE '%dotnet%'
AND tblState.Statename = 'Active'
UNION
SELECT TOP 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename AS AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 AS icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblMacOSInfo.SystemVersion AS OS,
tblAssets.SP,
tblSoftwareUni.softwareName AS Software,
CASE
WHEN tblMacApplications.Version IS NOT NULL
THEN tblMacApplications.Version
ELSE 'Check version via Terminal "dotnet --list-sdks"'
END AS Version,
tblSoftwareUni.SoftwarePublisher AS Publisher,
'N/A' AS eoldate,
'N/A' AS [Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
CASE
WHEN tblSoftwareUni.softwareName LIKE '%NetCore.App%'
THEN ''
END AS backgroundcolor
FROM tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
INNER JOIN tsysIPLocations ON tsysIPLocations.LocationID = tblAssets.LocationID
INNER JOIN tblState ON tblState.State = tblAssetCustom.State
INNER JOIN tblMacApplications ON tblAssets.AssetID = tblMacApplications.AssetID
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblMacApplications.softid
INNER JOIN tblMacOSInfo ON tblMacOSInfo.AssetID = tblAssets.AssetID
WHERE tblSoftwareUni.softwareName LIKE '%NetCore.App%'
AND tblSoftwareUni.softwareName NOT LIKE '%Asp%'
AND tblState.Statename = 'Active'
ORDER BY Domain,
AssetName,
Software;

Show

Hide