Post reply

Active and Inactive users

  • May 17, 2012 at 11:12 am

    #256648

    Can someone let me know how to find out the ACTIVE and INACTIVE users in DB. I am actually moving my database from one server to another server and would like to make a comparision of users who are active in another server. Please, help me with this solution. Thank you

  • May 17, 2012 at 11:22 am

    #1489241

    Unless you've been auditing the logins, there's no good way to tell. Nothing in the system, that I am aware of, can give you this information.

    Sorry.

    EDIT: On the other hand, if these are domain logins, you might be able to get activity stats from Active Directory. Or at least a last login date.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • May 17, 2012 at 11:26 am

    #1489247

    There is NO auditing on this database.

  • May 17, 2012 at 11:42 am

    #1489264

    If there's no auditing, then the only possible option is to look at Active Directory for those logins that are domain logins. If they're all SQL logins, there is nothing you can do but rename them and see if anything breaks.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • May 17, 2012 at 12:03 pm

    #1489281

    ok..thank you...

    I am actually working on moving a 3rd party company database to my environment. Initially they have give there DB in last january, now they made few more changes and sending us back with updated data, so I thought to restore onto my existing environment and remove the orphan logins and map the existing users to the existing db. So, In that process, I just got thought of wheter we have any active and inactive users.

Viewing 5 posts - 1 through 5 (of 5 total)

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