Microsoft Configuration Manager End of Life Audit

Check When Your Microsoft Endpoint Configuration Manager Version Is Going End of Life

SCCM (Microsoft System Center Configuration Manager), or Microsoft Endpoint Configuration Manager, or simply Microsoft Configuration Manager, depending on which version you have and what you prefer to call it, is one of the many tools organizations use to manage workstations and servers. For many organizations, it is a key component of their IT management in combination with Lansweeper. Obviously, keeping important components like SCCM up-to-date is critical to your organization’s security.

Microsoft only supports versions of their Endpoint Configuration Manager for a specific amount of time before they stop providing feature and security updates. Once a version has gone end of life, it is therefore important you update to a supported version to continue to receive updates. Get all the information regarding SCCM in our detailed blog.

With the report below, you can easily check what version your SCCM site has and when it goes end of life (or if it already has).

Run the Microsoft Endpoint Configuration Manager (SCCM) Audit Now!

Configuration Manager EOL Lansweeper On-Prem Query

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblOperatingsystem.Caption As OS,
tblSccmSite.Version,
Case
When GetDate() >= subquery1.[EOL Date] Then 'EOL'
When GetDate() < subquery1.[EOL Date] Then 'EOL in ' + Cast(DateDiff(DAY, GetDate(),
subquery1.[EOL Date]) As nvarchar) + ' days'
Else 'Supported'
End As Status,
subquery1.[EOL Date],
Case
When tblErrors.ErrorText Is Not Null Or
tblErrors.ErrorText != '' Then
'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
Else ''
End As ScanningErrors,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() >= subquery1.[EOL Date] Then '#ffadad'
When GetDate() < subquery1.[EOL Date] Then '#d4f4be'
End As backgroundcolor
From tblAssets
Left join (Select tblSccmServer.AssetId,
Case
When tblSccmSite.Version Like '5.00.7804%' Then '2022-07-12'
When tblSccmSite.Version Like '5.00.7958%' Then '2022-07-12'
When tblSccmSite.Version Like '5.00.8239%' Then '2022-07-12'
When tblSccmSite.Version Like '5.00.8325%' Then '2016-12-08'
When tblSccmSite.Version Like '5.00.8355%' Then '2017-03-11'
When tblSccmSite.Version Like '5.00.8412.1307%' Then '2017-10-12'
When tblSccmSite.Version Like '5.00.8412%' Then '2017-07-22'
When tblSccmSite.Version Like '5.00.8458%' Then '2017-11-18'
When tblSccmSite.Version Like '5.00.8498%' Then '2018-03-27'
When tblSccmSite.Version Like '5.00.8540%' Then '2018-07-31'
When tblSccmSite.Version Like '5.00.8577%' Then '2019-05-20'
When tblSccmSite.Version Like '5.00.8634%' Then '2019-09-22'
When tblSccmSite.Version Like '5.00.8692%' Then '2020-01-31'
When tblSccmSite.Version Like '5.00.8740%' Then '2020-12-01'
When tblSccmSite.Version Like '5.00.8790%' Then '2020-09-27'
When tblSccmSite.Version Like '5.00.8853%' Then '2021-01-26'
When tblSccmSite.Version Like '5.00.8913%' Then '2021-05-29'
When tblSccmSite.Version Like '5.00.8968%' Then '2021-10-01'
When tblSccmSite.Version Like '5.00.9012%' Then '2022-02-11'
When tblSccmSite.Version Like '5.00.9040%' Then '2022-05-30'
When tblSccmSite.Version Like '5.00.9049%' Then '2022-10-05'
When tblSccmSite.Version Like '5.00.9058%' Then '2023-02-02'
When tblSccmSite.Version Like '5.00.9068%' Then '2023-06-01'
When tblSccmSite.Version Like '5.00.9078%' Then '2023-10-08'
When tblSccmSite.Version Like '5.00.9088%' Then '2024-02-12'
When tblSccmSite.Version Like '5.00.9096%' Then '2024-06-05'
When tblSccmSite.Version Like '5.00.9106%' Then '2024-10-10'
When tblSccmSite.Version Like '5.00.9122%' Then '2025-04-09'
When tblSccmSite.Version Like '5.00.9128%' Then '2025-10-22'
End As [EOL Date]
From tblSccmSite
inner join tblSccmServer on tblSccmServer.SccmServerId = tblSccmSite.SccmServerId) As
subquery1 On subquery1.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner join tblSccmServer on tblSccmServer.AssetId = tblAssets.AssetID
Inner join tblSccmSite on tblSccmsite.SccmServerId = tblSccmServer.SccmServerId
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets.AssetID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
Max(tblErrors.Teller) As ErrorID
From tblErrors
Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
ScanningError.ID
Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
tblErrors.ErrorType
Where tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName

Show

Hide