How to find the report name along with reportID

• klnsuddu

  SSCertifiable

  Points: 5836

  More actions

  February 26, 2010 at 1:06 pm

  #139133

  Hi,

  Hi ran the below query and wants to know the report name along with please advice

  use ReportServer

  select * from ExecutionLog order by TimeStart DESC

  Results:

  InstanceNmae ReportId UserName Format Parameters

  SQLRS77277A1E-F6F7-4F3F-ACFA-8C155E1C277Aabc\scott0EXCELNULL

  TimeStart TimeEnd

  2010-02-26 08:25:51.1002010-02-26 08:26:04.7900159135291rsSuccess3039390

• eesha

  SSC Rookie

  Points: 43

  More actions

  February 26, 2010 at 2:13 pm

  #1125825

  Join the Catalog table (itemID)