https://community.fabric.microsoft.com/t5/Report-Server/Get-User-Download-Log-From-Sql-Server/m-p/4118085#M36529 <P>have you already looked to&nbsp;[ReportServer].[dbo].[ExecutionLog3] system view?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 26 Aug 2024 07:43:57 GMT R1k91 2024-08-26T07:43:57Z https://community.fabric.microsoft.com/t5/Report-Server/Get-User-Download-Log-From-Sql-Server/m-p/4112499#M36513 <P>Dear all,</P><P>&nbsp;</P><P>Currenly we're running PBIRS on our local server. We would like to track our user's download log from the sql server.</P><P>&nbsp;</P><P>Example:</P><TABLE border="1"><TBODY><TR><TD>TimeStamp</TD><TD>UserName</TD><TD>ObjectName</TD><TD>TypeName</TD><TD>Path</TD><TD>IP</TD></TR><TR><TD>2024-08-10</TD><TD>Alex</TD><TD>CustomerProfile</TD><TD>PBIReport</TD><TD>/DeptA/CustomerAll/Customer</TD><TD>175.75.10.51</TD></TR><TR><TD>2024-08-15</TD><TD>Alice</TD><TD>Purchase_1M</TD><TD>PBIReport</TD><TD>/DeptA/PurchaseAll/Purchase_1M</TD><TD>175.75.25.55</TD></TR><TR><TD>2024-08-17</TD><TD>Amber</TD><TD>PurchaseAll</TD><TD>Folder</TD><TD>/DeptA/PurchaseAll</TD><TD>175.75.30.52</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P><P>Best Regards,</P><P>Alex</P> Thu, 22 Aug 2024 03:51:12 GMT https://community.fabric.microsoft.com/t5/Report-Server/Get-User-Download-Log-From-Sql-Server/m-p/4112499#M36513 alexyin1053 2024-08-22T03:51:12Z https://community.fabric.microsoft.com/t5/Report-Server/Get-User-Download-Log-From-Sql-Server/m-p/4114782#M36523 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="727376" data-lia-user-login="alexyin1053" class="lia-mention lia-mention-user">alexyin1053</a>&nbsp;</P> <P>You may be able to use SSMS's Profiler tool to track your users' downloads.</P> <P><img /></P> <P>You can learn more from the following link:</P> <P><A href="https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver16" target="_blank">SQL Server Profiler - SQL Server Profiler | Microsoft Learn</A></P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/azure-data-studio/extensions/sql-server-profiler-extension" target="_blank">SQL Server Profiler extension - Azure Data Studio | Microsoft Learn</A></P> <P>&nbsp;</P> <P><A href="https://learn.microsoft.com/en-us/analysis-services/instances/use-sql-server-profiler-to-monitor-analysis-services?view=asallproducts-allversions" target="_blank">Use SQL Server Profiler to Monitor Analysis Services | Microsoft Learn</A></P> <P>&nbsp;</P> <P>Or you can view the logs directly</P> <P><img /></P> <P>&nbsp;</P> <P><SPAN><A title="https://community.powerbi.com/t5/community-blog/how-to-get-your-question-answered-quickly/ba-p/38490" href="https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.powerbi.com%2Ft5%2FCommunity-Blog%2FHow-to-Get-Your-Question-Answered-Quickly%2Fba-p%2F38490&amp;data=05%7C02%7Cv-yohua%40microsoft.com%7Ce1106bfabecb4734a5cc08dc2305bc51%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638423754744679080%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&amp;sdata=24%2BceC5sFd3n3%2FhFDYILWFcNjCwVClBD%2BPBsSLVfJGk%3D&amp;reserved=0" target="_blank" rel="noopener nofollow noreferrer">How to Get Your Question Answered Quickly</A></SPAN></P> <P><SPAN>Best Regards</SPAN></P> <P><SPAN>Yongkang Hua</SPAN></P> <P><SPAN>If this post&nbsp;<STRONG>helps</STRONG>, then please consider&nbsp;<STRONG>Accept it as the solution</STRONG>&nbsp;to help the other members find it more quickly.</SPAN></P> <P>&nbsp;</P> Fri, 23 Aug 2024 03:21:24 GMT https://community.fabric.microsoft.com/t5/Report-Server/Get-User-Download-Log-From-Sql-Server/m-p/4114782#M36523 Anonymous 2024-08-23T03:21:24Z https://community.fabric.microsoft.com/t5/Report-Server/Get-User-Download-Log-From-Sql-Server/m-p/4118085#M36529 <P>have you already looked to&nbsp;[ReportServer].[dbo].[ExecutionLog3] system view?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 26 Aug 2024 07:43:57 GMT https://community.fabric.microsoft.com/t5/Report-Server/Get-User-Download-Log-From-Sql-Server/m-p/4118085#M36529 R1k91 2024-08-26T07:43:57Z