Share via

SQL Server Active Directory Logins

Ricardo Anselmo Oliveira 101 Reputation points
2022-03-17T17:39:39.173+00:00

Good afternoon,

I was wondering if someone could help me with a query:

  • I need to get the necessary information about the logins that are done through Active Directory, to then, in a pie chart, show the percentage of logins done with AD over the total logins.

I will be very grateful if someone can help me!

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,786 Reputation points
    2022-03-18T13:33:35.537+00:00

    That information does not exist in SQL Server as a default. You would have to create an audit or login trigger to log that information.

    Was this answer helpful?

    0 comments
  2. Olaf Helper 47,621 Reputation points
    2022-03-18T07:27:10.127+00:00

    I need to get the necessary information about the logins that are done through Active Directory, to then, in a pie chart, show the percentage of logins done with AD over the total logins.

    And what do you think you could get the informations from?

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.