**Could not able to find the common timestamp column between orion.node and orion.NPM.interface

Question

1) Could not able to find the common timestamp column between orion.node and orion.NPM.interface via  SWIS API connect in to solarwinds database.

sum_giais · Answer

What are you trying to do? You’d usually join two tables / entities via an ID (integer) of some kind, when speaking interface we’d probably be looking at the NodeID to join it with the Orion.Nodes entity.

Timestamps elude to the goal of some sort of historical query (perhaps interface status or utilization history) but we could use more information to appropriately help you.

Do you have a query you’re working on and could share?