Microsoft Dynamics AX/NAV/GP End of Life

Find 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.

Run the Dynamics AX/NAV/GP EOL Audit Report

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')

Show

Hide