VMware Communities > VMware Developer > Sample Code > PowerCLI > Documents
Up to Documents in PowerCLI

Report into MS Word

VERSION 3 Published

Created on: Aug 14, 2008 7:18 AM by alanrenouf - Last Modified:  May 22, 2009 11:48 AM by alanrenouf

Firstly, I wanted you to know that I only started with PowerShell around a month ago when I saw the cool things you were doing with the beta of the VI toolkit, so not only have I been learning the toolkit but also PowerShell, this will hopefully excuse the basics of my code and I am sure that the experts will find a better (and faster) way of doing it !

Scenario:

You have convinced your IT Manager that VI3 is the best virtualisation product compared to the others out there on the market (that was the easy bit). You have told him how much money you will save him and how environmentally friendly his server room will now be. He has dusted off his corporate wallet and agreed to pay for.

Your "pointy haired" IT Manager has asked for a weekly report of what is virtualised and an overall status of what is happening in this new wonderful system, whilst you are working 24hr shifts just to get the downtime for servers whilst your users sleep you do not have time to keep creating reports.....Enter my script !

Answer:


You could send him a bunch of html emails and csv outputs but your manager would only need help importing them and help understanding what each file is. This script not only outputs all the results straight to MS Word but also adds nice colourful graphs and pie charts (which we all know makes managers happy). The script can be easily added too, to enable further output utilising the functions.

It can also email the results directly to the manager and maybe be used in a scheduled task ?!


On a personal Note:


This has really given me a reason to start to learn PowerShell (I have been meaning to for ages) and also learn how to use the fantastic new VI toolkit, if nothing else I have gained the valuable experiences of learning PS and the toolkit. Thanks to the creators.


Usage:


Report.ps1 YOURVISERVER

You will need MS Word and the Office Web Components (script will tell you where to download if not installed)

This script takes a varied amount of time to run and only reads data, no configuration changes are made at all, obviously the bigger system the longer it will take, not that you would notice if it was a scheduled task.

The email areas are currently commented out at the end awaiting customisation if needed.

Sorry if it doesnt work on your VI, I have not been able to test as extensively as I would have liked due to only having one VI.

Office XP/2003/2007 tested.

Attachments:
Tags: powershell, scripting, toolkit, contest
Average User Rating
(5 ratings)




Comments (30)
Aug 26, 2008 1:38 AM jmedd  says:

This is awesome! We are now using this to contribute to our monthly reporting to management.

Very useful indeed, no modification was required to run in our environment.

Aug 27, 2008 1:15 AM sTyLeR_1  says:

Hi Alan,

This is a very good script as there is not much else for reporting. A good reporting function is missing in both esx server and virtual center.

The document looks good and usefull and the script is easy to use.

There are a few things i would like to see more but i already e-mailed those.

Overall e very very nice job!

Sep 4, 2008 4:46 PM halr9000  says:

Running it against my 250 VM VI now. It better be good, it's been running forever. :)


Author of the upcoming book: Managing VMware Infrastructure with PowerShell
Co-Host, PowerScripting Podcast (http://powerscripting.net)

Sep 5, 2008 6:23 AM halr9000  says: in response to: halr9000

Sorry for not commenting back--I barely finished my judging work in time to drive to @jonwalz for the podcast show last night. :)

Yes, the report finished and I think it's awfully cool and very comprehensive. I like all the progress bars--without that the waiting would have been intolerable.

Dec 15, 2008 6:27 PM dlm1975  says:

Great report. Worked out of the box. I have 265 VMs. No issues.

Dec 16, 2008 12:57 AM alanrenouf  says: in response to: dlm1975

Thanks for the comment, glad it worked fine in your environment, I will be creating a newer and hopefully faster version when I get time, you can follow my blog for updates and other scripts I have written...

http://teckinfo.blogspot.com/

Dec 16, 2008 10:24 AM ServerDude  says:

