2 Replies Latest reply on Nov 16, 2016 5:08 PM by Nigel Howard

    Where Are Current Computer Statuses Stored in Database

    Torran Kahleck Newbie

      We're working on a custom application that would display current computer availabilities for our labs across campus and we're hoping to tap into the Pharos SignUp data to determine whether or not a computer is in use. We know this data must exist since the NerveCenter is able to display it. However, I've been searching through the Pharos database, but haven't been able to find active computer statuses. Transactions don't seem to be entered into the database until after a person signs out, which makes some sense, and the active field in the computers table seems to be unrelated as all the computers always seem to be marked as active. Still, if anyone else has tried this and had success in tracking down this data, it'd be great to hear where you found it.


      Also, if there is developer documentation that might help me out with this, I'd be very grateful for a reference.

        • Re: Where Are Current Computer Statuses Stored in Database
          bdickens@pharos.com Scout

          Hi Torran,


          As you have determined already, there is no database record of the SignUp computers live status. The SignUp Server service is responsible for keeping track of the computers in real time. The service does a status check of the computer every 10 minutes. The Nerve Center gets its updates regarding computer status from the SignUp Server service directly. While this is not helpful to your cause, it should give you an idea how the system operates. Maybe there are others out there that have found a successful way to track the computer status.

          1 of 1 people found this helpful
          • Re: Where Are Current Computer Statuses Stored in Database
            Nigel Howard Wayfarer


            We have exactly the same requirement as you.  We're building a new library in Christchurch, New Zealand with five floors.  We have decided that the best way to configure this building is to have a separate queue per floor & offer customers some form of additional information regarding utilisation on each floor.  This way customers can either book on the floor they are currently located on or check the availability on other floors.  There is currently no facility in Pharos that gives us this information, so we are thinking of writing some code to read the queues on each floor & derive the business & queue length from the queue web page for each floor.  This has some disadvantages as it doesn't give any indication of the current utilisation of the PCs at that location, just the queue length.  What we really need is a way to request the Nerve Centre home page/Status Summary for each branch & parse out the Idle/Assigned/Disabled/Faulty information programmatically.


            Pharos: This would be a great feature to be able to display the utilisation of selected branches on the queue screen.