Rollup Queries from SCVMM Server

Apr 26, 2009 at 4:15 PM
We have centralized SCVMM servers to manage VMs across organization.  How can we use this library on a SCVMM server to rollup information from multiple hosts and guests.

For instance.. we are trying to get a report across all hosts to show all snapshots that exist and for what guests

Is this possible with this library today?
Does this library have to be run from each host directly?
Coordinator
May 5, 2009 at 9:40 AM
I thought you could get this information out of SCVMM (sorry not my main area of expertise). But yes you could use the library from one central machine to go to each of the hosts and get information about the snapshots.

Get-vm -server HostA,HostB,HostC  | Get-VMsnapshot

should do it.
May 11, 2009 at 7:56 PM
Edited May 11, 2009 at 8:06 PM

You can do that natively with the cmdlets from SCVMM

Issuing this from a machine with the SCVMM console should list all VMs on physical hosts tied into SCVMM and any snapshots

get-vm -vmmserver vmhost.blah.org | sort-object name | format-list -property Name, VMCheckpoints

Output should look something like this:

 Name          : SERVER1
VMCheckpoints : {}

Name          : SERVER2
VMCheckpoints : {SERVER2 - (3/3/2009 - 4:31:50 PM)}

Name          : SERVER3
VMCheckpoints : {SERVER3 - (04/28/2009 12:06:52), SERVER3 - (05/06/2009 16:37:31)

 

Server1 has 0 checkpoints, Server2 has 1 checkpoint, Server3 has 2 checkpoints