SCCM EOL Audit
SoftwareCheck 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).
SCCM EOL Lansweeper Classic 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' 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