Tranquil IT Forum

Published: **September 23, 2025 - 09:56**

Hello,

I'm trying to get a list of the software installed on our network (just the name, no need for the version) along with the number of installations for each.

The query "List Normalized Softwares" described in viewtopic.php?t=1840 doesn't seem to work on WAPT 2.6.0.17392; I only get a blank page.

Could you please help me get it working again?

Thank you in advance for your help.
Best regards.

Published: **September 23, 2025 - 11:24 AM**

Good morning,

If you do not have a standardized name for your fleet, you can use the "original_name" field

Code: Select all

select
  n.original_name,string_agg(distinct lower(h.computer_name), ','),count(distinct h.uuid)
from hostsoftwares s
left join normalization n on (n.original_name = s.name) and (n.key = s.key)
left join hosts h on h.uuid = s.host_id
where (n.original_name is not null) and (n.original_name<>'') and not n.windows_update and not n.banned
group by 1

Published: **September 23, 2025 - 4:58 PM**

Thank you so much, it's perfect like this!

Tranquil IT Forum

[RESOLVED] Query updated

[RESOLVED] Query updated

Re: Query update

Re: Query update