vSphere PowerCLI : Report into MS Word : Comments

RE: Report into MS Word

jmedd — Tue, 26 Aug 2008 08:38:35 GMT

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.

RE: Report into MS Word

sTyLeR_1 — Wed, 27 Aug 2008 08:15:15 GMT

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!

RE: Report into MS Word

halr9000 — Thu, 04 Sep 2008 23:46:33 GMT

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)

RE: Report into MS Word

halr9000 — Fri, 05 Sep 2008 13:23:50 GMT

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.

RE: Report into MS Word

dlm1975 — Tue, 16 Dec 2008 02:27:05 GMT

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

RE: Report into MS Word

alanrenouf — Tue, 16 Dec 2008 08:57:00 GMT

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/

RE: Report into MS Word

ServerDude — Tue, 16 Dec 2008 18:24:23 GMT

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>

RE: Report into MS Word

alanrenouf — Tue, 16 Dec 2008 20:19:56 GMT

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.

RE: Report into MS Word

jmedd — Tue, 16 Dec 2008 22:55:50 GMT

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

RE: Report into MS Word

alanrenouf — Wed, 17 Dec 2008 08:46:54 GMT

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

RE: Report into MS Word

SetClear — Thu, 18 Dec 2008 00:04:39 GMT

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

RE: Report into MS Word

alanrenouf — Thu, 18 Dec 2008 09:04:14 GMT

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

RE: Report into MS Word

SetClear — Thu, 18 Dec 2008 18:33:43 GMT

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?

RE: Report into MS Word

alanrenouf — Fri, 19 Dec 2008 09:02:56 GMT

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.

RE: Report into MS Word

rmarche — Fri, 19 Dec 2008 15:44:31 GMT

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

RE: Report into MS Word

alanrenouf — Fri, 19 Dec 2008 19:25:15 GMT

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.

RE: Report into MS Word

alanrenouf — Fri, 19 Dec 2008 19:28:03 GMT

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)

RE: Report into MS Word

BasicVirtu — Tue, 23 Dec 2008 16:35:12 GMT

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!

RE: Report into MS Word

alanrenouf — Tue, 23 Dec 2008 19:01:43 GMT

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

RE: Report into MS Word

BasicVirtu — Tue, 23 Dec 2008 22:03:38 GMT

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.

RE: Report into MS Word

BasicVirtu — Tue, 06 Jan 2009 21:51:55 GMT

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.

RE: Report into MS Word

Sandhya94 — Fri, 23 Jan 2009 19:34:04 GMT

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

RE: Report into MS Word

pkratz — Thu, 05 Mar 2009 14:07:48 GMT

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

RE: Report into MS Word

SetClear — Thu, 05 Mar 2009 14:24:40 GMT

dot source it.
.\Report.ps1

RE: Report into MS Word

pkratz — Thu, 05 Mar 2009 15:04:18 GMT

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.

RE: Report into MS Word

max2479 — Mon, 18 May 2009 17:50:05 GMT

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.

RE: Report into MS Word

alanrenouf — Mon, 18 May 2009 21:30:05 GMT

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

RE: Report into MS Word

foxy1977 — Thu, 25 Jun 2009 21:37:20 GMT

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

RE: Report into MS Word

max2479 — Thu, 25 Jun 2009 23:19:56 GMT

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 <

RE: Report into MS Word

vancod — Tue, 20 Oct 2009 15:21:43 GMT

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