US - Wisconsin (Milwaukee)

User Activity "dashboard" script 

Dec 09, 2015 10:43 AM

This is the script I run every day and refresh during the day to show me what our GP users are up to. Run it in SQL Server Management Studio or in a SQL utility (I use LINQPad -- highly recommended!) to see the output of all 8 queries. Source code is commented to show what each query does.

#Technical #Admin #System Administrator #Security #SQL Server

Statistics
1 Favorited
35 Views
1 Files
0 Shares
67 Downloads
Attachment(s)
txt file
SQL script for a User Activity "dashboard"   8K   1 version
Uploaded - Dec 09, 2015
Simply change the file name extension to "SQL" and run it in SQL Server Management Studio (or LINQPad!). GPUG.com requires this file to be TXT, not SQL.

Related Entries and Links

No Related Resource entered.