Can't get this to work for me. I'm running ESX 3.5 Update 2 and VI 2.5 Update 3.

Microsoft Word Detected
Office Web Components Detected
Connecting to VI Server
The term 'Connect-VIServer' is not recognized as a cmdlet, function, operable program, or script file. Verify the term
and try again.
At C:\Scripts\Report.ps1:204 char:17
+ Connect-VIServer <<<< $VIServer
Creating New Word Document
Setting Variables...Please wait
The term 'Get-VM' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try ag
ain.
At C:\Scripts\Report.ps1:227 char:14
+ $VMs = Get-VM <<<<
The term 'Get-VMHost' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and tr
y again.
At C:\Scripts\Report.ps1:228 char:19
+ $VMHs = Get-VMHost <<<<
The term 'Get-Datastore' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and
try again.
At C:\Scripts\Report.ps1:229 char:20
+ $Ds = Get-Datastore <<<<
The term 'Get-resourcepool' is not recognized as a cmdlet, function, operable program, or script file. Verify the term
and try again.
At C:\Scripts\Report.ps1:230 char:23
+ $rp = Get-resourcepool <<<<
The term 'Get-Cluster' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and t
ry again.
At C:\Scripts\Report.ps1:231 char:19
+ $clu = Get-Cluster <<<<
The term 'Get-VMHost' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and tr
y again.
At C:\Scripts\Report.ps1:237 char:22
+ $hosts = Get-VMHost <<<< $vmh.Name | %{Get-View $_.ID}
Creating Host Information Table...Please Wait
Cannot index into a null array.
At C:\Scripts\Report.ps1:268 char:15
+ if ($contents0 <<<< -eq $null){
Cannot index into a null array.
At C:\Scripts\Report.ps1:281 char:15
+ if ($contents0 <<<< -eq $null){
No entries for VM Information found
Cannot index into a null array.
At C:\Scripts\Report.ps1:311 char:15
+ if ($contents0 <<<< -eq $null){
Cannot index into a null array.
At C:\Scripts\Report.ps1:324 char:15
+ if ($contents0 <<<< -eq $null){
The term 'get-view' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try
again.
At C:\Scripts\Report.ps1:333 char:34
+ $contents = @($VMs | % { get-view <<<< $_.ID } | select Name, @{ Name="ToolsVersion"; Expression={$_.config.tools.to
olsVersion}} | Sort-Object Name)
No entries for VMWare Tools Version found
No entries for Datastore Information found
No entries for Datastore Information found
No entries for Cluster Information found
No entries for Resource Pool Information found
The term 'Get-Snapshot' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and
try again.
At C:\Scripts\Report.ps1:402 char:34
+ $contents = @($VMs | Get-Snapshot <<<< | select-object VM, Name, Description)
No entries for Snapshot Information found
The term 'Get-Snapshot' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and
try again.
At C:\Scripts\Report.ps1:415 char:34
+ $contents = @($VMs | Get-Snapshot <<<< | where { $_.Created -lt (get-date).addmonths(-1)} | select-object VM, Name,
Description, Created)
No entries for Snapshot's over 1 Month old found
The term 'Get-Snapshot' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and
try again.
At C:\Scripts\Report.ps1:431 char:28
+ $snapshots = Get-Snapshot <<<< -VM $vm
No entries for Snapshot's over 1 Month old found

Start Date: 12/16/2008 12:14:57
End Date: 12/16/2008 12:15:05
Argument: '1' should not be a System.Management.Automation.PSReference. Do not use ref.
At C:\Scripts\Report.ps1:460 char:16
+ $wordDoc.SaveAs( <<<< ref$filename)
The term 'Disconnect-VIServer' is not recognized as a cmdlet, function, operable program, or script file. Verify the te
rm and try again.
At C:\Scripts\Report.ps1:485 char:20
+ Disconnect-VIServer <<<< -Confirm:$False
PS C:\Scripts>

Dec 16, 2008 12:19 PM alanrenouf  says: in response to: ServerDude

Hi, Sorry you are having problems, from the looks of it you dont have the VI toolkit (http://www.vmware.com/sdk/vitk_win/index.html) installed as the first cmdlet 'connect-viserver' is not working. If you havent yet installed it you will need to download and install on the same machine as powershell.

Good luck.

Dec 16, 2008 2:55 PM jmedd  says: in response to: alanrenouf

Might also be the version of the VI Toolkit. I think the connect-viserver cmdlet was named differently in an earlier version.......

Dec 17, 2008 12:46 AM alanrenouf  says: in response to: jmedd

jmedd, true, in the Beta version it was 'get-viserver' but hopefully he will be using the current version which has lots of fixes and major performance tweaks

Dec 17, 2008 4:04 PM SetClear  says: in response to: alanrenouf

Please help, installed Word and excell oto the virtualcenter server where this report would be scheduled and run. but I get a tom of errors and when the reports finished it have no charting.

Whats wrong?

Below is the output from the powershell window...
if you need something else let me know.
I am running the latest version of the VI toolkit as I am doing heavy use of the API/SDK for cloning across clusters/datacenters and some of the functionality is only available in the RC release.

Output:
Creating New Word Document
Setting Variables...Please wait
Creating Host Information Table...Please Wait
Creating Top 5 Hosts CPU Usage %Average bar chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:73 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:101 char:10
+ $series. <<<< Caption = "$Caption (last 24hrs)"
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:103 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:104 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Top 5 Hosts MEM Usage %Average bar chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:73 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:101 char:10
+ $series. <<<< Caption = "$Caption (last 24hrs)"
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:103 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:104 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating VM Information Table...Please Wait
Creating Top 5 Virtual Machines CPU Usage %Average bar chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:73 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:101 char:10
+ $series. <<<< Caption = "$Caption (last 24hrs)"
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:103 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:104 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Top 5 Virtual Machines MEM Usage %Average bar chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:73 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:101 char:10
+ $series. <<<< Caption = "$Caption (last 24hrs)"
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:103 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:104 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating VMWare Tools Version Table...Please Wait
Creating Datastore Information Table...Please Wait
Creating Nutley - Vmware_VR5_1000G-001_ProdClonesOnly Space Allocation pie chart
...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SCNYVFMSP001 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - VMware_VR5_300G-004 (!!!Full!!! Do Not Use.) Space Allocation pie
chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP005-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP006-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SCNYPADSP001_3_OS Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - VMware_VR5_300G-001 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SC HA-DRA Infra Storage 200-1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - VMware_VR5_300G-005 (!!!Full!!! Do Not Use.) Space Allocation pie
chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP011-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP001-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SCNYPADSP002_4_OS Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - VMware_VR5_300G-002 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-005 (Do Not Use - Full) Space Allocation pie c
hart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - Vmware_VR5_1000G-001_ProdClonesOnly Space Allocation pie chart...
Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP007-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-001 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SC HA-DRA Infra Storage 150-2 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SC HA-DRA Infra Storage 200-2 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - VMware_VR5_300G-006 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX002_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX003_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX008_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SC HA-DRA Infra Storage 250-1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - VMware_VR5_300G-003 (!!!Full!!! Do Not Use.) Space Allocation pie
chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX006_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-006 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating SC HA-DRA Infra Storage 150-3 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-002 (Do Not Use - Full) Space Allocation pie c
hart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - Vmware_VR5_500G-001 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - Vmware_VR5_300G-007 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NYI - Vmware_VR5_300G-008 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX004_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP008-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-003 (Do Not Use - Full) Space Allocation pie c
hart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX005_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-007 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX001_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NY-ESX007_LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP009-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-008 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Nutley - VMware_VR5_300G-004 (Do Not Use - Full) Space Allocation pie c
hart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating NJ-ESXP010-LD1 Space Allocation pie chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:128 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:129 char:41
+ $dl = $series.DataLabelsCollection.Add <<<< ()
Property 'HasValue' cannot be found on this object; make sure it exists and is
settable.
At C:\Scripts\VIReporter\VIReport.ps1:130 char:6
+ $dl. <<<< HasValue = "True"
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:137 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:138 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:139 char:17
+ $series.SetData <<<< (2, -1, $values)
Creating Cluster Information Table...Please Wait
Creating Resource Pool Information Table...Please Wait
Creating Snapshot Information Table...Please Wait
Creating Snapshot's over 1 Month old Table...Please Wait
Creating Number of snapshots per VM bar chart...Please Wait
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:73 char:59
+ $series = (array $chart.charts)[0].SeriesCollection.Add <<<< (0)
Property 'Caption' cannot be found on this object; make sure it exists and is s
ettable.
At C:\Scripts\VIReporter\VIReport.ps1:80 char:10
+ $series. <<<< Caption = $Caption
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:103 char:17
+ $series.SetData <<<< (1, -1, $categories)
You cannot call a method on a null-valued expression.
At C:\Scripts\VIReporter\VIReport.ps1:104 char:17
+ $series.SetData <<<< (2, -1, $values)

Start Date: 12/17/2008 18:38:40
End Date: 12/17/2008 18:51:50

Dec 18, 2008 1:04 AM alanrenouf  says: in response to: SetClear

Hi,

A few people have had this issue, I think its an issue with the version of the office web components, I would uninstall the office web components and install them from the url in the script.

Also you did know you dont have to run this on your VC server didnt you ? You can run it on any server/workstation with Powershell and the VI Toolkit installed !

Hope you get it working.

Alan

Dec 18, 2008 10:33 AM SetClear  says: in response to: alanrenouf

Alan,

The Link is what was used to get the office web component.
Set excell to $true and still not gettting anything in the charts.
and there are no titles either. Veru odd. are there any issues with Office 2007 fully patched?

Dec 19, 2008 1:02 AM alanrenouf  says: in response to: SetClear

Thats very strange, I have tried it with Word 2007 before and its worked fine, to test the office web components can you try this please.....

http://teckinfo.blogspot.com/2008/07/quick-stats-from-vmware-for-reports.html

You should also be able to get hold of my email address from there if thats easier.

Dec 19, 2008 7:44 AM rmarche  says: in response to: jmedd

Sweet script. In case anyone is having a similar problem, I had to run the following prior to running the ps1.

Add-PSsnapin VMware.VimAutomation.Core
Initialize-VIToolkitEnvironment.ps1

Hope this helps
Rick

Dec 19, 2008 11:25 AM alanrenouf  says: in response to: rmarche

Correct, If your running this as a scheduled task you need to add that to tell powershell to add the VI Toolkit snapin. Thanks for the comments rmarche.

Dec 19, 2008 11:28 AM alanrenouf  says: in response to: SetClear

Some people have managed to fix the non showing graph issues by doing the following:

Please replace the line that says:

$series = (http://array]$chart.charts)0.SeriesCollection.Add(0)

by the following lines:

$chartsEntry = (array $chart.charts)[0]
$chartEntry = $chartsEntry.Add(0)
$series = $chartEntry.SeriesCollection.Add(0)

Dec 23, 2008 8:35 AM BasicVirtu  says: in response to: alanrenouf

Ran great against our Test VI host! I was wondering if this can be run against the Virtual Center Server so it collects all the VI servers in the cluster into one word document. I was a little scurrred to try it as we have alot of them and didn't want to have a chance of crashing it. Great post!

Dec 23, 2008 11:01 AM alanrenouf  says: in response to: BasicVirtu

I have not known any instance of it crashing any servers yet, go for it, it may take a while if you have a large environment but shouldn't cause stress on your VI

Dec 23, 2008 2:03 PM BasicVirtu  says: in response to: alanrenouf

Thanks it worked great except for some empty graphs... I will try to use your code in the above post to see if it changes the results.

Jan 6, 2009 1:51 PM BasicVirtu  says: in response to: alanrenouf

These lines are difficult to read for some reason, I think the html is messing them up; I tries this but it doesn't seem to work. The graph displays fine with individual esx hosts but when I run it against our virtual center the esx hosts do not display the graphs. Any suggestions?

"$chartsEntry = (array $chart.charts)[0]"
"$chartEntry = $chartsEntry.Add(0)"
"$series = $chartEntry.SeriesCollection.Add(0)"

Also any suggestions/links for a first time user trying to code some of it. I set it up with VS2008 and added a powershell template and the vim dlls as a reference but still having issues. I wanted to change some of the date/time properties in the report and didn't know what was available.

Jan 23, 2009 11:34 AM Sandhya94  says:

I love this script! Thank you Thank you Thank you!! I can't believe how easy it was to use and the info that it provided is so valuable.
Sandhya

Mar 5, 2009 6:07 AM pkratz  says:

I have problems to get it running

powershell Report.ps1 esx1

gives the result:
The term 'Report.ps1' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again.
At line:1 char:11
+ Report.ps1 <<<< esx1

VItoolkit 1.5 is installed and works

Mar 5, 2009 6:24 AM SetClear  says: in response to: pkratz

dot source it.
.\Report.ps1

Mar 5, 2009 7:04 AM pkratz  says: in response to: SetClear

Thanks, that helped but now I stuck with that message:

Microsoft Word Detected
Office Web Components Detected
Connecting to VI Server
The term 'Connect-VIServer' is not recognized as a cmdlet, function, operable program, or script file. Verify the term and try again.
...

VItoolkit 1.5 is installed and when I call it manually and run a "Connect-VIServer esx1" it works. It just asks for login credentials.

May 18, 2009 10:50 AM max2479  says:

having problems :

param( string $VIServer )

if ($VIServer -eq "powershell.exe Report.ps1 vc1"){
Write-Host
Write-Host "Please specify a VI Server name eg...."
Write-Host " powershell.exe Report.ps1 MYVISERVER"
Write-Host
Write-Host
exit

vc1 is my virtual center
debug message:

Microsoft Word Detected
Office Web Components Detected
Connecting to VI Server
The argument cannot be null or empty.

May 18, 2009 2:30 PM alanrenouf  says: in response to: max2479

Max,

This script was made for you to run passing it your VI Server as an input to the script, you should not need to ammend the code at all.

Just run the script like so:

PS> .\report.ps1 vc1

Or if you are loading it into something like powergui script editor type your VI server name in the text box next to the play button.

Sorry for the confusion.


Alan Renouf
http://virtu-al.net

Jun 25, 2009 2:37 PM foxy1977  says: in response to: alanrenouf

Hi Alan,

I'm just trying to get the script running on my vcenter box but i do not have the office addin installed. When i try and run the script i get an error saying this script requires MS word, please install Word. I had previously managed to install an office 2003 pack from MS but i cannot for the life of me find out what one it was.

Could you post of link of the MS office 2003 download that i need to run this script.

Thanks

Jun 25, 2009 4:19 PM max2479  says: in response to: foxy1977

Foxy1977,
The link is actually in the script. if you get this error there should of been a link where to download it. Make sure oyu have latest version of Alan's script.
the link is: http://www.microsoft.com/downloads/details.aspx?FamilyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en


if you found this or any other answer useful please consider allocating points for helpful or correct answers <

Oct 20, 2009 8:21 AM vancod  says: in response to: alanrenouf

I've scoured your blog in search of an updated version of this script, and there appears to be none. Is that correct?

Incoming Links

More by alanrenouf

View alanrenouf's profile