Report Viewer in Configuration Manager 2007 generates a unique URL for each report and dashboard that you run. The URL contains the report ID and the variable names that you used to run the report. You can use the URL to schedule a report or dashboard to run (or to run and export the data to a file) at a specified interval by configuring the Scheduled Tasks feature of the operating system to start Internet Explorer with a URL. Use the following procedure to schedule a dashboard or report to run and export the results to a file.

To schedule a dashboard or report with Scheduled Tasks

  1. Start the Scheduled Tasks tool, located in the Accessories\System Tools program group.

  2. Double-click Add Scheduled Task, and then click Next.

  3. or the Create Task Wizard from the Task Scheduler tool, depending on your operating system.

  4. In the Application list, click Internet Explorer, and then click Next.

  5. Enter a name for the task, select a time interval option, and then click Next.

  6. Select the time and day that you want the task to start, and then click Next.

  7. Enter a qualified user name and password, and then click Next.

  8. Select Open advanced properties for this task when I click Finish, and then click Finish.

  9. Choose one of the following commands depending on whether the report only displays or displays and exports the report data to a text file at a specified time:

    To run and display a report at a specified interval:

    In the Run text box, insert one space after the Internet Explorer command line, and then type the URL for the report or dashboard. For example, C:\PROGRA~1\INTERN~1\IEXPLORE.EXE http:\\<server name>\SMSReporting_<site code>\Report.asp?ReportID=<reportID>, where server name is the NetBIOS name of Configuration Manager server on which the reporting point is installed.

    To run, display, and export a report to a comma-delimited text file at a specified interval:

    In the Run text box, insert one space after the Internet Explorer command line, type the URL for the report or dashboard, and then type one of the following parameters immediately after the URL:

    • &ExportTo=<Drive letter>:\<Path>\<Filename.txt>

      Drive letter specifies a hard drive on the reporting point computer, not on the local computer. For example, C:\PROGRA~1\INTERN~1\IEXPLORE.EXE http:\\<server name>\SMSReporting_<site code>\Report.asp?ReportID=<reportID> &ExportTo=<Drive letter>:\<Path>\<Filename.txt>, where server name is the NetBIOS name of Configuration Manager server on which the reporting point is installed and share name is the name of a share that exists on that server.

    • &ExportTo=\\<Export server name>\<share name>

      Export Server name is the name of the computer where the exported text file is created. For example, C:\PROGRA~1\INTERN~1\IEXPLORE.EXE http:\\<server name>\SMSReporting_<site code>\Report.asp?ReportID=<reportID> &ExportTo=\\<Export server name>\<share name>, where server name is the NetBIOS name of Configuration Manager server on which the reporting point is installed and share name is the name of a share that exists on that server.

To schedule a dashboard or report with Task Scheduler

  1. Start Task Scheduler, located in the Accessories\System Tools program group.

  2. Click Create Task, and then specify the general settings for the task.

  3. Click the Trigger tab, click New, and then specify the trigger settings for the task.

  4. Click the Actions tab, click New, specify Start a program for the Action, click Browse and browse to iexplore.exe. By Default, this file is located in %Program Files%\Internet Explorer.

  5. Choose one of the following commands depending on whether the report only displays or displays and exports the report data to a text file at a specified time:

    To run and display a report at a specified interval:

    In the Add arguments text box, type the URL for the report or dashboard. For example, http:\\<server name>\SMSReporting_<site code>\Report.asp?ReportID=<reportID>

    To run, display, and export a report to a comma-delimited text file at a specified interval:

    In the Add arguments text box, type the URL for the report or dashboard, and then type one of the following parameters immediately after the URL:

    • &ExportTo=<Drive letter>:\<Path>\<Filename.txt>

      Drive letter specifies a hard drive on the reporting point computer, not on the local computer. For example, http:\\<server name>\SMSReporting_<site code>\Report.asp?ReportID=<reportID>&ExportTo=<Drive letter>:\<Path>\<Filename.txt>

    • &ExportTo=\\<Export server name>\<share name>

      Export Server name is the name of the computer where the exported text file is created. For example, http:\\<server name>\SMSReporting_<site code>\Report.asp?ReportID=<reportID>&ExportTo=\\<Export server name>\<share name>.

See Also