I can't find it in server admin. Must I just check the 80% warning and that is all I can do? I want to know my max and maybe even average users. fms16
Under the General Settings sidebar, there is a tab called "Connections".
The max number of concurrent connections is listed under here in bold text, as well as the ability to swap/upgrade license keys.
Oh, sorry, I want to know the actual, in-use, connections. I'm trying to determine my users access.
Well, you will still need that number to calculate it, but you can just go to the activity sidebar and click on the "clients" tab to switch between showing the files you are hosting, to the users that are connected.
There is a column that shows you what client each connected user is using. WebDirect and FileMaker Go client connections count against the maximum. So for example if you see 10 users connected via those two methods and you have licensing for 25 maximum concurrent connections, you can calculate that you are using 40% of your connections.
This is also the same place where you would go to disconnect any stuck users and monitor to see if any users are leaving very long connections open.
I was hoping for a more hands-off method. I wanted a running count that the server would calc and display somewhere in the server admin.
Both FileMaker Cloud and FileMaker Server 17's admin console have a little more in terms of a "dashboard" for at-a-glance performance. Here is a screenshot from FileMaker Cloud 1.16
Server 16 is the last version to use the java driven admin console, the new Cloud/FMS17 dashboards use a Node.JS interface that is more geared towards "autonomous/hands-off" administration. These new versions also come with the Admin API, which you can use to setup your own dashboards that interface with the server.
If you don't want to upgrade or switchover to FMCloud, then the way to "automate" those statistics is usually by running a batch file via command line FMSADMIN commands, much more difficult to get into than the above manual method of tallying.
Indeed, I run several batch files now. For 17, just waiting a bit to field it so the big bugs are worked out. Thanks again.
No, there has not been a max or average for some time, and it makes it tough to estimate the peak number of users. We had to estimate to help clients determine new User vs Concurrent connections, and wish we had this particular feature back.
Sadly, there are two methods we used: watch during what you believe is the busiest day and time, or download statistics and write your own code to determine concurrent use.
Ugh, I was afraid of that. Thx
Well, coincidentally regarding 17:
FileMaker Server 17.0.2 now available
Basically how we did it in <= 16 was setup a windows task that would just repeat every x minutes and run an fmsadmin command to push the resulting information to a file, then run another script (EG php/python) that would "parse" that file into a database somewhere. Unfortunately the work I've done for that is under a strict NDA so I can't share.
Understood and I sense the hard work behind it. I'll shelve this for now.
in a batch / vbscript / powershell / applescript / bash file you can simply do an
fmsadmin list clients
and count the lines in the result
If Mac OS X:
Write a cron (see Terminal 101 link below if you haven't done this before)
* * * * * /Library/FileMaker\ Server/Database\ Server/bin/fmsadmin list clients -u USERNAME -p PASSWORD >> /tmp/fms_users.txt
or anything similar. The cron appears to need the full path. You cron timing (this one is every minute) and output can be anywhere of course.
>> will append the file, and you can import into FileMaker to report on the user count.
I used Terminal 101 link to get started. The only problem I had was getting the proper path to fmsadmin, which on FMS17 was as above.
Simple cron example - SaltyCrane Blog
Terminal 101: Creating Cron Jobs | TechRadar
Yes, yes and one day I may... w/bash & perl — old school
* * * * * /Library/FileMaker\ Server/Database\ Server/bin/fmsadmin list clients -u USERNAME -p PASSWORD > /tmp/fms_users.txt ; sleep 10 ; wc -l < /tmp/fms_users.txt >> /tmp/fms_count.txt
In case anyone wanted a running list of user counts along with the list of names. Subtract 1 from each non-zero row count to ignore header.
Retrieving data ...