Command: ExportSnapshot

 

Export Report and linked report snapshots.

 

SSRS Version:

 

2000, 2005 (N), 2005 (I), 2008 (N), 2008 (I),2008r2(N), 2008r2(I), 2012(N), 2012(I), Azure

 

(N)=Native

(I)=Integrated

 

Syntax

 

ExportSnapshot   Folder|Report /F:Folder [/O] [/BS] [/S] /R:Render [/L|/E/I:ID|/D:DATE

ExportSnapshot   [/?] displays help

 

 

 

 

 

Parameters

 

   Folder             Name of the folder on SSRS Server

   /F:Folder          Folder location to export report snapshots

   [/O]               Overwrite file if it exists

   [/S]               Include sub folders

   /R:Render          Render format eg Excel

   [/BS]              Export Snapshot file format ReportName-SnapshotID

                      If not specified the file format is SnapshotID-ReportName

   [/L]               Export only Latest snapshot

   [/E]               Export only Earliest snapshot

   [/I:=ID]           Export only snapshot ID

   [/I:>ID]           Export only snapshot later than ID

   [/I:<ID]           Export only snapshots before ID

   [/D:=DATE]         Export only snapshot DATE

   [/D:>DATE]         Export only snapshot later than DATE

   [/D:<DATE]         Export only snapshots before DATE

 

 

 

Examples

 

Export snapshots as Excel files from the folder \sales on the report server to the folder c:\SSRS

 

Exportsnapshot \sales /f:c:\ssrs /r:excel

 

 

as above including sub folders

 

Exportsnapshot \sales /f:c:\ssrs /r:excel /s

 

 

Remarks

 

•Use the command GetExtensions to get list of valid rendering extensions

•Evaluation version only exports 1 snapshot per report.

•Remember to enclose /D:Date in quotes eg /d:">2012-08-30 22:00:00"          = 10pm 30th August 2012

 

 

See Also

 

 

GetExtensions        - List rendering extension