how to exclude client that was removed from netbackup

[Aris56]

Hi, i'm creating a report that will give the output of every clients netbackup agent version. the SQL Query is as below: SELECT DM.friendlyName as 'Master Server', DC.Name AS "Client", lookup_OS.name AS "OS Type", DC.versionLabel AS "Client Version" FROM "domain_client" DC, "domain_masterserver" DM, lookup_OS WHERE DC.masterServerId = DM.id and DC.osType = lookup_OS.id and DC.isActive = '1' and DC.versionLabel != '7.6.0.4' and DC.versionLabel !='7.7.1' and DM.FriendlyName = 'bevmsl00' using this query will list all the clients including those that have been removed permanently from netbackup. does anyone know how can i exclude those removed clients? please advise. thanks.

[RiaanBadenhorst · Accepted solution]

Hi,

don't have a system to test now but take a look at the following columns from domain_client

deleted, isActive, isPolicyClient, isProtected, isValid

Then figure out which clients have the attribute you don't want in your list.