script to find the frequent used login information in the sql
-
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
-
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.
- 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) -
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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply