Gather System Information

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
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 for completing the conversions for us