vellezz.info

za pośrednictwem tabel Segment, ChunkSegmentMapping, SegmentedChunk i SessionData

SELECT sd.ReportPath, COUNT(s.SegmentId) as CountOfSegmentId
FROM [ReportServerTempDB].dbo.Segment s 
INNER JOIN  [ReportServerTempDB].dbo.ChunkSegmentMapping m ON  m.SegmentId = s.SegmentId
INNER JOIN [ReportServerTempDB].dbo.SegmentedChunk c ON c.ChunkId = m.ChunkId
INNER JOIN [ReportServerTempDB].dbo.SessionData sd 
ON sd.SnapshotDataID = c.SnapshotDataId 
GROUP BY sd.ReportPath
ORDER BY CountOfSegmentId DESC;