Post reply

query needed

  • December 1, 2015 at 4:56 am

    #399408

    I need to find the number of users hit on a database from last month ?

  • December 1, 2015 at 5:10 am

    #1843142

    If you have custom monitoring, query those tables. If you don't, then you won't be getting that info.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 1, 2015 at 5:12 am

    #1843143

    can provide an sample query to get the info

  • December 1, 2015 at 5:21 am

    #1843149

    I think you may have misread my answer.

    If you have some custom monitoring that tracks users, then you will query whatever tables that custom monitoring writes to. If you have custom monitoring, then you'd know what tables are involved because you would have written that monitoring.

    If you do not have some custom monitoring that tracks users, then you *are not* going to get the information you want because SQL does not track it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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