Release Automation

 View Only
  • 1.  I need to make a report of deploys for an audit

    Posted Nov 05, 2018 08:56 PM

    This  report must include the app name, project name, start date/time, end date/time, user name, first name, last name and type of user. Which query should I use to generate it?

    Thanks.



  • 2.  Re: I need to make a report of deploys for an audit

    Broadcom Employee
    Posted Nov 07, 2018 02:17 AM

    Hi,

     

    I don't have the actual query at this stage. However, recent thread is similar to your request.

    Get Deployment report 

     

    I hope it helps you.

     

    Thanks

    Yas



  • 3.  Re: I need to make a report of deploys for an audit

    Posted Nov 08, 2018 01:56 PM

    It is not possible to query the Oracle database to obtain the information required by audit?
    I don't  know the full database schema but I suppose the information must be there.



  • 4.  Re: I need to make a report of deploys for an audit
    Best Answer

    Broadcom Employee
    Posted Nov 08, 2018 10:55 PM

    Hi,

     

    Database schema is not public at this stage. So, we cannot provide specified queries.

    Existed reports or dashboard may not be enough for your expectation. If so, please raise an idea.

     

    If you want to know back ground queries during operations, you can turn on JMX trace.

    Creating report or refreshing dashboard, and then queries are recorded in nolio_dm_all.log on NAC.

     

     

    Regards

    Yas