Hi LucD, How can I add snaptime column in csv file? I want to make csv file look like: VMname | Snapshot name | description | date | email *email column is working but not the rest. Please chec...
See more...
Hi LucD, How can I add snaptime column in csv file? I want to make csv file look like: VMname | Snapshot name | description | date | email *email column is working but not the rest. Please check, thanks! Connect-VIServer tormsvdr –User cotadm61 –Password Toronto10 $snapTime = Get-Date "04/17/18 08:00" $snapName = 'Test' $snapDescription = 'Scheduled snapshot' $snapMemory = $true $snapQuiesce = $false $fileName = 'C:\TEST\April\snapshotfile.csv' Import-Csv -Path $fileName -UseCulture | %{ $vm = Get-VM -Name $_.VMName $si = get-view ServiceInstance $scheduledTaskManager = Get-View $si.Content.ScheduledTaskManager $spec = New-Object VMware.Vim.ScheduledTaskSpec $spec.Name = "Snapshot",$vm.Name -join ' ' $spec.Description = $_.Description $spec.Enabled = $true $spec.Notification = $_.email $spec.Scheduler = New-Object VMware.Vim.OnceTaskScheduler $spec.Scheduler.runat = $snapTime $spec.Action = New-Object VMware.Vim.MethodAction $spec.Action.Name = "CreateSnapshot_Task" @($snapName,$snapDescription,$snapMemory,$snapQuiesce) | %{ $arg = New-Object VMware.Vim.MethodActionArgument $arg.Value = $_ $spec.Action.Argument += $arg } $scheduledTaskManager.CreateObjectScheduledTask($vm.ExtensionData.MoRef, $spec) } disconnect-viserver -confirm:$false $snapTime = Get-Date "04/17/18 08:00" $snapName = 'Test' $snapDescription = 'Scheduled snapshot' $snapMemory = $true $snapQuiesce = $false $fileName = 'C:\snapshotfile.csv' Import-Csv -Path $fileName -UseCulture | %{ $vm = Get-VM -Name $_.VMName $si = get-view ServiceInstance $scheduledTaskManager = Get-View $si.Content.ScheduledTaskManager $spec = New-Object VMware.Vim.ScheduledTaskSpec $spec.Name = "Snapshot",$vm.Name -join ' ' $spec.Description = $_.Description $spec.Enabled = $true $spec.Notification = $_.email $spec.Scheduler = New-Object VMware.Vim.OnceTaskScheduler $spec.Scheduler.runat = $snapTime $spec.Action = New-Object VMware.Vim.MethodAction $spec.Action.Name = "CreateSnapshot_Task" @($snapName,$snapDescription,$snapMemory,$snapQuiesce) | %{ $arg = New-Object VMware.Vim.MethodActionArgument $arg.Value = $_ $spec.Action.Argument += $arg } $scheduledTaskManager.CreateObjectScheduledTask($vm.ExtensionData.MoRef, $spec) }