Discover what’s new in Lansweeper – Explore our 2024 Summer Launch! 🚀 Learn more

TRY NOW

Microsoft Dynamics 365 Business Central EOL

Security Software

Find Unsupported Dynamics 365 Business Central Installations

The report below will give you an overview of all on-premise installations of Microsoft Dynamics 365 Business Central in your network, as well as their end-of-life date. The report also shows you how much time you have left until the EOL date. When a product goes EOL it no longer receives any updates or support. Over time this can negatively affect performance and security. Make sure to update old installations in time.

Formerly known as Dynamics NAV and Navision, the product was rebranded to Dynamics 365 Business Central in 2018. This enterprise resource planning (ERP) system from Microsoft is designed to help small to medium businesses (SMB) with their finance, manufacturing, customer relationship management, supply chains, analytics, and electronic commerce operations. The product has both a SaaS version and an on-premise version, however, for this specific end of life, we’ll be focussing on the on-premises version.

The 2022 release wave 2, version 21.x will be going end-of-life on April 14th, 2024. You can read more about the Microsoft Dynamics 365 lifecycle in our Microsoft Dynamics EOL blog post.

Updates:

  • 2022/11/29: EOL date Version 21.X added
  • 2023/08/24: EOL date Version 22.X added
  • 2024/03/14: EOL date Version 23.X added

Microsoft Dynamics 365 Business Central EOL Lansweeper Classic 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 Cast(ParseName(tblsoftware.softwareVersion, 4) As int) < 13 Then
'EOL'
When tblsoftware.softwareVersion Like '13.%' Then '2020-04-14'
When tblsoftware.softwareVersion Like '14.%' Then '2025-10-14'
When tblsoftware.softwareVersion Like '15.%' Then '2021-04-13'
When tblsoftware.softwareVersion Like '16.%' Then '2022-04-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'
When tblsoftware.softwareVersion Like '20.%' Then '2023-10-10'
When tblsoftware.softwareVersion Like '21.%' Then '2024-04-14'
When tblsoftware.softwareVersion Like '22.%' Then '2024-10-08'
When tblsoftware.softwareVersion Like '23.%' Then '2025-04-02'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where
tblSoftwareUni.softwareName Like
'%Microsoft Dynamics 365 Business Central%' And
tblSoftwareUni.SoftwarePublisher Like '%Microsoft%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where subquery1.Software Like '%Microsoft Dynamics 365 Business Central%' And
subquery1.Publisher Like '%Microsoft%' And tblState.Statename = 'Active'

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You'll be up and running in no time.

Explore all our features, free for 14 days.