Historical data on an interface in Database Manager

heldy

On one of our nodes all data on all interfaces was unavailable , rediscovered it , checked SNMP credentials and changed polling engine and so far looks like stats are getting collected for now .

The data was unavailable for around 2-3 days , i wanted to check in the database manager where can i find historical stats collected for these interfaces , i can see data in regular interfaces column but not data specific . Is there any date specific / historical Table/column i can check this data in ?

Please let me know.

monitoringlife

I'll let someone else answer your original query but are you looking for a way to find un-reporting interfaces?

If so:

SELECT I.Node.NodeName, I.InterfaceCaption, I.Status, ToLocal(I.LastSync) as LastSync
FROM Orion.NPM.Interfaces I
WHERE
    I.Node.Status IN ('1','3') AND --Node is (1)Up or (3)Warning]
    I.Node.UnManaged = 0 AND --node has not been unmanaged
    I.UnManaged = 0 AND --interface has not been unmanaged
    LastSync < ADDDATE('Minute', -30, GETUTCDATE())