Tran-Hoang_Hau_348

Retrieving the Package lifecycle from ARA database

Discussion created by Tran-Hoang_Hau_348 on Sep 6, 2017
Latest reply on Sep 6, 2017 by VladNavazhylau608590
Hello Support, 

How can the package lifecycle be retrieved from the ARA database, through a SQL script? Could not find the schema for ARA database online. 

==> Unfortunately we haven't had the online DB schema yet
however to perform what you had request you can simple check the below SQL statement

select dbo.Application.Name as "Application Name", dbo.Package.Name as "Package name", dbo.Package.DisplayName as "Package Display Name" from dbo.Package , dbo.Application   where Package.DeplAppId=Application.Id
It will display the below information, if you need any further information kindly let me know

d1bjwjavtdne.jpg

Outcomes