question

ppickup avatar image
ppickup asked

Confidential Data in SSRS -- Snapshots

Does anybody know where the results of queries are stored in SSRS? I am referring to the actual data that is stored in a snapshot. Is it stored in some tables in the ReportServer or ReportServerTempDB database?

Origin of the question: The database we are reporting on contains PHI (Protected Health Information). I want to know if ReportServer or ReportServerTempDB can contain PHI. And if so what tables would they be in? I know that when you create a snapshot in SSRS the results of the query are saved so you do not need to run that long-running query again. But where exactly are the results of that query saved.

ssrssecuritysnapshot
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

I haven't got a active SSRS instance to check against at the moment, but I believe the data is split over a number of tables -

ReportServer.dbo.SnapShotData,

ReportServer.dbo.ChunkData,

ReportServer.dbo.SegmentedChunk

and maybe others. Not sure if these are human-readable though, but start here and see if you can recognise your data in them.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.