Hi,
As we know that the VRA managed machines has the following fields:
How can we also include the IP address field here. Is there any way?
Regards,
Sushma.
hey, you could use the VRA MSSQL
SELECT
[VirtualMachineID],
[VirtualMachineName],
(select TOP (1) dbo.StaticIPv4Address.IPv4Address from dbo.StaticIPv4Address where dbo.VirtualMachine.VirtualMachineID = dbo.StaticIPv4Address.VirtualMachineID) as "IP Address"
FROM [vra].[dbo].[VirtualMachine] where IsManaged ='1'
this will show you all managed VMs (you dont see others in managed machines tab), and pulls any IP address it finds for the VM from VRA IPAM.
I you use external IPAM no idea.
if you remove the TOP(1) from the line I hoped it would show _all_ Ips it finds for the VM, but it errors and I'm crap at SQL (ask your sql guy! :smileygrin: )
No, not unless you want to hack vRA.
hey, you could use the VRA MSSQL
SELECT
[VirtualMachineID],
[VirtualMachineName],
(select TOP (1) dbo.StaticIPv4Address.IPv4Address from dbo.StaticIPv4Address where dbo.VirtualMachine.VirtualMachineID = dbo.StaticIPv4Address.VirtualMachineID) as "IP Address"
FROM [vra].[dbo].[VirtualMachine] where IsManaged ='1'
this will show you all managed VMs (you dont see others in managed machines tab), and pulls any IP address it finds for the VM from VRA IPAM.
I you use external IPAM no idea.
if you remove the TOP(1) from the line I hoped it would show _all_ Ips it finds for the VM, but it errors and I'm crap at SQL (ask your sql guy! :smileygrin: )
It's worth pointing out that this is a SQL query and does not result in an additional column being added to the GUI as was originally asked by OP.