This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Interface uptime in time, not percent

I have routers fitted with cellular interfaces, used as backup when the primary goes down.

I have an alert that tells me when these cell circuits come up, because I've found that carriers like to bring them up from time to time, not tell me about it, and bill me later (and amazingly, they have NO DATA) about when the line came up or what caused it. So now I know.

...but I digress...

What I would like is a way to report on the total uptime of an interface - in minutes (or hours, or whatever - just not as %uptime) so I could compare it to my bill.

Any thoughts on what table I'd be querying against, or what that SQL would look like?

Thanks in advance!