[RESOLVED] Query updated

[erems]

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.

[jlepiquet]

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

[erems]

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