Microsoft Dynamics AX EOL

Find Unsupported Dynamics AX Installations

Microsoft Dynamics AX is another ERP tool but with a focus on mid-sized and large enterprises. Microsoft is ending support for all remaining Dynamics AX versions as the product is continuing its life as the rebranded Microsoft Dynamics 365 for Finance and Operations SaaS solution. Specifically, Dynamics AX 2009, Dynamics AX 2012, and Dynamics AX 2012 R2 will be going end of life on April 12, 2022.

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

 

Microsoft Dynamics AX 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 cast(ParseName(tblsoftware.softwareVersion, 4) as int) < 15 then 'EOL' 
When tblsoftware.softwareVersion Like '15.%' Then '2021-04-13'
When tblsoftware.softwareVersion Like '16.%' Then '2021-10-12'
When tblsoftware.softwareVersion Like '17.%' Then '2022-04-12'
When tblsoftware.softwareVersion Like '18.%' Then '2022-10-11'
When tblsoftware.softwareVersion Like '19.%' Then '2023-04-12'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Dynamics 365%' and tblSoftwareUni.SoftwarePublisher like '%Microsoft%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where subquery1.Software Like '%Microsoft Dynamics 365%' And subquery1.Publisher like '%Microsoft%' and tblState.Statename = 'Active'

Audit and Take Action in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting