how to exclude client that was removed from netbackup
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.
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.
