-
Re: Universal Device Poller - Custom Tables / Counting Rows
denny.lecompte Feb 18, 2009 10:04 AM (in response to EagleONE)What do you mean by "custom tables"? We support tables now; we only need the OID. You can use the Transform Results function to get many different functions, but I don't think we have Count.
-
Re: Universal Device Poller - Custom Tables / Counting Rows
EagleONE Feb 18, 2009 10:09 AM (in response to denny.lecompte)Custom Tables -
What I mean by this is a lot of Cisco SNMP tables use dynamic OIDs to label the row data. And it is difficult to query that row data since the OIDs are contanstaly changing.
As far as the row counting goes, I am trying to graph the number of active VoIP calls on a gateway. In order to do this it seems like I have to just count the tables in the 1.3.6.1.4.1.9.9.63.1.3.1 OID.
-
Re: Universal Device Poller - Custom Tables / Counting Rows
denny.lecompte Feb 18, 2009 2:50 PM (in response to EagleONE)There are some tables where one MIB table serves as an index for another MIB table. In order to use those, we would need to join the data from multiple tables. We may add this functionality in the future, but it's not planned for this next release.
-
Re: Universal Device Poller - Custom Tables / Counting Rows
pserwe May 28, 2010 12:56 PM (in response to denny.lecompte)Any word on joining tables? We're actually at the point of needing to go off-board to get this solved, which is pretty lame, considering the fairly significant amount of money we spend in maintenance and initial licensing.
At this point, my biggest problem is that the UnDP won't pull a full table, it will only pull 1 column at a time, and then I can't join the columns.
This makes the data in the table unusable by SW.
Peter
-
Re: Universal Device Poller - Custom Tables / Counting Rows
TehDuffman Mar 31, 2011 12:35 PM (in response to pserwe)any idea if this will get added. Not being able to pull entire oid tables is a huge problem but even if i had to make a different poller for each column and then could transform them i would consider that good enough.
-
Re: Universal Device Poller - Custom Tables / Counting Rows
MarieB Mar 31, 2011 3:18 PM (in response to TehDuffman)tehduffman--
It's been marked for PM to review.
M
-
Re: Universal Device Poller - Custom Tables / Counting Rows
Mark RobertsAug 30, 2016 10:11 AM (in response to MarieB)
Has this ever made it into Orion and I just haven't seen it?
We have this requirement where in a Checkpoint UnDP we have the name of a VS, but that only exists in one table and the other tables have another OID which has the ID of the VS to allow each table to tie together.
-
Re: Universal Device Poller - Custom Tables / Counting Rows
vinx Mar 7, 2017 7:27 AM (in response to Mark Roberts)I need to count rows too, i don't think it has been made
I need to count the number of CPU of a linux from 1.3.6.1.2.1.25.3.3.1.2 (hrProcessorLoad) for exemple
-
Re: Universal Device Poller - Custom Tables / Counting Rows
mesverrumMar 7, 2017 6:41 PM (in response to vinx)
I do all of these using custom SQL/SWQL queries, there is no native function to do so in the UI.
-
Re: Universal Device Poller - Custom Tables / Counting Rows
vinx Apr 26, 2017 9:15 AM (in response to mesverrum)Can you provide me an example please ?
thanks !
-
-
-
-
-
-
-
Re: Universal Device Poller - Custom Tables / Counting Rows
phillips.chris Sep 2, 2011 12:36 PM (in response to denny.lecompte)I agree, and could use this same functionality.
-
-
Re: Universal Device Poller - Custom Tables / Counting Rows
mattdaniel Sep 22, 2009 11:27 AM (in response to EagleONE)Did you find a way to count the number of rows? I am try to graph the same info (number of active VoIP calls). You can actually pull the table of rates and use the transform functions sum/average on that custom poller to find out the count, but because the transform is also a table, I don't see a good way to graph it as a single number.
Thanks,
Matt
-
Re: Universal Device Poller - Custom Tables / Counting Rows
Al Ma Sep 14, 2017 3:07 PM (in response to mattdaniel)Any progress/word on this yet?
I am in a similar situation and need just a single sum value to capture checkpoint concurrent VPN users. So far no luck...
-
-
-