Hey mikael; You are right on both counts: remembering user ID numbers and alphabetical listings.
There are two ways to list all users from all groups -- but if as you say you have 10 groups but (what you didn't say) each has one thousand users, you might not want to do this -- in the SQL tools you can type the word "any" into the "User" search box or select the 'all users in all groups' radio button and press "SQL Tool". This will list every user from every group (clientID). You can search by either User Name or User ID number (user_idnr). The former is what you would likely be doing in most cases. All displays alphabetically list the user's name whether its a user list or an alias list. From there all you need do is click on the user to open the account. In most cases I suspect you would know the user name and would search that. You can check out the demo at http://library.mobrien.com/dbmailadministrator/ and see how it works. best... Mike >Hey, >Havent looked much at it yet, but it looks cool. >One thing that comes to my mind, if u have like 10 groups, it aint easy >to remember all of them by numbers, can't it be listet with names or ?some like that..... // ouT M. J. [Mike] O'Brien wrote: >Hello All: > >A standalone SQL light version of DbMail Administrator (DBMA) is available >for download along with the full version which has been somewhat upgraded. > >The new standalone Light SQL variant is a single script which can be >configured for PostgreSQL or MySQL and run from any host including a Win32 >(Windows) box. PERL modules DBI and the corresponding DBD::MySQL or DBD::Pg >modules are of course required. > >This is a great way to run a remote DbMail Administrative access from any >host across your LAN via TCP to your DbMail xxSQL database. Perfect for a >helpdesk too. > >The full version which needs to be run from a DbMail host uses integrated >SQL commands / queries and DbMail system tool calls to provide an extensive >range of simple and complex Administrative functions. > >Download either or both the Full or SQL Light versions from >http://library.mobrien.com/dbmailadministrator/ > >Please keep the feedback coming. > >Many happy days to all... >Mike
