vivekrishna
Enthusiast
Enthusiast

Powercli script for listing machines in a desktop pool

Hi,

Is there any script for listing the unmanaged physical machines from a desktop pool or from the whole pod.

Also please help if there is any way to export to excel.

I tried using getunmanagedmachine parameter but it listed only not added physical machines..

Thanks

Vivek

0 Kudos
5 Replies
chrisdhalstead
VMware Employee
VMware Employee

Use the query service (View API - VMware API Explorer - VMware {code}) in PowerCLI and search for:

Unmanaged systems not added to a pool:

{"entityType":"RegisteredPhysicalMachineInfo","queryEntityType":"RegisteredPhysicalMachineInfo","sortDescending":false,"startingOffset":0}

Unmanaged systems added to a pool:

{"entityType":"MachineSummaryView","queryEntityType":"MachineSummaryView","sortDescending":false,"startingOffset":0,"filter":{"type":"Equals","memberName":"base.type","value":"UNMANAGED_MACHINE"}}

Chris Halstead Staff Architect, EUC Technical Marketing chalstead@vmware.com Twitter: @chrisdhalstead
chrisdhalstead
VMware Employee
VMware Employee

Also, this tool will export them to a .csv for import into excel:

GitHub - chrisdhalstead/horizon-physical-machines: App to quickly add Physical Machines into VMware ...

Chris Halstead Staff Architect, EUC Technical Marketing chalstead@vmware.com Twitter: @chrisdhalstead
0 Kudos
vivekrishna
Enthusiast
Enthusiast

COuld you please provde step bh step for invoking the api and running query.

0 Kudos
sjesse
Leadership
Leadership

vivekrishna
Enthusiast
Enthusiast

I tried this query API, I am not getting how to give the umanaged machine entity type and how the query definitions are run.

PLease help with example

0 Kudos