Page 1 of 1
Monitoring Open Files with ADS
Posted: Wed Feb 24, 2016 11:14 am
by Tim K
In Microsoft Server, ADS seems to render Console 1 useless for identifying who has files open. I see in the Advantage configuration utility it shows that there are files open but they are anonymous. Is there a simple way to monitor who has files open while using free tables?
Re: Monitoring Open Files with ADS
Posted: Wed Feb 24, 2016 1:04 pm
by Cliff Wiernik
Use the Advantage Database Architect. It tells you what users are connect, what IP address, if from terminal server, both that address and local workstation address. What files are opened. If you go to what files are opened, it will show you the user's login name. Login name is also shown on users connected listing.
This utility, written in delphi by Sysbase/Extended/SAP, is updated regularly, used to setup and configure data dictionaries, and also provides alot of the information that is in the advantage configuration utility.
We use it all the time and it can also be used to forceably disconnect users.
Some of the information can also be provided via the Xbase++ ADS sample programs, but do not work as good as this.
Cliff
Re: Monitoring Open Files with ADS
Posted: Thu Feb 25, 2016 10:28 am
by Tim K
Thanks, Cliff. That works great.