Microsoft Dynamics AX and Dynamics NAV EOL

Find Unsupported Dynamics AX and Dynamics NAV Installations

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. Specifically, Microsoft Dynamics AX 2012 R3, Dynamics NAV 2013, and Dynamics NAV 2013 R2 will be going end of life on January 10, 2023.

You can read more about the Microsoft Dynamics AX lifecycle in our Microsoft Dynamics EOL blog post.

Updates
2022-12-05: EOL dates Dynamics NAV added.

Microsoft Dynamics AX and Dynamics NAV EOL 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 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'
When 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'
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%' 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%' And
subquery1.Publisher Like '%Microsoft%' And tblState.Statename = 'Active')

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting