Can I please have a query compatible with build 8123 and MSSQL for the following information from the asset module:

Only for the assets with the Servicedesk agent installed

Required columns are: hostname, last date scanned, agent version, username, department, site. IP address

Many thanks,

Dean