NetBackup™ for VMware Administrator's Guide
- Introduction
- Required tasks: overview
- Configuring RBAC roles for VMware administrators
- Notes and prerequisites
- VMware vSphere privileges
- Managing VMware servers
- About VMware discovery
- Add VMware servers
- Change resource limits for VMware resource types
- Configuring backup policies for VMware
- Backup options on the VMware tab
- Exclude disks tab
- Configuring a VMware Intelligent Policy
- About the Reuse VM selection query results option
- Use Accelerator to back up virtual machines
- Configuring protection plans for VMware
- Malware scan
- Instant access
- Instant rollback
- Continuous data protection
- Backing up virtual machines
- VM recovery
- VMware agentless restore
- Restoring Individual files and folders from VMware backups
- Using NetBackup to back up Cloud Director environments
- Recover VMware Cloud Director virtual machines
- Restore virtual machines with Instant Recovery
- Protecting VMs using hardware snapshots and replication
- Best practices and more information
- Troubleshooting VMware operations
- NetBackup logging for VMware
- Snapshot error encountered (status code 156)
- Appendix A. Configuring services for NFS on Windows
- About configuring services for NFS on Windows 2012 or 2016 (NetBackup for VMware)
- Appendix B. Backups of VMware raw devices (RDM)
Examples for the NetBackup Query Builder
The following table provides example query rules.
To use the Query Builder, you must click Clients tab.
on theClick
to see the query rule in Advanced mode. Only this mode supports the use of parentheses for grouping sets of rules.See Using the Query Builder in Advanced mode.
Note:
The advanced mode of the Query Builder uses OData keywords and operators.
Another topic is available on the difference between AND and OR in a query.
Table: Query Builder examples
VIP Example query | OData example query * | Query result when backup job runs |
---|---|---|
No query rules specified (Query pane is empty) | No query rules specified (Query pane is empty) | All virtual machines are added to the backup list. Exceptions are those that do not have a host name, or that have invalid characters in the display name. See Effect of Primary VM identifier parameter on Selection column in Test Query results. |
Displayname Contains "prod" | contains(displayName, 'prod') | All virtual machines with the display names that contain the string "prod" are added to the backup list. See Effect of Primary VM identifier parameter on Selection column in Test Query results. |
powerstate Equal "poweredOn" | powerState eq 'poweredOn' | Any virtual machine that is turned on is added to the backup list. |
VMGuestOS Equal "windows7Guest" | vmGuestOs eq 'windows7Guest' | All virtual machines with a guest OS of Windows 7 are added to the backup list. |
DisplayName AnyOf "grayfox7","grayfox9" | displayName in ('grayfox7', 'grayfox9') | The virtual machines named "grayfox7"and "grayfox9" are added to the backup list. (Note that each value must be enclosed in its own quotes, with a comma in between.) |
powerstate Equal "poweredOn" AND Datastore Equal "Storage_1" AND VMGuestOS Equal "rhel4Guest" | powerState eq 'poweredOn' and datastoreName eq 'Storage_1' and vmGuestOs eq 'rhel4Guest' | In datastore Storage_1: any virtual machine that is turned on and has a guest OS of Red Hat Linux 4 is added to the backup list. |
vCenter Equal "vCenterServer_1" AND ESXserver Contains "prod" | vCenter eq 'vCenterServer_1' and contains(host, 'prod') | In the vCenter server vCenterServer_1, virtual machines that are in ESX servers with names containing "prod" are added to the backup list. |
Cluster Equal "VMcluster_1" AND ESXserver AnyOf "ESX_1","ESX_2","ESX_3" AND VMHostName Contains "Finance" | cluster eq 'VMcluster_1' and host in ('ESX_1', 'ESX_2', 'ESX_3') and contains(hostName, 'Finance') | In cluster VMcluster_1, all virtual machines with the host names that contain "Finance", in ESX servers ESX_1, ESX_2, ESX_3, are added to the backup list. |
VMFolder StartsWith "Prod" OR VMFolder NotEqual "VM_test" | startswith(vmFolder, 'Prod') or vmFolder ne 'VM_test' | For any folder whose name starts with "Prod" or whose name is not "VM_test", add its virtual machines to the backup list. |
Examples with IsSet | ||
Datacenter Contains "prod" AND Tag Equal "Finance" | contains(datacenter, 'prod') and tagName eq 'Finance' | This query selects any virtual machine where the Datacenter contains "prod" and the user-specified tag is "Finance". |
Datacenter Equal "prod" AND NOT Tag Equal "Test" | datacenter eq 'prod' and not (tagName eq 'test') | Selects virtual machines where Datacenter is "prod" but excludes any virtual machines that have the user-specified tag "Test". |
* Use OData operators only when you build queries with the NetBackup web UI's advanced mode under the Query Builder or with NetBackup APIs. |