03-14-2019 03:38 AM
Is there a SQL table or tables I can query to get all the servers associated with our Onbase implementation. That query would not only be helpful in our Production environment but I also want to run it in our Disaster Recovery complement of servers to see if we are configured correctly for a potential fail over. We have a simulation of this coming up in a couple of months so it would be extremely helpful!
03-14-2019 04:52 AM
I use the 'registeredusers' table. Fields registernum and registername. Link to the LOG to determine what machine was doing the action.
03-15-2019 01:49 PM
That's great! I am looking at these tables registeredusers, regusersproducts and productsold.producttype and getting some good info. I am not sure which log you are referring to, to get the action. The transaction log? Also I got to believe the database has specific information on which server performs say workflow as that would be needed when clicking on the workflow button in the client etc. Thanks!
03-15-2019 05:30 AM
That's great! I am looking at these tables registeredusers, regusersproducts and productsold.producttype and getting some good info. I am not sure which log you are referring to, to get the action. The transaction log? Also I got to believe the database has specific information on which server performs say workflow as that would be needed when clicking on the workflow button in the client etc. Thanks!
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.