Forum Discussion

Bharath_Achar's avatar
Bharath_Achar
Level 6
10 years ago

Is it possible to generate Opscentre pubilc/private repsorts from command line in CSV/TSV foramt and how to ?

Is it possible to generate Opscentre pubilc/private reprots from command line in CSV/TSV foramt.

 

 

how to ?

 

Please help me on this.

Agents
Backup and Recovery
Case Study
Documentation
Linux
OpsCenter
Reporting
Rules
Tip-How to
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    10 years ago

    Hello

     

    Take a look at this post. It show how to grab the sql queries from the logs, and then execute them from CLI.

     

    https://www-secure.symantec.com/connect/blogs/custom-sql-query-asa-db-opscenter-generate-monthly-success-rate

2 Replies

Sort By
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    10 years ago

    Hello

     

    Take a look at this post. It show how to grab the sql queries from the logs, and then execute them from CLI.

     

    https://www-secure.symantec.com/connect/blogs/custom-sql-query-asa-db-opscenter-generate-monthly-success-rate

  • tom_sprouse's avatar
    tom_sprouse
    Level 6
    10 years ago

    Bharath,

    You cannot execute private or public reports from command line...

    You cannot add reports into OpsCenter from Command Line...

    However, as Riaan mentioned, you can execute custom SQL via command line.

    You can use the loadSql.bat command.  Add the custom SQL query to a text file in a temporary location and then use the loadSql.bat (orloadsql.sh) command to invoke the changes.

Windows:  \Program Files\Symantec\OpsCenter\server\bin\loadSql.bat \temp\filename.txt
UNIX:  /opt/SYMCOpsCenterServer/bin/loadsql.sh -sqlFile /tmp/filename.txt

    If you have any questions, please let us know.

    --Tom