Find Outdated Veeam Installations
Veeam's backup solutions are widely used to ensure that, should the worst-case scenario occur, you always have a backup. Since the product is a last resort, it is best to ensure it never runs into issues and that you are using the latest version. The report below provides an overview of all Windows Veeam products, their version, and their end-of-life status. The report lets you monitor the Veeam lifecycle in your IT environment. The report covers the following Veeam products:
- Veeam Backup & Replication
- Veeam ONE
- Veeam Agent for Microsoft Windows
- Veeam Backup for Microsoft 365
You can read more about the Veeam lifecycle in our Veeam EOL blog post and you can go straight to the Veeam EOL Lansweeper reports here:
Veeam Lansweeper Classic 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.SP,
subquery1.Version As 'Veeam Backup & Replication',
subquery1.EOLDate As 'Veeam Backup & Replication EOL Date',
Case
When GetDate() < subquery1.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery1.EOLDate) As NVARCHAR) + ' days remaining'
End As [Veeam B&R days remaining],
subquery2.Version As 'Veeam ONE',
subquery2.EOLDate As 'Veeam ONE EOL Date',
Case
When GetDate() < subquery2.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery2.EOLDate) As NVARCHAR) + ' days remaining'
End As [Veeam ONE days remaining],
subquery3.Version As 'Veeam agent for Windows',
subquery3.EOLDate As 'Veeam agent for Windows EOL Date',
Case
When GetDate() < subquery3.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery3.EOLDate) As NVARCHAR) + ' days remaining'
End As [Veeam agent for Windows days remaining],
subquery4.Version As 'Veeam backup for Microsoft Office 365',
subquery4.EOLDate As 'Veeam backup for Microsoft Office 365 EOL Date',
Case
When GetDate() < subquery4.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery4.EOLDate) As NVARCHAR) + ' days remaining'
End As [Veeam backup for Microsoft Office 365 Days Remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() > subquery1.EOLDate Or GetDate() > subquery2.EOLDate Or
GetDate() > subquery3.EOLDate Or
GetDate() > subquery4.EOLDate Then '#ffadad'
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 tblsoftware.softwareVersion Like '9.5%' Then '2022-01-31'
When tblsoftware.softwareVersion Like '10.%' Then '2023-02-01'
When tblsoftware.softwareVersion Like '11.%' Then '2024-02-01'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where tblSoftwareUni.softwareName Like 'Veeam Backup & Replication%') As
subquery1 On subquery1.AssetID = tblAssets.AssetID
Left Join (Select tblSoftwareUni.softwareName As Software,
tblsoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When tblsoftware.softwareVersion Like '9.5%' Then '2022-01-31'
When tblsoftware.softwareVersion Like '10.%' Then '2023-02-01'
When tblsoftware.softwareVersion Like '11.%' Then '2024-02-01'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where tblSoftwareUni.softwareName Like '%Veeam ONE') As subquery2 On
subquery2.AssetID = tblAssets.AssetID
Left Join (Select tblSoftwareUni.softwareName As Software,
tblsoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When tblsoftware.softwareVersion Like '3%' Then '2022-01-31'
When tblsoftware.softwareVersion Like '4%' Then '2023-02-01'
When tblsoftware.softwareVersion Like '5%' Then '2024-02-01'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where tblSoftwareUni.softwareName Like '%Veeam agent for Microsoft Windows')
As subquery3 On subquery3.AssetID = tblAssets.AssetID
Left Join (Select tblSoftwareUni.softwareName As Software,
tblsoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When tblsoftware.softwareVersion Like '9.6.6%' Then '2022-11-01'
When tblsoftware.softwareVersion Like '10.0.1%' Then '2022-11-01'
When tblsoftware.softwareVersion Like '10.0.2%' Then '2026-01-31'
When tblsoftware.softwareVersion Like '10.0.3%' Then '2026-01-31'
When tblsoftware.softwareVersion Like '10.0.4%' Then '2026-01-31'
When tblsoftware.softwareVersion Like '10.0.5%' Then '2026-01-31'
When tblsoftware.softwareVersion Like '11.1.0%' Then '2024-03-01'
When tblsoftware.softwareVersion Like '11.2.0%' Then '2024-03-01'
End As EOLDate,
tblsoftware.AssetID
From tblsoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
Where
tblSoftwareUni.softwareName Like
'%Veeam backup for microsoft 365%') As subquery4 On
subquery4.AssetID = tblAssets.AssetID
Where tblState.Statename = 'Active' And (subquery1.Software Is Not Null Or
subquery2.Software Is Not Null Or subquery3.Software Is Not Null Or
subquery4.Software Is Not Null)
