Reporting Services 本地使用情况跟踪

可能有更好的方法来编写它，但它可以让您非常接近跟踪所有报告的本地使用情况 - SSRS 和 Power BI

declare @results TABLE
(
    Report  NVARCHAR(50),
    ExecutionTime DATETIME,
    UserName NVARCHAR(25),
    ExecutionId NVARCHAR(50)
)


INSERT INTO @results 
SELECT
       Name,
       TimeStart,
       UserName,
       ExecutionId
  FROM (SELECT TimeStart,
               Catalog.Name,
               UserName,
               ExecutionId
          FROM Catalog
               INNER JOIN 
               ExecutionLog3
                 ON Catalog.Path = ExecutionLog3.ItemPath
         WHERE Type IN (2) --ssrs
       ) AS RE
UNION ALL
    SELECT 
       Name,
       TimeStart,
        UserName,
        ExecutionId
  FROM (SELECT  TimeStart,
               Catalog.Type,
               Catalog.Name,
                UserName,
                ExecutionId
          FROM Catalog
               INNER JOIN 
               ExecutionLog3
                 ON Catalog.Path = ExecutionLog3.ItemPath
         WHERE Type IN (13) --power BI
         AND ItemAction = 'ConceptualSchema'
         AND Format = 'PBIX'
       ) AS RE
       Order By TimeStart DESC

;WITH cte AS
(
   SELECT *,
         ROW_NUMBER() OVER (PARTITION BY ExecutionId ORDER BY ExecutionTime DESC) AS rn
   FROM @results
)
SELECT
Report,
ExecutionTime,
UserName
FROM cte
WHERE rn = 1
ORDER BY ExecutionTime DESC