SELECT TOP (1000)
      [OblakLive20112019].[network].IPv4BinaryToString([VMMPrivateIP]) AS PrivateIP
      ,[VMMACAddress]
	  ,PIP.Supernet
	  ,PIP.Subnet
FROM [OblakLive20112019].[network].[PublicIPVMAssignment] AS PIPVM
 LEFT JOIN [OblakLive20112019].[network].PublicIP AS PIP
  ON PIPVM.PublicIPID = PIP.PublicIPID
 LEFT JOIN [OblakLive20112019].[network].IPAssignmentType AS IPAT
  ON PIP.AssignmentTypeID = IPAT.AssignmentTypeID
 LEFT JOIN [OblakLive20112019].[network].IPType AS IPT
  ON PIP.TypeID = IPT.TypeID
WHERE VMInstanceID = '9a7e2cca-20c5-46da-899b-94e55942cd4e'