Help converting SQL into SWQL

CARION

hey every one , i'm having difficulties trying to convert this SQL code into SWQL :

SELECT [OrionGroups].Name AS [GroupName]

     , [OrionGroups].DetailsUrl AS [GroupDetailsUrl]

     , [OrionGroups].Members.MemberUri AS [NodeUri]

     , [Nodes].Caption AS [Node]

     , [Nodes].IP AS [NodeIP]

     , [Nodes].CustomProperties.NODEType

    

FROM Orion.Groups AS [OrionGroups]

INNER JOIN Orion.Nodes AS [Nodes] ON [OrionGroups].Members.MemberUri = [Nodes].Uri

WHERE [OrionGroups].Name  like 'TFPM%' 

any help would be appreciated.

wluther

@CARION Hey there, just wanted to clarify you are actually trying to go from SQL to SWQL... As far as I can tell, this already appears to be SWQL.

What, exactly, are you needing from the query? You could probably trim it up a bit, and should be able to get away from using the join, otherwise I think you are already where you need to be, based on your initial info.