Query for assets

Query for assets

Hello,

I am looking for a query report, where I can check history of assigned users of all IT and Non-IT assets.
Something like that:
name | product type | previous assigned user | date of assignment change  | assigned user

Build : 14103
DB: PGSQL

Thanks in advance :)

                  New to ADSelfService Plus?