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

TRY NOW

Microsoft Exchange Server End of Life Audit

Security Software

List Microsoft Exchange Server Installs and Their End of Life Dates

The report below gives you an overview of all the Microsoft Exchange Server installations in your network along with their end-of-life dates and the time remaining until EOL. Update any outdated installations in order to remain supported. You can read more in our Exchange Server end-of-life blog post.

Exchange Server is an email, calendar, and contact management software created by Microsoft. It provides you with a convenient platform to send and receive emails, create and manage calendars, schedule appointments and meetings, and manage your contacts. Exchange Server versions that have gone end-of-life no longer receive any updates, security fixes, or support. This can affect their performance as well as cause security risks over time. Run the audit to make sure all of your installs are still supported.

 

Microsoft Exchange Server 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 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) <= 14 Then
'EOL'
When tblsoftware.softwareVersion Like '15.%'And
tblSoftwareUni.softwareName Like '%2013%' Then '2023-04-11'
When tblsoftware.softwareVersion Like '15.%' And
tblSoftwareUni.softwareName Like '%2016%' Then '2025-10-14'
When tblsoftware.softwareVersion Like '15.%' And
tblSoftwareUni.softwareName Like '%2019%' Then '2025-10-14'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Exchange Server%' And
tblSoftwareUni.SoftwarePublisher Like '%Microsoft%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where subquery1.Software Like '%Microsoft Exchange Server%' 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.