Post reply

Help with Activity Monitar

  • July 2, 2010 at 10:28 am

    #139621

    Hi Guys,

    I need to learn how to find out what report is being run and who is running that in SSRS.

    When i look into activity manager, i don't see the User Name. All i can see is, many rows with suspended status with same ProcessID and application as .netsqlclintapplication.

    I need to find out the details of that process (what was the name of the report ? what was the login name? etc)

    We have stored Credentials securely in the report server datasource, so i can not see the actual person's user name who was running it.

    All i see is login name i have saved in report server as credentials.

    I have run sp_who 'spid' , sp_who2 'spid' ,select * from master..sysprocesses etc commands too, but still does not show the user name.

    How can i find this information? I appreciate your help. I have attached a screenshot to explain things better.

  • July 3, 2010 at 9:47 am

    #1188527

    Seems like noone is willing to help me :crying:

  • July 3, 2010 at 5:05 pm

    #1188583

    Hi,

    Have you tried querying the ExecutionLog table in the ReportServer database?

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • July 4, 2010 at 4:00 pm

    #1188636

    Seems like some people don't want help....:-P (joking)

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • July 4, 2010 at 6:32 pm

    #1188650

    Thanks Mister Magoo.

    No it's not like that, i was just enjoying my July 4th weekend, so did not bother about activity monitor and this forum. :blink:

    ExecutionLog table gives you the following information and i do not see any column which i can correlate with activity monitor. I can see who ran which report and when from executionlog table, but there will be hundreds of user who will be running reports and i won't know which execution log record belongs to the SPID i am after :-D.

    May be there is a way but i just don't know.....

    Execution log gives you following information:

    [InstanceName],

    [ReportID],

    [UserName],

    [RequestType],

    [Format],

    [Parameters],

    [TimeStart] ,

    [TimeEnd],

    [TimeDataRetrieval],

    [TimeProcessing],

    [TimeRendering],

    [Source],

    [Status],

    [ByteCount],

    [RowCount]

  • July 5, 2010 at 5:34 pm

    #1188908

    Ah right I see the problem now...and sorry I don't have an answer to that and I don't have a working Report Server to hand to have dabble...sorry.

    MM


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
    • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
    • [/url]
  • How to Post Performance Problems - by Gail Shaw
    • [/url]

  • July 6, 2010 at 2:01 pm

    #1189313

    try this...

    select

    [cpu],

    spid,

    loginame, hostname,

    master.dbo.sysprocesses.[dbid],

    sys.databases.name,

    login_time, last_Batch,

    blocked, waittype, waittime, lastwaittype, waitresource,

    sql_handle, -- can be used to eventually get query plan

    T.TEXT,

    [uid], physical_io, memusage, ecid, open_tran, status, sid, hostname, program_name, hostprocess, cmd, nt_domain, nt_username, net_address, net_library, stmt_start, stmt_end, request_id

    frommaster.dbo.sysprocesses

    inner joinsys.databases on sys.databases.database_id = [dbid]

    cross apply sys.dm_exec_sql_text(sql_handle) t

    --where hostname in ('reportserv2','sqlserv'_

    order by cpu desc

  • July 7, 2010 at 8:51 am

    #1189662

    Hi Grasshopper,

    Thanks for your help.

    This is infact very useful, becasue it even gives me text.

    I tested it and it still shows the user name we have stored securely in report server, not the actual user who ran the report. But thank you very much for your help...

    I have one question :

    What is net_address?

    Thanks

    PP

  • July 7, 2010 at 11:01 am

    #1189753

    It is the physical address of the hardware on the network, what/where the connection is coming from/initiated.

    glad to help

  • July 10, 2010 at 3:02 pm

    #1191168

    It's so funny .......i thought grasshopper is a name.

    Sorry izdede.

  • July 12, 2010 at 7:04 am

    #1191438

    😀

    ha-ha. i noticed, no problem. izdede is actually my username and not my name either. Guess i need to fill out the profile on this website, huh 😀 ?

    • Viewing 11 posts - 1 through 10 (of 10 total)

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