Editing Orion SQL tables

We had a 12 hour period recently when our Orion server was unable to ping one of our subnets. This means that the data for the nodes within this subnet is now incorrect and looks like they were all 'down'.

Has anyone had any experience of editing the SQL tables manually to change this to 'up'?

Which tables would need amending and with what?

Thanks

Find more posts tagged with

orion

npm_10

sql_2005_database

Accepted answers

All comments

njoylif

I've got experience with this.

call me at the number below, we'll either work it or schedule something and I will try to assist.

Please backup your database before calling.

mikefarn

Hi,

Thanks for the reply - I'm in the UK though so any chance you could describe it over email?

I'm fine in SQL once I know where and what to change ...

njoylif

select n.caption, rt.* from ResponseTime_Hourly rt join Nodes n on rt.nodeid=n.nodeid
where n.caption like '%V=%' and rt.availability <> 100

select n.caption, rt.* from ResponseTime_Daily rt join Nodes n on rt.nodeid=n.nodeid
where n.caption like '%V=%' and rt.percentloss <> 0

update ResponseTime_Detail
SET Availability=100
--select * from ResponseTime_Detail
where availability <> 100 and NodeID IN (select DISTINCT (rt.NodeID) from ResponseTime_Detail rt join Nodes n on rt.nodeid=n.nodeid
where n.caption like '%V=%')

update ResponseTime_Hourly
SET Availability=100
--select * from ResponseTime_Hourly
where availability <> 100 and NodeID IN (select DISTINCT (rt.NodeID) from ResponseTime_Hourly rt join Nodes n on rt.nodeid=n.nodeid
where n.caption like '%V=%')

update ResponseTime_Daily
SET Availability=100
--select * from ResponseTime_Daily
where availability <> 100 and NodeID IN (select DISTINCT (rt.NodeID) from ResponseTime_Daily rt join Nodes n on rt.nodeid=n.nodeid
where n.caption like '%V=%')

select * from ResponseTime_Hourly r join Nodes n on r.NodeID=n.nodeid
where n.caption like '%V=%' and r.Availability <> 100

kennes913

Hi mike,

Let us know how njoylif's solution works out for you.