Extraction of NetBackup Client Version from OpsCenter

If you have access to the NetBackup OpsCenter Sybase database -

How to setup a remote ODBC connection to the OpsCenter Analytics database (veritas.com)

- then it is very straightforward to acquire NetBackup client software version, for all of your NetBackup clients. You just need to run this query:

select name, versionLabel, osDescription from domain_Client where versionLabel is not NULL;

That will bring back everything from the past few years, which is probably going to be way too much. If you just want the active backup clients:

select name, versionLabel, osDescription from domain_Client where versionLabel is not NULL and isActive = 1;

Comments