WHEN tblSoftwareUni.softwareName LIKE '%NetCore.App%' WHEN tblMacApplications.Version IS NOT NULLĮLSE 'Check version via Terminal "dotnet -list-sdks"' WHERE tblSoftwareUni.softwareName LIKE '%dotnet%'ĪND tblSoftwareUni.softwareName NOT LIKE '%runtime%') AS subquery1 ON subquery1.AssetID = tblAssets.AssetIDĪND subquery1.Software NOT LIKE '%runtime%' INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 31 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 21 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 30 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 22 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 20 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 11 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(Replace(tblLinuxSoftware.Version, '.', ''),'-','')), 20), 2) AS INT) = 10 INNER JOIN tblLinuxSystem ON tblAssets.AssetID = tblLinuxSystem.AssetID SELECT DISTINCT TOP 1000000 tblAssets.AssetID,
Lansweeper software end of life windows#
OR subquery1.Software LIKE 'Microsoft Windows Desktop Runtime') WHERE(subquery1.Software LIKE 'Microsoft. ) AS subquery1 ON subquery1.AssetID = tblAssets.AssetID OR tblSoftwareUni.softwareName LIKE 'Microsoft Windows Desktop Runtime') WHERE(tblSoftwareUni.softwareName LIKE 'Microsoft. INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblsoftware.softID WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) >= 50 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 31 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 21 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 30 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 22 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 20 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 11 WHEN CAST(LEFT(RIGHT(CONVERT(BIGINT, Replace(tblsoftware.softwareVersion, '.', '')), 20), 2) AS INT) = 10 TblSoftwareUni.SoftwarePublisher AS Publisher, SELECT tblSoftwareUni.softwareName AS Software, LEFT JOIN tsysOS ON tsysOS.OScode = tblAssets.OScode INNER JOIN tblState ON tblState.State = tblAssetCustom.State INNER JOIN tsysIPLocations ON tsysIPLocations.LocationID = tblAssets.LocationID INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID TsysAssetTypes.AssetTypename AS AssetType, Net End of Life Audit Query SELECT DISTINCT TOP 1000000 tblAssets.AssetID, You can read more about the end of life in. NET end of life status, you can use the report below to get a list of all machines in your environment that have a. 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. The framework is cross-platform, meaning that it runs on Windows, macOS, and Linux operating systems. NET Core is a free, open-source, development platform by Microsoft.