Post reply

Identifying inactive users

  • October 21, 2003 at 10:05 am

    #160887

    Hi,

    Is there a way to identify inactive users on the server to disable them. For instance, user that have not logged on to SQL Server since 60 days or so.

    Thanks

    Pranav

  • October 21, 2003 at 10:07 am

    #478976

    That kind of information is not stored within SQL Server. You'd have to run traces (audit login) or something similar and parse the results over time.

    K. Brian Kelley

    http://www.truthsolutions.com/

    Author: Start to Finish Guide to SQL Server Performance Monitoring

    http://www.netimpress.com/

    K. Brian Kelley
    @kbriankelley

  • October 23, 2003 at 8:23 am

    #479308

    You might try turning on Audit Level logging to ALL, and then reviewing 60 days worth of SQL Server logs to determine the logins that have logged in, then this would give you those logins that did log on. Just another opportunity to write a homegrown solution.

    Gregory A. Larsen, DBA

    Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:qa.sqlservercentral.com/bestof/purchase.asp

    Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • October 28, 2003 at 1:10 pm

    #479972

    Thanks for both replies !! I applied both the solutions and created a stored proc to identify inactive logins.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply