cancel
Showing results for 
Search instead for 
Did you mean: 

Which virtual is missing from backup

Filip_Hasa
Level 4
Partner

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
 
Query with FriendlyName :
 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' 
 
Any comment is welcome.
 
Thanks Filip
0 REPLIES 0