If you have Microsoft Visio you can point it at a database and it will pretty much map it for you. To do this with Visio you will need to setup a data source.
A better tool may be the SQL Server Management Studio which will map your database as well.
Either way make sure you use a Read Only account so you don't hose up your database.
Try something like this:
Nodes.Caption AS NodeName, CustomNodePollerStatus_CustomPollerStatus.Status AS your_custompollername
((Nodes INNER JOIN CustomPollerAssignment CustomNodePollerAssignment_CustomPollerAssignment ON (Nodes.NodeID = CustomNodePollerAssignment_CustomPollerAssignment.NodeID)) INNER JOIN CustomPollers CustomNodePollers_CustomPollers ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerID = CustomNodePollers_CustomPollers.CustomPollerID)) INNER JOIN CustomPollerStatus CustomNodePollerStatus_CustomPollerStatus ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerAssignmentID = CustomNodePollerStatus_CustomPollerStatus.CustomPollerAssignmentID)
CustomPollerAssignment like 'your_custompollername%'
(CustomNodePollerAssignment_CustomPollerAssignment.InterfaceID = 0)