4 Replies Latest reply on Aug 25, 2011 10:54 AM by kennes913

    Editing Orion SQL tables

    mikefarn

      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

        • Re: Editing Orion SQL tables
          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.

            • Re: Editing Orion SQL tables
              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 ...

                • Re: Editing Orion SQL tables
                  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

              • Re: Editing Orion SQL tables

                Hi mike,

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