cancel
Showing results for 
Search instead for 
Did you mean: 

how to exclude client that was removed from netbackup

Aris56
Level 4
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.
1 ACCEPTED SOLUTION

Accepted Solutions

RiaanBadenhorst
Level 6
Partner    VIP    Accredited Certified

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.

View solution in original post

1 REPLY 1

RiaanBadenhorst
Level 6
Partner    VIP    Accredited Certified

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.