Detailed report

Detailed report

Hello,

Can someone provide me with a query code to generate the following report:

ASSET_NUMBER 
USER_NAME 
OS 
ASSET_TYPE
DEPARTMENT
LOCATION 
ASSET_CATEGORY
LAST_PM_DONE_DATE 
HOST_NAME 
USER_ID 
USER_POSITION 
PURCHASE_DATE 
RAM
HDD 
SYS_SPEC

Thanks

                  New to ADSelfService Plus?