This query can be used for general IT. Perhaps a organization is considering new software or to compare serial numbers for warranty.
SELECT uuid, hardware_serial, hostname, cpu_subtype, cpu_brand, printf("%.2f", CAST(system_info.physical_memory AS FLOAT)/1024.0/1024.0/1024.0) 'Memory(GB)', hardware_vendor, hardware_model FROM system_info;
Cleaning up columns by converting physical_memory to show in GB is a step I haven't added yet.
EDIT: Many thanks to Diego Tavolari for completing the conversions for us