I would like want from SQL to SWQL as mentioned below queries:
it's talks about F5 Load balancing report data to list down application
SELECT
DISTINCT F5_LTM_VirtualServer.ShortName AS "Publication Name",
F5_LTM_VirtualIPAddress.ShortName AS "Publication IP",
F5_LTM_VirtualIPAddress.IPAddress AS "Virtual IP Address",
F5_LTM_VirtualServer.Port AS "Virtual IP Port",
F5_LTM_Server.ShortName AS "Nodes Associated",
F5_LTM_PoolMember.Port AS "Node Port associated",
F5_LTM_PoolMember.F5Status AS "Publication status",
F5_LTM_PoolMember.F5StatusReason AS "Publication status Reason"
From NodesData
INNER JOIN F5_LTM_Pool
ON NodesData.NodeID = F5_LTM_Pool.NodeID
INNER JOIN F5_LTM_PoolMember
ON NodesData.NodeID = F5_LTM_PoolMember.NodeID
AND F5_LTM_PoolMember.PoolIndex = F5_LTM_Pool.PoolIndex
INNER JOIN F5_LTM_Server
ON F5_LTM_Server.NodeID = F5_LTM_PoolMember.NodeID
AND F5_LTM_Server.ServerIndex = F5_LTM_PoolMember.ServerIndex
INNER JOIN F5_LTM_VirtualIPAddress
ON NodesData.NodeID = F5_LTM_VirtualIPAddress.NodeID
INNER JOIN F5_LTM_VirtualServer
ON NodesData.NodeID = F5_LTM_VirtualServer.NodeID
AND F5_LTM_VirtualServer.IPAddressIndex = F5_LTM_VirtualIPAddress.IPAddressIndex
AND F5_LTM_VirtualServer.ShortName = F5_LTM_Pool.ShortName
Where
NodesData.Vendor= 'F5 Networks, Inc.'
Can you please let me help on this case.
