This report will identify UNDP Pollers that are assigned to Nodes but have null values. my goal here is to have a report that shows me where that 'no Data' is apparent. i have used status filters because i dont want to know if the node or interfaces is either down(status 2) or unmanned (status 9) but i want to know if the node is up.
i dont have any UNDP Pollers assigned to interfaces il be surprise to see what values you get back 
lol
Here is the SQL for copy and pasting convenience 
select '<img src="/NetPerfMon/images/Small-' + n.StatusLED + '"/> ' + '<a href="https://thwack.solarwinds.com/Orion/View.aspx?View=NodeDetails&NetObject=N:'; + CAST(n.NodeID AS varchar(256)) + '" style="font-size:100%">' + N.Caption + '</a>' AS NODE,av.LastStatusChange,av.AssignmentName,ISNULL(av.CurrentValue,'No UNDP Data') AS 'Value'from Nodes n with(nolock) join CustomPollerAssignmentView av with(nolock)on av.NodeID=n.NodeIDleft join interfaces i with(nolock) on i.InterfaceID = av.InterfaceIDwhere (av.CurrentValue IS NULL) AND (n.Status NOT IN('9','2')) OR (i.Status NOT IN('9','2'))many thanks