Scheduling and Exporting Reports

book

Article ID: 38972

calendar_today

Updated On:

Products

CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

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

 

Environment

CA Client Automation - All versions

 

Resolution

 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                              

 

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

 

  1. From the Properties Screen Select the Scheduling Tab

 

  1. Click on Set Scheduling... Button

 

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

  1. Select the Conditions Tab

 

  1. This lets you select the :
  •    Time Range
  •    Days
  •    Frequency   

 

 

Exporting/Publishing Tab:

  1. Click On Publishing Tab

 

  1. Click on Set Publishing.... Button

 

  1. 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

      

 

   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    

     

 

    Export Tab (This is for Exported reports)

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

 

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

 

  1. Click on the Properties Button

 

  1. 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.

 

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)

 

Additional Information

It is possible to export the file in a network share directory :

Example : \\COMP1\SHARENAME\INVENT.csv

 

As Engines are executed under Local System Account we should allow access to share by Local System Account.

On machine which share (COMP1 in above example), open "Local Security Policy" and go under "Local Policies/Security Options"

In Parameter "Network access: Shares that can be accessed anonymously" add the name of share in the list :

 

Attachments