VMware Horizon Community
Daithi_N
Enthusiast
Enthusiast

Export vDesks to CSV File

Hi, All 

I'm currently facing an issue with my Get-HVMachine Summary by means that it doesn't Export All Machines to a CSV File, every now and again, I'm getting the following error on the Console, in turn, it fails to export this Machine to a CSV. 

 

Exception calling "QueryService_GetNext" with "2" argument(s): "ExceptionType : VMware.Hv.EntityNotFound
ErrorMessage : Could not find user or group in AD
Id : VMware.Hv.UserOrGroupId"
At C:\Program Files\WindowsPowerShell\Modules\VMware.Hv.Helper\VMware.HV.Helper.psm1:7446 char:23
+ ... $GetNext) { $queryResults = $query_service_helper.QueryService_GetNex ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : VimException

 

 

#Import Modules
Import-Module VMware.VimAutomation.HorizonView
Import-Module VMware.VimAutomation.Core
Get-Module -ListAvailable 'VMware.Hv.Helper' | Import-Module

 


$item = ''
'

#Connection to viewServer
$hvServer1 = Connect-HVServer -Server $item
$Services1= $hvServer1.ExtensionData


$vms = Get-HVMachineSummary
$results = @()

foreach($vm in $vms){
$properties = @{
HoizonServer = $item
ConnectionBroker = $vip
DomainUser = $vm.NamesData.UserName
MachineName = $vm.Base.Name
DisplayName = $vm.Base.DisplayName
MachineFQDN = $vm.Base.DnsName
VDIPool = $vm.NamesData.DesktopName
OSVersion = $vm.Base.OperatingSystem
MachineStatus = $vm.Base.BasicState
}

$results += New-Object psobject -Property $properties
}
$results | export-csv -NoTypeInformation -path c:\Scripts\HorizonData378.csv -append
Disconnect-HVServer -Server $item -confirm:$false

0 Kudos
0 Replies