<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>Cicciuzz Tracker</title>
    <link>https://communities.vmware.com/wbsdv95928/tracker</link>
    <description>Cicciuzz Tracker</description>
    <pubDate>Wed, 15 Nov 2023 14:31:16 GMT</pubDate>
    <dc:date>2023-11-15T14:31:16Z</dc:date>
    <item>
      <title>Again Date Format Problem</title>
      <link>https://communities.vmware.com/t5/vSphere-Update-Manager-PowerCLI/Again-Date-Format-Problem/m-p/977934#M277</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello everybody,&lt;/P&gt;&lt;P&gt;I made this script to collect stats for the vms.&lt;/P&gt;&lt;P&gt;I need to load data in mysql, but the date is a problem.&lt;/P&gt;&lt;P&gt;The date I get is related to the culture, but as you well know, MySql wants the Uformat for the time stamp.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$vCenter = "" ###&lt;/P&gt;&lt;P&gt;$VMList = ".txt" ###&lt;/P&gt;&lt;P&gt;$sdate = Get-Date 01/01/2018 ###&lt;/P&gt;&lt;P&gt;$fdate = Get-Date 01/04/2018 ###&lt;/P&gt;&lt;P&gt;$ExportPath = ".csv" ###&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$VMs = Get-Content $VMList&lt;/P&gt;&lt;P&gt;$Lines = type $VMList | Measure-Object -Line&lt;/P&gt;&lt;P&gt;$TotalObjects = $Lines.Lines&lt;/P&gt;&lt;P&gt;$stats = @()&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Import-Module -Name VMware.VimAutomation.Core&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Connect-VIServer -Server $vCenter -Protocol https -User&amp;nbsp; -Password &lt;/P&gt;&lt;P&gt;$counter=1&lt;/P&gt;&lt;P&gt;foreach($VM in $VMs)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; {&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Write-Host -NoNewline "Collecting data for" $VM "..."&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $stats += Get-Stat -Entity $VM -Start $sdate -Finish $fdate -Stat cpu.usage.average, mem.usage.average&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Write-Host " ( Done." $counter "out of" $TotalObjects ")" -ForegroundColor Yellow&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $counter=$counter+1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; }&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$stats | Export-Csv -Path $ExportPath -Force -NoTypeInformation&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Disconnect-VIServer $vCenter -Confirm:$false&lt;/P&gt;&lt;P&gt;Write-Host "Disconneted from " $vCenter&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 21 Feb 2018 21:51:24 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/vSphere-Update-Manager-PowerCLI/Again-Date-Format-Problem/m-p/977934#M277</guid>
      <dc:creator>Cicciuzz</dc:creator>
      <dc:date>2018-02-21T21:51:24Z</dc:date>
    </item>
  </channel>
</rss>

