Scheduling and Exporting Reports

Document ID : KB000038972
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How to Schedule, Publish and or Export a Report in DSM Reporter?

 

Environment:                                    

CA Client Automation - All versions

 

Answer:

 Once you have created a report in CA Client Automation Reporter you do one of the 4 following things with them:

1. View in Reporter

2. Schedule a Report to run on a certain schedule

3. Publish the Report, so it creates a Database Table (ca_itrm.<report_name>

4. Export the Report in different formats(CSV, html, XML, or ODBC Database Table)

 

Scheduling Tab: 

1. Create a Report                              

 

2. Right-Click on Report and select Schedule Report......

Create.jpg

3. From the Properties Screen Select the Scheduling Tab

 

4. Click on Set Scheduling... Button

 

5. From the Scheduling properties menu Select How often you want the Report to be run

sced_prop.jpg

6. Select the Conditions Tab

 

7. This lets you select the :

  •    Time Range
  •    Days
  •    Frequency   

Conditions.jpg

 

 

Exporting/Publishing Tab:

1. Click On Publishing Tab

 

2. Click on Set Publishing.... Button

 

3. On the Publishing properties Screen you will see 3 Tabs:

   General Tab

  •      Here you can set the number of Exported results to save
  •      You can also be emailed each time a Report is exported. (you must setup the email server setting in the config policy

      general.jpg

 

   Save Tab (This is for Published Reports) 

    Here is where you select what you are going to call the Report
       There are a 3 options:
  •      Use same name and overwrite each time you export 
  •      Add time stamp to the Report Name
  •      Add Auto generated Number    

     publish.jpg

 

    Export Tab (This is for Exported reports)

    1.  Select the format you want you Reported Exported To:

 

    2. Select How you want the Exported Report named (same options as with Published Reports)

 

    3. Click on the Properties Button

 

    4. This open the Export as  Screen.

          This is where you select where you want to the reports exported to.

          You can also Other Properties based on the Format you are Exporting.

Export.jpg

 

Engine Tab

Select which Engine will handle the Scheduling or Publishing of the Reports.

(If you have a large number of Reports and/or Dynamic Groups, you might want to create a Report and/or Groups Engine)

Engine.jpg