07-21-2011 06:14 AM
Hi NBU guys,
i create select (query) to list not protected virtual servers by NetBackup. You can add "FriendlyName = 'MasterServer'" condition where MasterServer is "Display Name" from "General Properties" in "NetBackup Data Colection - OpsCenter"
SELECT FriendlyName as "MasterServer", clt.name as "Client", vm.proxyServer as "MediaServer", vm.IPAddress, vm.dataStore as "DataStore", vm.virtualServer as "ESX server", vm.operatingSystem as OS FROM nb_VirtualMachines vm, domain_Client clt, nom_Server WHERE
clt.masterServerId = vm.masterServerId AND
clt.masterServerId = HostGUID AND
vm.clientId=clt.id AND
UPPER(clt.name)= UPPER(vm.name) AND
vm.deleted=0 AND
clt.isVirtual=1 AND
clt.isPolicyClient=0
SELECT FriendlyName as "MasterServer", clt.name as "Client", vm.proxyServer as "MediaServer", vm.IPAddress, vm.dataStore as "DataStore", vm.virtualServer as "ESX server", vm.operatingSystem as OS FROM nb_VirtualMachines vm, domain_Client clt, nom_Server WHERE clt.masterServerId = vm.masterServerId AND clt.masterServerId = HostGUID AND vm.clientId=clt.id AND UPPER(clt.name)= UPPER(vm.name) AND vm.deleted=0 AND clt.isVirtual=1 AND clt.isPolicyClient=0 AND FriendlyName = 'MasterServer'