Tranquil IT Forum

Good morning,

I am looking to create a query that will quickly extract the free space from each machine in my fleet.

For this, there's the Freespace attribute available, which I'm trying to bring up, but it's not working:
select host_metrics->'local_drives'->>'C'->>>'FreeSpace' as "Free Space", host_metrics->'last_logged_on_user' as User, host_info->'computer_fqdn' as Name from hosts

And here's the error it's showing me
I'm not an SQL expert at all; the last time I did it was in class about 15 years ago! It seems to be a formatting issue, if I understand correctly, but I'm a bit stuck. If anyone has any ideas...

Mathieu

Good evening Mathieu,

You weren't far off. But it's true that PostgreSQL's JSON query syntax isn't the most intuitive.

I added a conversion to GB and rounding to two decimal places.

select
round(((host_metrics->'local_drives'->'C'->'FreeSpace')::float / 1073741824)::numeric,2) as free_space_en_go ,
host_metrics->'last_logged_on_user' as User,
os_name,
os_version ,
host_info->'computer_fqdn' as fqdn
from hosts
order by computer_name

Denis

Good evening Denis,

thank you very much!

Mathieu

Good evening Mathieu,
Thank you so much to you and the metropolitan area for switching to the Enterprise version. This allows us to properly fund WAPT's development and take WAPT further, and there's still a long way to go !
See you soon,
Denis

Good morning,

I tried this request but I got an error message:

Error on server: ProgrammingErooc("cannot cast type jsonb to double precision

Am I the only one?

Thank you in advance

Hello,

sorry to revive this thread after so long, but I have the same problem as the person above.
Since I'm not familiar with SQL, I'm a bit stuck. Any help would be appreciated.

Hello Jérôme,

please do not revive a topic marked as RESOLVED, as this makes forum moderation a bit complicated.

You can start a new topic and reference the existing one. It might also be helpful to specify the version of Wapt you are using.

Regards,

Denis