Including time stamp in subscription report file name


Operations Manager Report subscription wizard asks you to specify a File Name when you choose Windows File Share delivery method. In most cases where you just need to have a most recent report delivered to the share you would just type a desired name in the field and look for the result then the time comes. If you would like to keep the history though, you would probably want to include something like a time stamp in the file name to keep the names unique and prevent reporting server overriding the results every time a new report is generated. To do the trick you can add @timestamp variable to the File name. For example: Report@timestamp. The resulted file name will look something like Report2009_10_05_000000 which would not only allow you to keep the names unique but would also give everyone an immediate idea on when the file was generated.


Read more about File Share Delivery in SQL Reporting Services documentation.

Comments (4)

  1. Michael Vincent Waller says:

    How do you add different parameters (inside the report) i.e. @RunDate  (inside the File name) rather than @timestamp ?

  2. eugenebykov says:

    @timestamp is the only variable allowed in in the subscription file names. You can read more about it here: msdn.microsoft.com/…/ms159264(SQL.90).aspx

    If you want to change the way name is generated your best alternative is probably creating a data driven subscription. We do not support them in SCOM console but you can create in manage them directly in SSRS Report Manager.

    Here you can fine more information about Data Driven subscriptions: msdn.microsoft.com/…/ms159150(SQL.90).aspx

  3. Balram says:

    How do you get the FileName from the ReportServer Database that is being Subscribed as ReportName@timestamp. I wanted to know the Actual File Name that gets stored in the Windows Network shared location. If you Query the Subsriptions Table then we will be getting the FileName as ReportName@timestamp.

  4. Aljo says:

    Hi Balram,

    Have a look at the catalog table in reportserver.