Forum Discussion

ddm2's avatar
ddm2
Level 5
13 years ago

OPS Center custom report with SQL Queries

Hello,

is there any doc around about creation of custom reports using SQL queries?

OPS 7.5.0.3.

Thanks and best regards.

7.5
Backup and Recovery
NetBackup
  • mph999's avatar
    mph999
    13 years ago

    Not offically that I know of.

    Rightly or wrongly, Symantec don't support creating the actual SQL query - possibly because if we did, that's all we'd do - everyone would want custom scripts written.

    If you log a call, you may be able to get a copy of the data schema, which would be useful so you know what to put in the query.  I don't have one and I don't know if one can be made public.

    Be aware, that on upgrades the database schema can change, which may break existing queries.  This 'warning' is documented.

    I'm sure someone will be along who may have some docs they have written, but offically, as far as I am aware, they aren't any.

    Martin

4 Replies

Sort By
  • mph999's avatar
    mph999
    Level 6
    13 years ago

    Not offically that I know of.

    Rightly or wrongly, Symantec don't support creating the actual SQL query - possibly because if we did, that's all we'd do - everyone would want custom scripts written.

    If you log a call, you may be able to get a copy of the data schema, which would be useful so you know what to put in the query.  I don't have one and I don't know if one can be made public.

    Be aware, that on upgrades the database schema can change, which may break existing queries.  This 'warning' is documented.

    I'm sure someone will be along who may have some docs they have written, but offically, as far as I am aware, they aren't any.

    Martin

  • CRZ's avatar
    CRZ
    Level 6
    13 years ago

    Maybe I misunderstood the question, but this is definitely documented.  It's got its own (really, really short) section in the manual!

    Creating an OpsCenter report using SQL query can be found on pages 373-375 of the Reporting Guide:

    Symantec OpsCenter 7.5 Reporting Guide
     http://symantec.com/docs/DOC5044

    If you need more specific information or are looking for examples, I would send you over to Connect's OpsCenter forum.

  • mph999's avatar
    mph999
    Level 6
    13 years ago

    I was thinking dms was probably looking more for actaul examples on the sql query itself ...

  • ddm2's avatar
    ddm2
    Level 5
    13 years ago

    Thanks for your answers folk.

    Actually I was looking for some example about SQL queries.

    I'll try to get the schema from the support.

    Have a nice day.