Query for list contracts with contract ID + Assets linked

Query for list contracts with contract ID + Assets linked

Hi, 

is possible to get a list of contracts, with Contract ID and related assets?

Contract ID

Contract Name

Start Date

End Date

Status

Active

Account

Asset name


SDP MSP version 9408 and Postgres 

Thanks in advance!

                New to ADSelfService Plus?