Get User Download Log From Sql Server

[alexyin1053]

Dear all,

Currenly we're running PBIRS on our local server. We would like to track our user's download log from the sql server.

Example:

TimeStamp	UserName	ObjectName	TypeName	Path	IP
2024-08-10	Alex	CustomerProfile	PBIReport	/DeptA/CustomerAll/Customer	175.75.10.51
2024-08-15	Alice	Purchase_1M	PBIReport	/DeptA/PurchaseAll/Purchase_1M	175.75.25.55
2024-08-17	Amber	PurchaseAll	Folder	/DeptA/PurchaseAll	175.75.30.52

Thanks!

Best Regards,

Alex

[v-yohua-msft · Accepted solution]

Hi, @alexyin1053 

You may be able to use SSMS's Profiler tool to track your users' downloads.

You can learn more from the following link:

SQL Server Profiler - SQL Server Profiler | Microsoft Learn

SQL Server Profiler extension - Azure Data Studio | Microsoft Learn

Use SQL Server Profiler to Monitor Analysis Services | Microsoft Learn

Or you can view the logs directly

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[R1k91 · Accepted solution]

have you already looked to [ReportServer].[dbo].[ExecutionLog3] system view?

[v-yohua-msft · Accepted solution]

Hi, @alexyin1053 

You may be able to use SSMS's Profiler tool to track your users' downloads.

You can learn more from the following link:

SQL Server Profiler - SQL Server Profiler | Microsoft Learn

SQL Server Profiler extension - Azure Data Studio | Microsoft Learn

Use SQL Server Profiler to Monitor Analysis Services | Microsoft Learn

Or you can view the logs directly

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.