Post reply

sp_whoisactive filtering

  • June 14, 2024 at 4:18 am

    #4428369

    I am experiencing difficulty filtering the results in the sp_whoisactive stored procedure when attempting to apply multiple filters. Can someone please provide assistance or guidance?

    Attachments:
    You must be logged in to view attached files.

  • June 15, 2024 at 5:10 am

    #4428626

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • June 19, 2024 at 8:20 am

    #4429631

    any updates from anyone?

  • June 19, 2024 at 8:34 am

    #4429634

    Not a direct solution, but have you considered creating a temp table to hold the results of running sp_whoisactive, then doing an

    INSERT #SomeTable
    EXEC sp_whoisactive

    followed by whatever filtering you require? If it's something you do often, assign the entire thing to a KB shortcut.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • October 7, 2024 at 6:05 pm

    #4466119

    I have a similar (same) issue.

    It says on the online docs that the filters are 'additive' but when I try to filter on 2 values it errors.

    I want to ONLY see SPIDs from a specific HOST with a specific LOGIN - but I can't seem to do that.

    Adding two filters in the exec generates an error because I specify the @filtertype twice with the 2 different values.

    So what does 'additive' mean - can you specify multiple filters for the same filter type but not multiple filter types maybe?

     

  • October 7, 2024 at 6:25 pm

    #4466121

    sp_whoisactive: Capturing the Output

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

    I think that this shows why Phil's suggestion won't work sadly but may provide a solution for me.

     

Viewing 6 posts - 1 through 5 (of 5 total)

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