Microsoft SharePoint Server End of Life Audit

List Microsoft SharePoint Server Installs and Their End of Life Dates

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

SharePoint Server is document-sharing and collaboration software created by Microsoft. It allows you to create websites where you can store and manage your documents and then share them with others across your organization, to better support your business processes. Once the product goes end-of-life, it will no longer receive any updates or support from Microsoft. In time, this can negatively impact performance and security. Run the audit to make sure all of your installs are still supported.

Run the SharePoint Server End-of-Life Audit Report

Microsoft SharePoint 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.%' Then '2023-04-11'
When tblsoftware.softwareVersion Like '16.%'
and tblSoftwareUni.softwareName like '%2016%'
Then '2026-07-14'
When tblsoftware.softwareVersion Like '16.%'
and tblSoftwareUni.softwareName like '%2019%'
Then '2026-07-14'
When tblsoftware.softwareVersion Like '16.%'
and tblSoftwareUni.softwareName like '%Subscription Edition%'
Then 'N/A'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where
tblSoftwareUni.softwareName Like '%Microsoft Sharepoint Server%'
And tblSoftwareUni.SoftwarePublisher Like '%Microsoft%') As subquery1 On
subquery1.AssetID = tblAssets.AssetID
Where (subquery1.Software Like '%Microsoft Sharepoint Server%' )
And subquery1.Publisher Like '%Microsoft%' and tblState.Statename = 'Active'

Show

Hide