SCCM EOL Audit

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

SCCM (Microsoft System Center Configuration Manager) or Microsoft Endpoint Configuration Manager depending on which version you have and how you prefer to call it is one of the many tools used in organizations to manage workstations and servers. For many organizations, it is a key component to managing their IT 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 SCCM 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 Audit

 

SCCM EOL 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.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'
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

Audit and Take Action in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting