Service Operations Insight

  • Private Community

  • 1.  SOI Database Structure Documentation

    Posted Sep 20, 2017 04:44 PM

    Hi folks,

     

    does anyone know if there is a documentation of SOI database strutcture (tables and their relationships)?

     

    Context: we are building at this moment some reports of alerts using the Jasper Studio solution, but we need to seek information about the database (Microsoft SQL Server) so as to build the queries.

     

    Thanks

     

    João Bernardo



  • 2.  Re: SOI Database Structure Documentation

    Broadcom Employee
    Posted Sep 21, 2017 02:27 PM

    Hi Joao,

    Sorry we don't have such document.

    Thanks

    Shaheen



  • 3.  Re: SOI Database Structure Documentation

    Posted Sep 21, 2017 04:42 PM

    Ok.

     

    Do you know if there is another way to seek this information?

     

    Thanks

     

    João Bernardo



  • 4.  Re: SOI Database Structure Documentation

    Posted Sep 22, 2017 12:32 AM

    It's actually quite easy to figure out the DB Architecture yourselves. I had a requirement to set up a custom report on Jasper. So I started digging into tables and relationships and found it very easy to 'plot' out which tables to query for the specific report. All you need is a bit of time and determination to find what you are looking for.



  • 5.  Re: SOI Database Structure Documentation

    Posted Sep 28, 2017 05:26 AM

    Actually João, information like that is not disclosed by CA, but as Madelaine states you should be able to figure things out yourself, if you have some time on your hands indeed.

     

    Vincent_B