Forum Discussion
Get User Download Log From Sql Server
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
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.
have you already looked to [ReportServer].[dbo].[ExecutionLog3] system view?
2 Replies
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.
have you already looked to [ReportServer].[dbo].[ExecutionLog3] system view?