Live Discover Query - Minimum hardware check

 REVIEWED by Sophos 

Given the advice in article 121027 regarding recommended hardware specifications.  For example, Intercept X Advanced with EDR and MTR is:

• Disk space: 8 GB free
• RAM: 4 GB
• Cores: 2

The following query could be used to identify those devices which may require an upgrade:

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 < 4294967296 or free_space < 8589934592;

Note: physical_memory and free_space are in bytes.  The numbers in the query are from:

(1024 * 1024 * 1024 * 8) = 8589934592
(1024 * 1024 * 1024 * 4) = 4294967296

Note: When I ran this command I did get a computer returned with 4202336256 physical_memory, so maybe just use 4000000000 and 8000000000 to avoid minor discrepancies. E.g.

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;

Regards,
Jak