Last Change DTG is in the future

jimmy_mccubbins

We lost the router at 1/10/2020 2:54 PM.  SW says we lost BGP at 1/10/2020 8:43 PM.  Where is the difference of ~5hrs coming from?

SQL in use

select n.caption

,n2.caption as NeighborIPNode

,rnt.NeighborIP

, rnv.OrionStatus

,case

    when rnv.orionstatus = 2 then 'Down.gif'

end as Status

,rnt.AutonomousSystem,rnt.LastChange,n.Nodeid

from npm_routingNeighbor rnt

  join npm_routingneighbor_v rnv on rnt.NeighborID = rnv.Neighborid

                            and rnt.NodeID = rnv.NodeID

   join AlertObjects ao on ao.RelatedNodeID = rnt.NodeID

            and rnt.NeighborIP = ao.EntityCaption

  join AlertStatusView asv on asv.AlertObjectID = ao.AlertObjectID

  join Nodes n on rnt.NodeID = n.NodeID

left join nodeIPAddresses nip on rnt.NeighborIP = nip.IPAddress

  left join nodesData n2 on nip.nodeid = n2.nodeid

where (orionstatus = 2 or rnt.IsDeleted = 1)

and rnt.autonomousSystem in

(%%%%%%%%%%%%%%%%%%%%%%%%)

and asv.AlertDefID = '38C44B77-B8FC-4716-B62E-8AF798DC50A1'

and asv.Acknowledged = 0

and orionstatus is not null

and n.status != 9

and  (n2.status is null or  n2.status != 9)

order by n.caption,NeighborIP,N2.Caption

mesverrum

I'd wager your servers are in a -5 UTC time zone?

When you build custom widgets it's very important to confirm if the data in the DB is server time or, more likely, UTC and adjust your script accordingly.