Custom report

Custom report

Hello,
 
I need an Assest report that lists all workstations with the following info. Model,  Acquisiton date, Expiry date, Warranty expiration.
 
I would like the asset listed in the first column and the rest of the info in the following columns in any order.
 
Can you please give me the query syntax for this report?
 
Thank you.
                New to ADManager Plus?

                  New to ADSelfService Plus?