Report extraction from Orchestrator Database

Help Orchestrator
1

Need to extract the monthly report from the orchestrator database but, unable to find the proper combination of tables in order to get the required columns.

Report should have following 4 columns primarily:

Process name
Start Time
End Time
Status (successful/failure)

Can someone help in this?

2

Use Jobs table ,Releases table this two should be sufficient

3

Hi @Pooja_Kv, how can we connect to Orchestrator Database in community version? If it exists natively, how to know the credentials and db name, table name etc.