Looking for the table which contains this piece of data.

zhollett

I have created a custom poller which checks a date on a UPS.  I have selected to not keep historical data on this date as it only changes every 5 years when the batteries are replaced.  When I view the node via our Orion site, I see the date which the UDP retrevied from the UPS.

The question I have is this:

When you use the Universal Device Poller and select to NOT keep historical data, where is the data that it does collect get stored? (looking for the Table name)

Thanks in advance

Zach

netlogix

does this get it for you?

SELECT [CustomPollerStatus].[Status], CustomPollers.MIB
 FROM [CustomPollerAssignment]
  inner join CustomPollers on CustomPollers.CustomPollerID = CustomPollerAssignment.CustomPollerID
  inner join CustomPollerStatus on CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID
 where CustomPollerAssignment.Nodeid = <YOUR_NODE_ID>