Under Review

Query Machines for Specific Requirements

SELECT cpu_logical_cores, physical_memory, free_space

FROM logical_drives

JOIN system_info on 1 and boot_partition=1

WHERE cpu_logical_cores < 2 or physical_memory < 4000000000 or free_space < 8000000000;

This will search for machines with less than 2 core, or 4 GB RAM or 8 GB of storage space. Feel free to tweak these are you like.