Tranquil IT Forum

Good morning,

Following up on the topic: viewtopic.php?t=2787
I tested the command indicated, namely:

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

And I get the message: Error on server: ProgrammingErooc("cannot cast type jsonb to double precision

When I remove the Round part, it does show me the information, but obviously with the size of the disk space in bytes.
Do you have a solution to this problem, please?

For your information:
WAPT version: 2.1.2.10605 Enterprise edition

Hi Jérôme,

which version of PostgreSQL are you using? Your PostgreSQL database might be too old to support casting (type conversion) between JSONB and float. If you're on CentOS 7 with PostgreSQL 9.6, you'll need to upgrade.

In Wapt version 2.3 for CentOS 7, we added PostgreSQL version 14, which should resolve the issue, but you'll still need to upgrade. You can contact support if needed.

Regards,

Denis

Hello,

thank you for your feedback.
We are using PostgreSQL version 10.15. We will be planning an upgrade; in the meantime, I managed to perform the conversion in my Excel file after my query.

I'm marking this topic as resolved.

Have a good day!

Thanks for the feedback,
Denis