-
Re: Get Node Type in REST API query
jvb Feb 8, 2017 5:04 PM (in response to kt617)1 of 1 people found this helpfulNot sure if it is what you are looking for but I believe "Category" is the field...
Possible values there are
2 - Server
1 - Network
0 - Other
To get more granular in the description of the device, i.e. Firewall instead of "Network" you might have to assign a custom property to the node.
I only had a moment to glance at the tables though so I will try to look more closely this evening and add to this later if I find a better answer.
Edit:
It may also be NodesData_Category if you are looking via Nodes(View) rather than NodesData
-
Re: Get Node Type in REST API query
jvb Feb 9, 2017 4:23 PM (in response to jvb)1 of 1 people found this helpfulI think I pretty much verified this... I can't find anywhere that we are categorizing to the level of granularity you are hoping for.
So, the Custom Property route will give you the results you need but will require some work up front.
That being said, if you still wanted to group both on the original "Category" field and then on your custom property, you could use a query like this:
(I created a CP called "CategorySubType" and then filled it with Firewall, Switch, Router... Etc.etc.)
'SELECT Caption, Category, CategorySubType from Orion.Nodes as ND, Orion.NodesCustomProperties as NCP where NCP.CategorySubType = ''Firewall'' and ND.Category = 1 and ND.NodeID = NCP.NodeID'
Hope that helps!
-