Results 1 to 3 of 3

Thread: [SOLVED] Inactive Accounts Criteria?

  1. #1
    Join Date
    Dec 2007
    Posts
    2
    Rep Power
    7

    Default [SOLVED] Inactive Accounts Criteria?

    I need to cull my accounts. Large amounts of my users use outlook express and other pop3 clients. Does the inactive accounts query count logins via pop3, imap, and web? Or just the web interface?

    If it only counts web interface logins. Is there any way to list users who have not logged in via any interface in the last 6mo's?

    Update: I found old account on the server of mine that I had forgotten about, it's last login was the date of the server migration. I accesses via outlook express, it changed the last login.
    Now.. I just upgraded from 5.02 to 5.09 a week ago. Like so many other things I have noticed, is this something that was fixed or changed? Looking at the clients last login dates, it still is not clear, I am sure I have provided support for some of the addresses that are showing last login as the date of the migration (migration was from merik to zimbra last Feb)

    BTW I have never accualy posted, but I have to say.. My life has been way easier since the migration. We have 700 users on this server, Dual core P4 3Ghz, 4GB Ram, Dual 160GB SATA Raid 1, No real problems!

    Thank You
    Last edited by Headbang; 10-11-2008 at 05:40 PM.

  2. #2
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

    Default

    Welcome to the forums,

    Inactive (30 & 90) is based on the zimbraLastLogonTimestampFrequency (does include Web, IMAP, & POP), so to search in the admin console for inactive 6 months:
    Code:
    (zimbraLastLogonTimestamp<=20080411000000Z)
    The server will update the user's zimbraLastLogonTimestamp user attribute at most once every zimbraLastLogonTimestampFrequency.
    Default is 7d to cutdown on ldap writes every time you auth. You can set it to values like: 1d, 1h, 1m, 1s, or 0 for disabled:
    Code:
    zmprov mcf zimbraLastLogonTimestampFrequency 3d
    Think of the pure volume of some systems, updating an attribute for several million active users all day long makes for a lot of writes and replication. Prompted implementation of: Bug 18972 - provide way to completely disable zimbraLastLogonTimestamp (setting to 0).

    Your /opt/zimbra/log/audit.log is continuous anyways so you can always check that. There is a MYSQL database entry in zimbra.mailbox for last_soap_access (getLastSoapAccessTime) not ported to a LDAP value because that would be nuts.

    For some, 7 days does seem a little high though given the average installation size and faster systems. To that end, someone had an bugzilla entry in to get the default changed from 7d > 3d but I don't know what happened to it. If you have the time/ability for a large scale performance test go for it.

  3. #3
    Join Date
    Dec 2007
    Posts
    2
    Rep Power
    7

    Default

    Thank you for the quick reply! Just to be safe I am going to close the 175 inactive accounts and see who calls.

    This is going to free up around 60GB of HD space, allowing me to pospone an upgrade

Similar Threads

  1. Multiple Mail Accounts, Folders
    By skwdenyer in forum Users
    Replies: 12
    Last Post: 12-01-2013, 07:52 PM
  2. archiving disabled accounts
    By maumar in forum Administrators
    Replies: 4
    Last Post: 09-08-2008, 11:25 AM
  3. Inaccurate number accounts used
    By zbowden in forum Administrators
    Replies: 1
    Last Post: 12-10-2007, 05:47 AM
  4. Set Zimbra to Automatically Download from POP3 Accounts
    By dbachman in forum Administrators
    Replies: 1
    Last Post: 08-29-2007, 09:05 AM
  5. Mysql does not start on RHEL 64
    By cryptogram in forum Installation
    Replies: 11
    Last Post: 01-18-2007, 01:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •