Tranquil IT Forum

Published: **April 20, 2020 - 12:48 PM**

Hello
WAPT 1.7
Debian Stretch.

I'm trying to run a query that lists all PCs running Windows with 4 GB of RAM or less.

Thank you for your help.

Published: **April 24, 2020 - 10:28 AM**

Good morning

Replace the value 4286169088 with the value you want

Code: Select all

select host_metrics->'physical_memory' as RAM , host_metrics->'last_logged_on_user' as User, host_info->'computer_fqdn'  as Name from hosts WHERE host_metrics->'physical_memory'<'4286169088'

Published: **April 28, 2020 - 6:08 PM**

Thank you so much

Tranquil IT Forum

[SOLVED] Windows machine with 4 GB RAM or less

[SOLVED] Windows machine with 4 GB RAM or less

Re: Windows PC with 4 GB RAM or less

Re: [SOLVED] Windows machine with 4 GB RAM or less