KB: vRealize Automation – Explore IaaS objects with Linqpad
Get Linqpad and run the setup.
Once installed, you can connect LinqPad with your IaaS server:
- Type: ODATA3
- Credential: IaaS Service Account
After validation, and a couple of minutes to load the database schema, you should see the list of tables:
And on the right part of screen you can enter C# Expression (by default) requests.
Here are some requests samples:
To get a subset list of VMs in the IaaS db:
To filter on VM name:
1VirtualMachines.Where(vm=> vm.VirtualMachineName == "MyVMName")
To display expanded properties of an object, it's possible to use:
1VirtualMachines.Expand("StaticIPv4Addresses").Where(vm=> vm.VirtualMachineName == "MyVMName")
This card is highly inspired by the two following blog posts: