IBM Tivoli Storage Manager, Version 7.1

Query VM

Use the query VM command to list and verify the successful backups of virtual machines.

The Query VM command can be used to verify backups of both Microsoft Hyper-V virtual machines and VMware virtual machines. The information for each hypervisor is presented in its own section. If you are querying the backups of Hyper-V virtual machines, you can skip over the Query VM for VMware virtual machines text. If you are querying backups of VMware virtual machines, you do not need to read the Query VM for Hyper-V virtual machines text.

Query VM for VMware virtual machines

Use the query vm command to verify which VMware virtual machines were backed up.

Supported Clients

Linux operating systems This command is valid on Linux clients that are installed on a vStorage backup server.

Windows operating systems This command is valid on Windows clients that are installed on a vStorage backup server.

Syntax


>>-Query VM-- --vmname--+---------+----------------------------><
                        '-options-'

Parameters

vmname: Specifies the virtual machine host name that you want to process.
You can also specify the wildcard character (*) to show all vm backups on the Tivoli® Storage Manager server.

Table 1. Query VM command: Related options for VMware virtual machine queries.
Option	Where to use
detail Valid for vmbackuptype=fullvm Valid for -vmrestoretype	Command line.
inactive Valid for vmbackuptype=fullvm	Command line.
pitdate Valid for vmbackuptype=fullvm	Command line.
pittime Valid for vmbackuptype=fullvm	Command line.
vmbackuptype	Command line or client options file.
vmchost	Command line or client options file.
vmcpw	Command line or client options file.
vmrestoretype	Command line.
vmcuser	Command line or client options file.

Query VM examples (VMware)

The following are samples of using the query VM command with full VM and file-level VM, and with full VM and the -detail option.

Full VM

QUERY VM * -INA -vmbackuptype=FULLVM
#   Backup Date  Mgmt Class  Type    A/I  Virtual 
                                          Machine 
__  ___________  __________  ____    ___  _______
1   09/26/2008   DEFAULT     VMFULL  A    vm1
    11:34:14
2   09/26/2008   DEFAULT     VMFULL  A    vm2
    11:34:37
3   09/26/2008   DEFAULT     VMFULL  A    vm3
    11:34:49
4   09/26/2008   DEFAULT     VMFULL  I    vm2
    12:35:08
5   09/26/2008   DEFAULT     VMFULL  I    vm3
    12:35:18

Full VM with -detail option

q vm Small-SQL -detail
IBM Tivoli Storage Manager
Command Line Backup-Archive Client Interface
  Client Version 6, Release 4, Level 0.0
  Client date/time: 06/26/2012 14:08:44
(c) Copyright by IBM Corporation and other(s) 1990, 2012. All Rights Reserved.

Node Name: BAClient-DM
Session established with server TSM_SERVER1: Windows
  Server Version 6, Release 3, Level 0.0
  Server date/time: 06/26/2012 14:37:39  Last access: 06/26/2012 14:22:55

Query Virtual Machine for Full VM backup

 #      Backup Date       Mgmt Class  Size         Type   A/I Virtual Machine
---  -------------------  ----------  -----------  ------ --- ---------------
  1  06/26/2012 14:07:13  STANDARD       19.53 GB  FULL    A  Small-SQL
        The size of this incremental backup: n/a
        The number of incremental backups since last full: n/a
        The amount of extra data: n/a
        The TSM objects fragmentation: n/a
        Backup is represented by: n/a
        Application protection type: TSM VSS
        Application(s) protected: MS SQL 2008
        VMDK[1]Label:   Hard disk 1
        VMDK[1]Name:    [datastore1] Cloned-Small-SQL/Cloned-Small-SQL-000001.vmdk
        VMDK[1]Status:  Protected

File Level

QUERY VM * -vmbackuptype=FILE

Filespace Query for Virtual Machine 'vm1'

Accessing as node: vm1
#   Last Incr Date       Type    File Space Name 
__  ___________________  ____    _______________
1   09/25/2008 12:19:23  NTFS    \\vm1\c$   fsID: 2
2   09/25/2008 12:19:25  NTFS    \\vm1\e$   fsID: 3
3   09/25/2008 12:19:22  NTFS    \\vm1\z$   fsID: 1

Filespace Query for Virtual Machine 'vm2'

Accessing as node: vm2
#   Last Incr Date       Type    File Space Name 
__  ___________________  ____    _______________
1   09/25/2008 10:49:10  NTFS    \\vm2\c$   fsID: 2
2   09/25/2008 10:49:09  NTFS    \\vm2\h$   fsID: 1

Filespace Query for Virtual Machine 'vm3'

Accessing as node: vm3
#   Last Incr Date       Type    File Space Name 
__  ___________________  ____    _______________
1   09/25/2008 10:49:22  NTFS    \\vm3\c$   fsID: 2
2   09/25/2008 10:49:21  NTFS    \\vm3\h$   fsID: 1

The following command returns a list of VMs that are running an instant restore operation.

q vm * -vmrestoretype=instantrestore

Query VM for Microsoft Hyper-V virtual machines

Use the Query VM command to verify which Hyper-V virtual machines were backed up.

Supported Clients

Windows operating systems This command is valid on Windows clients that are installed on a Hyper-V host system.

Syntax


>>-Query VM-- --vmname--+---------+----------------------------><
                        '-options-'

Parameters

vmname

Specifies the virtual machine host name that you want to process.

You can also specify the wildcard character "*" to show all vm backups on the Tivoli Storage Manager server.

Windows operating systems For Hyper-V backup queries, if the vmbackuptype=hypervfull option is missing, the vmlist option values are used. If neither the vmname parameter or the vmlist option is specified, all virtual machines are shown. Wildcards are not allowed for the vmname parameter.

Table 2. Query VM command: Related options for Hyper-V virtual machine queries.
Option	Where to use
inactive Valid for vmbackuptype=hypervfull	Command line.
pitdate Valid for vmbackuptype=hypervfull	Command line.
pittime Valid for vmbackuptype=hypervfull	Command line.
vmbackuptype=hypervfull	Command line or client options file.

Query VM examples (Hyper-V)

The following is an example of using the query VM command with vmbackuptype=hypervfull.

Hyper-V full

 dsmc query vm -vmbackuptype=hypervfull 

#   Backup Date  Mgmt Class  Type  A/I Virtual Machine 
                                       (numofbytes B)
--  -----------  ----------  ----  --- ---------------
1   07/24/2009     DEFAULT   Full   A  Windows Vista 
                                      
2   07/25/2009     DEFAULT   Full   A  Windows 2008 
                                      
3   08/04/2009     DEFAULT   Full   A  Windows 2008

Feedback