Extract Upload information from on-premises PBI Report Server

[Anonymous]

Is there a way to find out when a user uploads a report to an on-premises PBI Report Server?

Thank you,

Sara

[saykasku]

Hi,

You can try this on ReportServer database.

SELECT c.[Path]
      ,c.[Name]
	  ,u.[UserName]
	  ,c.[CreationDate]
  FROM [ReportServer].[dbo].[Catalog] c
  inner join [ReportServer].[dbo].[Users] u
	on c.CreatedByID = u.UserID

When and who create report.

[d_gosbell]

Or you could do a similar thing using the Powershell module https://github.com/Microsoft/ReportingServicesTools/ (or the web api's). Technically Microsoft does not support directly querying the database. If your queries get more complex they can potentially cause blocking which could interfere with the normal operation of the service.