DB query to fetch deployment data in Nolio

[Titiksha]

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

[Yasuyuki Miura]

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

[Yasuyuki Miura]

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

[Vrunda Khanolkar]

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

[Vrunda Khanolkar]

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

[Vrunda Khanolkar]

Additionally, we cannot enable JMX port. They are disabled as per secure policy.

Thanks & Regards,
Vrunda