the easiest way would be to check assigned pollers in Manage Pollers (Settings -> Manage Pollers). You can check there for which nodes are Topology: Layer 2 / Layer 3 pollers enabled/supported.
Many thanks for the response, John.
I don't see the Manage Pollers option - you are talking about it being on the Orion Website Administration page, correct?
Yes, it's on the 'Orion Website Administration' page in the 'Node and Group Management' section.
Here is a quick SQL Report you can use to identify your missing devices from the L2 and L3 topology tables: (this may need to be validated, I haven't had a chance to check the data)
SELECT 'MISSING L2' AS 'ISSUE' ,Caption ,IP_Address FROM Nodes LEFT JOIN NodeL2Connections ON Nodes.NodeID = NodeL2Connections.NodeID WHERE NodeL2Connections.NodeID IS NULL UNION ALL SELECT 'MISSING L3' AS 'ISSUE' ,Caption ,IP_Address FROM Nodes LEFT JOIN NodeL3Entries ON Nodes.NodeID = NodeL3Entries.NodeID WHERE NodeL3Entries.NodeID IS NULL
However, please note that the 'Connect Now' feature of Network Atlas only works for devices that are discovered in NPM (according to the documentation). I do not think you can List Resources and add Topology polling and then use the feature later.
Again, I haven't had a chance to confirm these details, but this is my experience.
with SQL query it woult be better to check pollers table - not only bridge data as proposed by Zackm (which are stored in NodeL2Connections, we poll also other L2 data which are stored in different tables).
Try this SQL query:
select SysName, PollerType, Enabled
from Pollers left outer join Nodes on pollers.NetObjectID = nodes.nodeid
where pollertype like 'N.Topology%'
You will then see which topology pollers are assigned to node and if they are enabled. Hope it helps.
All - Thanks for the responses. It looks like John's SQL query will get me what I was look for - many thanks!
I checked back on that page and it looks like that is not an option under 10.6 (and I have full admin rights) :
Not a big deal deal and I have other things pressing.
Thanks again, everybody!
scotc It is there, but for NPM 10.7, not 10.6.
Also, if you were to disable the topology pollers through that manage poller option, it seems it would actually qualify all of your devices through that sql query. I reckon they decided to put those fields on every device in the db, and simply go by enabled=0 or enabled=1.