script to find the frequent used login information in the sql

Question

script to find the frequent used login information in the sql

pols

SSC Eights!

Points: 935
More actions
March 27, 2023 at 2:51 pm

#4165557

Hi,
Kindly some one share the script or query to get the login information used for the sql database in the instance.
InstanceName,DatabaseName,HostName,LoginName,Program,date used etc
Thanks,
Jo

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

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

I would use "sp_whoisactive" and store this in a table frequently, have a job to run it every 10 seconds or so to capture what you need and then you can report on it.

http://whoisactive.com/docs/25_capturing/

Other wise you're into extended event for the LOGIN event or server side logon triggers.

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 2

pols wrote:

Hi,
Kindly some one share the script or query to get the login information used for the sql database in the instance.
InstanceName,DatabaseName,HostName,LoginName,Program,date used etc
Thanks,
Jo

Why? What actual problem are you trying to solve?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

have a look at "Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events"

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me