1

Hi Guys and Gals,

I have created a report within Spiceworks designed to show me all tickets closed after X date. I have to change this date each time before i run the report.

Does Spiceworks have the functionality to allow me to set this report up to prompt me for the date each time i hit the run button rather than having to re-configure the report each time and then run?

thanks

Lewis

1 Spice up
2

Have a look at this report (SQL) and feel free to modify it for your needs.

3

“Have a look at this report (SQL) and feel free to modify it for your needs”

Are you saying take a look at SQL or have i missed a link to a report?

4

Sorry, I forgot the link: http://community.spiceworks.com/reports/9

I`m not sure if it is a SQL report.

5

Maybe this is also helpful: http://community.spiceworks.com/help/Sharing_Report_Definitions

6

Thanks for the heads up bytesnake.

Lewis1162,

Any chance that what you really looking for is a report for closed tickets over the last X days (10/20/30…) and not just after specific date?

IS so - then this can be achieved with a simple SQL code, if it must be specific date then the only option is to edit the report before you run it.

7

Lewis,

As Yasaf and Bytesnake mentioned, you can create a custom SQL report to do this. If you are having issues creating the report, feel free to send an email to support@spiceworks.com or post a thread within the SQL group and someone should be able to help you write that query.