Node Down Report

bjvariya

Dear THWACKs

We have tried to fetch downtime history report, but after 28th March 2023 we are unable to fetch it, there is not change in any criteria except dates. Later we found that Down time history table does not contain the data after 28th March 2023. However, response time table has all data. Below are the screenshots. 

So can you please let me know which process updates DownTime history table? and what would be cuased? I suspect that on 28th March something happened which affected this process, and till the date we are unable to get down details.

Node Down Report on or before 28th March 2023

------------------------------------------------------------------

Node Down Repor after 28th March 2023

-----------------------------------------------------------------

Node Down table before or on 28th March 2023

------------------------------------------------------

Node Down Repor after 28th March 2023

----------------------------------------------------------------

Thanks and Regards

Balvant

vinay.by

1. Check if the table InterfaceNetObjectDowntime has latest data.

2. Check if something is messed up with your NodesCustomProperties as you have an INNER JOIN on that as well. <---- (Maybe a stupid query but then this could be a possibility, as other tables are hardly touched unless there is an issue on your environment, but this is still accessible by an admin while he/she does day to day activities)

3. Lastly, there shouldn't be any issues with Orion.Nodes though unless something is really messed up.