envwhologin

Snippet Name: envwhologin

Tags: Connection Activity

Created Date: Oct 1 2021 8:05AM
Last Modified Date: Oct 1 2021 8:05AM

–desc: activity by one specific user

Dependencies: This snippet assumes you have installed Adam Machanic’s sp_whoisactive, and leverages some parameters or techniques to drill down into a specific scope.

default description

Sample Output:

 
 {C}
 
 --desc: activity by one specific user
 
 DECLARE @lg varchar(128) = suser_name() -- 'shcr\adm.lowell.izaguirre'
 
 EXECUTE sp_whoisactive 
 
   @filter_type='login',
 
   @filter= @lg,
 
   @get_outer_command=1,
 
   @get_full_inner_text=1