Issue while generating web Report for Custom Poller at interface level for transmit/Receive broadcast

When adding fields with Node caption, ip address along with interface name for the broadcast details Report doesn't show node name & ip address.

Took some reference & made this custom sql query to give the same report. But not sure why web report is doing such fuss.

Did anyone faced this issue?

SELECT
Nodes.caption AS Nodes,Nodes.ip_address,I.caption,
CustomPollerAssignment_CPA.assignmentname,CustomPollerStatus_CPS.datetime,CustomPollerStatus_CPS.Status AS Status
FROM
(Nodes INNER JOIN CustomPollerAssignment CustomPollerAssignment_CPA ON
(Nodes.NodeID = CustomPollerAssignment_CPA.NodeID))
INNER JOIN CustomPollerStatus CustomPollerStatus_CPS ON
(CustomPollerAssignment_CPA.CustomPollerAssignmentID =
CustomPollerStatus_CPS.CustomPollerAssignmentID)
INNER JOIN INTERFACES I ON (CustomPollerAssignment_CPA.interfaceid=I.interfaceid)
WHERE(
(CustomPollerAssignment_CPA.assignmentname like '%broadcast%'))

Find more posts tagged with

web reports

Interface broadcast

undp_universal_device_poller

Accepted answers

All comments

mnsh_majumder

Looks like even this query is also not working

alain_p

Hi @mnsh_majumder,

I've just tried re-writing your query, but am not able to test.
I believe that the round brackets in the initial query are not completely correct.

SELECT
n.Caption AS Nodes
  , n.IP_Address
  , i.caption
  , cpa.assignmentname
  , cps.datetime
  , cps.Status AS Status
FROM
  Nodes AS n
INNER JOIN
  CustomPollerAssignment AS cpa
ON
  n.NodeID = cpa.NodeID
INNER JOIN
  CustomPollerStatus AS cps
ON
  cpa.CustomPollerAssignmentID = cps.CustomPollerAssignmentID
INNER JOIN
  Interfaces AS i
ON
  cpa.InterfaceID = i.InterfaceID
WHERE
  cpa.AssignmentName like '%broadcast%'

Hope this brings you closer to what you want to achieve.

Regards,
alain_p