I’ve been playing with the Virtual Machine Manager 2008 reports, and if you’re like me, you may be looking for a quick and easy way to pre-populate your virtualisation host names into the host based reports. If you run the Host Utilisation or the Host Utilisation Growth reports, you’ll be faced with this field to fill in every time you run the reports:
If you’re like me, and like to do a lot of ad hoc running of this report, you’ll get tired of manually typing in the name of your hosts every time. Help is at hand though as there is a simple way to pre-populate the hosts field with the names of all the hosts you wish to report against.
1. Navigate to http://report_server_name/reports where “report_server_name” is the name of the server running SQL reporting services. In my demo environment, I have one server running SC VMM 2008 as well as OpsMgr 2007 and SQL reporting services. You should see a screen similar to:
2. Click on the “Microsoft.Virtualization.Reports.2008” hyperlink
3. Then click on the “Show Details” button (top right) and you should see:
4. Click on the “Edit” button next to the “Host Utilisation” report as highlighted above and you will see:
5. Click on the “Parameters” tab to the left (highlighted above) and you will then be able to edit the input parameters for the report. You will see:
Note that the “Hosts” entry (highlighted above) has no default set and prompts the user for the names of the hosts to report against.
6. All we need to do is pre-populate our host names into this field as below:
Remember, to enter the hosts fully qualified domain name (FQDN) and REMEMBER to click the apply button highlighted! Job Done!
Now, when you run the Host Utilisation report from either the VMM 2008 console or OpsMgr console you wont be prompted for hostnames, and you should see a report like the following:
All in all, turned out to be a pretty simple exercise and great for demo environments!