PRUEBA AHORA

Veeam EOL Audit

Security Software

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 Windows, Mac, and Linux
  • 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],
subquery5.Version As 'Veeam agent for Mac',
subquery5.EOLDate As 'Veeam agent for Mac EOL Date',
Case
When GetDate() < subquery5.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery3.EOLDate) As NVARCHAR) + ' days remaining'
End As [Veeam agent for Mac days remaining],
subquery6.Version As 'Veeam agent for Linux',
subquery6.EOLDate As 'Veeam agent for Linux EOL Date',
Case
When GetDate() < subquery3.EOLDate Then Cast(DateDiff(DAY, GetDate(),
subquery3.EOLDate) As NVARCHAR) + ' days remaining'
End As [Veeam agent for Linux days remaining],
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When GetDate() > subquery1.EOLDate Or 
GetDate() > subquery2.EOLDate Or
GetDate() > subquery3.EOLDate Or
GetDate() > subquery4.EOLDate Or
GetDate() > subquery5.EOLDate Or
GetDate() > subquery6.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'
When tblsoftware.softwareVersion Like '12.%' Then '2026-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'
When tblsoftware.softwareVersion Like '12.%' Then '2026-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'
When tblsoftware.softwareVersion Like '6%' Then '2026-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'
When tblsoftware.softwareVersion Like '12.0%' Then '2025-02-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
Left Join (Select tblSoftwareUni.softwareName As Software,
tblMacApplications.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When tblMacApplications.Version Like '1%' Then '2024-02-01'
When tblMacApplications.Version Like '2%' Then '2026-02-01'
End As EOLDate,
tblMacApplications.AssetID
From tblMacApplications
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblMacApplications.softID
Where tblSoftwareUni.softwareName Like '%Veeam agent for Mac%')
As subquery5 On subquery5.AssetID = tblAssets.AssetID
Left Join (Select tblSoftwareUni.softwareName As Software,
tblLinuxSoftware.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
Case
When tblLinuxSoftware.Version Like '1%' Then '2024-02-01'
When tblLinuxSoftware.Version Like '2%' Then '2026-02-01'
End As EOLDate,
tblLinuxSoftware.AssetID
From tblLinuxSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareID
Where tblLinuxSoftware.description Like '%Veeam agent for Linux%')
As subquery6 On subquery6.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 Or subquery5.Software Is Not Null Or
subquery6.Software Is Not Null)

Show

Hide