Looking for a DB SQL Query for NetObject for all Node Details views

First I've been trying to find the DBO for the Node Detials webviews. Then I need to query the DB for all of the NetObject numbers that match up to those Node Detail device views.

Thanks

Mike

Find more posts tagged with

Accepted answers

All comments

njoylif

Not sure if I understand what you are asking (maybe a screenshot would help clarify), but if you are talking about the URL when you click on a device and see details where then end looks like "NetObject=N:122"

Then the 122 is the NodeID field in the Nodes table.

so your query would look like "select NodeID from Nodes"

Radioman

Hows this - I have essentially 934 nodes or devices as it were. Each one has a details page that you get to by clicking on that device from the Summary Page.

What we're looking for is a way to pull ALL 934 device NAMES and ALL the associated Net Object number associated with that details page..

So it should produce 2 columns.

EXAMPLE

DEVICE (NODE) NAME NETOBJECT

hjsbsas02 N:568

erica.gill

Hi Radioman,

Try

SELECT Nodeid, Caption FROM NODES

One thing to watch out for is that the NetObject is for objects, not just nodes.

All the best,

Erica

Radioman

Thanks Erica.. Perfect.

Mike