I like to answer all questions but before that I like to thank each one for their feedback and also mention that this tool is meant to be very simple to run and give administrators and IT support an easy way to monitor scheduled reports.
Yes it is possible to add prompt for folder/category. For folder you have to first get the ID or CUID and add one of the following to the infostore query: SI_PARENT_FOLDER= or SI_PARENT_FOLDER_CUID=
For Categories, it is more complicated as a report may belong to multiple categories. SI_CORPORATE_CATEGORIES and SI_PERSONAL_CATEGORIES properties of the infoobject can give you that information.
Notifications property of SchedulingInfo can tell you if notification is set or no.
As for calendar, CalendarTemplate property of SchedulingInfo holds the id of the calendar used. You will have to query infostore again to find out name and any other info about that.
Duration is in minutes.
Prompts are part of ProcessingInfo Objects. However, since a report can have multiple prompts which can hold multiple values, it will be very difficult to display those on a spreadsheet.
rachidb (BOB member since 2006-07-06)