I don't have F5 data handy to test with, but this should be close:
N.F5Devices.VirtualServers.ShortName AS [Publication Name],
N.F5Devices.VirtualIPAddresses.ShortName AS [Publication IP],
N.F5Devices.VirtualIPAddresses.IPAddress AS [Virtual IP Address],
N.F5Devices.VirtualServers.Port AS [Virtual IP Port],
N.F5Devices.Pools.PoolMembers.F5Server.ShortName AS [Nodes Associated],
N.F5Devices.Pools.PoolMembers.Port AS [Node Port associated],
N.F5Devices.Pools.PoolMembers.F5Status AS [Publication status],
N.F5Devices.Pools.PoolMembers.F5StatusReason AS [Publication status Reason]
FROM Orion.Nodes N
WHERE N.Vendor = 'F5 Networks, Inc.'
Have you installed SWQL studio in your environment yet? If you intend to get anything done in SWQL you won't get far without it, its basically a prerequisite. The tables in SQL have almost identical names and layouts to the ones in SWQL so it shouldn't take much work at all if you load Studio up and have a look.
Also worth pointing out that Solarwinds has recently posted a series of articles about using SWQL here:
Specifically these 3 may help