Release Automation

Expand all | Collapse all

DB query to fetch deployment data in Nolio

Jump to Best Answer
  • 1.  DB query to fetch deployment data in Nolio

    Posted 12-14-2018 03:53 AM

    Hello Team,

     

    Could you please provide DB Query to fetch the deployment data for a particular period of time in Nolio for e.g :- say from Jan,2017 to Dec'2018 ?

     

    Thanks

    Titiksha



  • 2.  Re: DB query to fetch deployment data in Nolio
    Best Answer

    Posted 12-17-2018 03:05 AM

    Hi,

     

    I don't recommend to access RA database directly.

    You can retrieve deployments with specific time range using Offline Audit Report in Automation Studio.

     

     

    Thanks

    Yas



  • 3.  Re: DB query to fetch deployment data in Nolio

    Posted 12-25-2018 09:01 PM

    Hi,

     

    Did my answer help you?

    I'm not sure whether your expectation is satisfied. However, you can analyze queries if you want.

    Please refer to following article.

    I need to make a report of deploys for an audit 

     

    Note: I have to say that "Direct query is not recommended." because schema and internal queries may be changed without any notification.

     

    Thanks

    Yas



  • 4.  RE: Re: DB query to fetch deployment data in Nolio

    Posted 07-19-2019 03:40 AM
    Dear Yas,

    The report download in pdf format never works for this. Hence we need to have DB query to fetch large number of data.
    Because with offline reports we can only download one page at a time. 

    We even tried Deployment overview report provided in ROC. But when we fetch that in CSV format, it gives same date-time for all the records even if the deployment is performed on different date-time. So, again that is not helpful as we have to fetch the report one page at a time.

    Could you please provide the DB query. That will help us to save time.
    Your quick assistance on this is appreciated!

    Thanks & Regards,
    Vrunda


  • 5.  RE: Re: DB query to fetch deployment data in Nolio

    Posted 29 days ago
    Dear Yas,

    Unfortunately this answer is not helpful.

    Because the offline report PDF download feature, downloads only one page at a time. However I see a report generated is of 99 pages if I want to pull 6 months data for audit purpose.
    I understand that the query is not recommended but we cannot spend that much of time only downloading the data manually page by page.
    Please share the DB query.

    Thanks & Regards,
    Vrunda


  • 6.  RE: Re: DB query to fetch deployment data in Nolio

    Posted 29 days ago
    Additionally, we cannot enable JMX port. They are disabled as per secure policy.

    Thanks & Regards,
    Vrunda