This query can be used for general IT. Perhaps a organization is considering new software or to compare serial numbers for warranty.
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
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
Appreciate this - made the edits to reflect and a s/o!
Here is the conversion. Just worked something out for my own inventory query: