Powercli script for listing machines in a desktop pool

[vivekrishna]

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

[chrisdhalstead]

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"}}

[chrisdhalstead]

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 ...

[vivekrishna]

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

[sjesse]

Try lookin at this

https://www.retouw.nl/horizon-api-basics/

[vivekrishna]

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