Sorry didn't work for me - am I being dense? useraccounts was UserAccounts but...
mysql> select a.firstname, a.lastname from UserAccounts a, presence b where a.principalid = b.userid; ERROR 1146 (42S02): Table 'opensim.presence' doesn't exist On Fri, Mar 2, 2012 at 2:05 PM, Steven Salter <[email protected]> wrote: > This seemed to work for me: > > select a.firstname, a.lastname from useraccounts a, presence b where > a.principalid = b.userid > > > Steve > > On Mar 2, 2012, at 8:40 AM, Clive Gould wrote: > >> Hi >> >> Any idea what SQL query I need to use to find out how many users are logged >> in? >> >> I've tried the query on the page >> http://opensimulator.org/wiki/Useful_Queries and the table >> opensim.agents no longer exists in the database schema >> >> i.e. Count the number of users presently logged in (same issues as >> listing online users, above): >> SELECT count(UUID) AS 'Users Online' FROM opensim.agents WHERE >> agentonline = '1'; >> >> I've looked at the Online=TRUE in the opensim.GridUser table and this >> returns 21, whereas the console reports 9 agents online >> >> Any suggestions most welcome >> >> Thanks >> >> Clive >> >> P.S I've just freed up some memory on our server and upgraded to 0.7.3 >> and so far nothing has gone wrong >> _______________________________________________ >> Opensim-users mailing list >> [email protected] >> https://lists.berlios.de/mailman/listinfo/opensim-users > _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
