Hiw can i build widget that the user insert ip address and the result will be to which group belong ? Can i do it with wsql ?

avivi

Thanks

stuartd

I'm not 100% sure what you are looking to do, but it sounds similar to what we do but in a different way.

If the user only has the IP, then they can use 'Manage Nodes' to find the name of the node. At that point they can then click on the node which takes them to the node details for that node.

So, what we have done is create a widget on the 'Node Details Template' [N.B. you may ned to do this for a few different templates depending on which ones you use] and in that widget it will show what group(s) they are in and what map(s) they are on. The group and or map are directly clickable.

e.g.

To do this, simply add a Custom Query widget, name anyway you like and then add this SWQL to the query box:

SELECT
  CASE WHEN m.Container.Owner = 'Core' THEN 'Group'
    WHEN m.Container.Owner = 'Maps' THEN 'Map'
    ELSE 'Other' END AS [Type]
, CASE WHEN m.Container.Owner = 'Core' THEN m.Container.Name
     WHEN m.Container.Owner = 'Maps' THEN p.DisplayName
     ELSE 'Other' END AS [Name]
, m.Container.DetailsURL AS [_linkfor_Name]
, s.StatusName AS [Status]
, '/Orion/images/StatusIcons/Small-' + s.StatusName + '.gif' AS [_iconfor_Status]

FROM Orion.ContainerMembers m
JOIN Orion.StatusInfo s ON m.Container.Status = s.StatusID
LEFT JOIN Orion.Maps.Projects p ON m.Container.Name = p.ProjectID

WHERE m.MemberEntityType = 'Orion.Nodes'
 AND m.MemberPrimaryID = ${NodeID}

Set your number of rows to suit your environment. We went with 10 but the widget dynamically sizes to up to the number you select. We went with 10, but if I changed it to 3 then the above screenshot would only show the first 3 and then a more box for the rest.