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
