Hi,
im trying to obtain site to site VPN uptime via the python sdk and browsing through the schema I cant seem to see it. I know it exists as I can see it in NPM as per the below:
looking at the schema ive tried the below
asa_s2s_query = """
SELECT
n.NodeID,
n.VPNL2LTunnel.TargetIPAddress,
n.VPNL2LTunnel.InBitsPerSecond,
n.VPNL2LTunnel.OutBitsPerSecond,
n.VPNL2LTunnel.StatusDescription,
TOLOCAL(n.VPNL2LTunnel.StartTime) as connected_time
FROM
Orion.Nodes n
WHERE
n.NodeID = {}
""".format(device_data.solarwinds_id)
which shows connected time as July which isnt right
and I also tried getting the statistics too
asa_s2s_query = """ SELECT
n.NodeID,
n.VPNL2LTunnel.TargetIPAddress,
n.VPNL2LTunnel.InBitsPerSecond,
n.VPNL2LTunnel.OutBitsPerSecond,
n.VPNL2LTunnel.StatusDescription,
TOLOCAL(n.VPNL2LTunnel.Statistics.ObservationTimestamp) as connected_time
FROM
Orion.Nodes n
WHERE
n.NodeID = {}
""".format(device_data.solarwinds_id)
which returns multiple records and timestamps of which I cant see how any of these relate to the uptime either.
does anyone know where I can get this data?
Thanks
Alex
