Microsoft Dynamics AX/NAV/GP End of Life
Security SoftwareFind Unsupported Dynamics AX, NAV, and GP Installations
This report will give you an overview of any installations of Microsoft Dynamics AX, NAV, and GP in your network, as well as their version and end-of-life date. Once the software goes end-of-life, it will no longer receive any updates or support. Over time this can seriously affect performance and security. Make sure to audit your network for outdated installations and update them to stay supported.
Dynamics GP is one of the products in Microsoft’s Dynamics line of ERP tools. It is aimed at small and medium-sized businesses and shares some overlap with Dynamics 365 Business Central. However, Dynamics is specifically designed to be an on-premise tool and there are some differences with regard to hosting, licensing, upgrades, updates, and functionality.
Microsoft Dynamics AX and Dynamics NAV were Microsoft’s ERP tools before they were rebranded as Dynamics 365 for Finance and Operations and Dynamics 365 Business Central respectively. Microsoft is ending support for all remaining Dynamics AX and NAV versions as the product is continuing its life as the rebranded Microsoft Dynamics 365 SaaS solutions.
You can read more about the lifecycles of the different Microsoft Dynamics products in our Microsoft Dynamics EOL blog post.
Updates
2022-12-05: EOL dates Dynamics NAV added.
2023-03-07: Dynamics GP added
Microsoft Dynamics AX/NAV/GP End Of Life 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.Version As OSVersion, tblAssets.SP, subquery1.Software, subquery1.Version, subquery1.Publisher, subquery1.EOLDate, Case When IsDate(subquery1.EOLDate) = 1 and GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(), subquery1.EOLDate) As NVARCHAR) + ' days remaining' End As [Days Remaining], tblAssets.Lastseen, tblAssets.Lasttried, Case When subquery1.EOLDate = 'EOL' then '#ffadad' When IsDate(subquery1.EOLDate) = 1 and GetDate() > subquery1.EOLDate Then '#ffadad' When IsDate(subquery1.EOLDate) = 1 and GetDate() >= DateAdd(month, -1, subquery1.EOLDate) Then '#ffd152' 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 tblSoftwareUni.softwareName Like '%Microsoft Dynamics AX%' And tblsoftware.softwareVersion Like '4.%' Then '2016-10-11' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics AX%' And tblsoftware.softwareVersion Like '5.%' Then '2022-04-12' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics AX%' And tblsoftware.softwareVersion Like '6.0%' Then '2022-04-12' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics AX%' And tblsoftware.softwareVersion Like '6.2%' Then '2022-04-12' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics AX%' And tblsoftware.softwareVersion Like '6.3%' Then '2023-01-10' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%' And tblsoftware.softwareVersion Like '5.%' Then '2017-04-11' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%' And tblsoftware.softwareVersion Like '6.%' Then '2020-01-14' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%' And tblsoftware.softwareVersion Like '7.%' Then '2023-01-10' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%' And tblsoftware.softwareVersion Like '8.%' Then '2025-01-14' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%' And tblsoftware.softwareVersion Like '9.%' Then '2026-04-14' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%' And tblsoftware.softwareVersion Like '10.%' Then '2027-01-11' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%' And tblsoftware.softwareVersion Like '11.%' Then '2028-01-11' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics GP%' And Cast(ParseName(tblsoftware.softwareVersion, 3) As int) <= 11 Then 'EOL' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics GP%' And tblsoftware.softwareVersion Like '12.%' Then '2023-04-11' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics GP%' And tblsoftware.softwareVersion Like '14.%' Then '2025-04-08' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics GP%' And tblsoftware.softwareVersion Like '16.%' Then '2026-07-14' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics GP 2018%' And tblsoftware.softwareVersion Like '18.%' Then '2028-01-11' When tblSoftwareUni.softwareName Like '%Microsoft Dynamics GP%' And tblsoftware.softwareVersion Like '18.%' And tblSoftwareUni.softwareName Not Like '%2018%' Then 'N/A' End As EOLDate, tblsoftware.AssetID From tblsoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID Where (tblSoftwareUni.softwareName Like '%Microsoft Dynamics AX%') Or (tblSoftwareUni.softwareName Like '%Microsoft Dynamics NAV%') Or (tblSoftwareUni.softwareName Like '%Microsoft Dynamics GP%' And tblSoftwareUni.SoftwarePublisher Like '%Microsoft%')) As subquery1 On subquery1.AssetID = tblAssets.AssetID Where (subquery1.Software Like '%Microsoft Dynamics AX%') Or (subquery1.Software Like '%Microsoft Dynamics NAV%') Or (subquery1.Software Like '%Microsoft Dynamics GP%' And subquery1.Publisher Like '%Microsoft%' And tblState.Statename = 'Active')