IT Management Suite

View Only

Need installed software report for all servers

Jump to Best Answer

WTargarean posted Sep 03, 2025 05:27 PM

Hi All, I have a report that will show a list of software installed on all of the servers in the environment, but it the report only shows windows server 2000-2019. I am trying to update the query below, so that it would show up to server 2025. But I could not find the OS system mask for it, I tried including '36', but it did not work. Do you guys have any ideas or better report i can use? We would like the report to list the software installed in the environment. We are running version Altiris version 8.8

----------------------

select distinct _SoftwareComponentGuid, swc.Name, swc.Version, swc.CompanyName

from Inv_InstalledSoftware sw

join vSoftwareComponentSearch swc

on swc.Guid = sw._SoftwareComponentGuid

join

(

SELECT cr.[Guid] AS [_ResourceGuid] FROM vComputerResource AS cr JOIN Inv_AeX_AC_Identification AS id ON id._ResourceGuid = cr.[Guid]

CROSS APPLY dbo.fnSysMask_IsWindowsServerAsTable(id.[OS System Mask], 18, 35, 0) tt -- Win, Server 2000-2019 (with Hyper-V)

) windowsServers

on windowsServers._ResourceGuid = sw._ResourceGuid

where sw.InstallFlag = 1

order by swc.Name

------------------------------------------

Thanks!!

Broadcom Employee Igor Perevozchikov posted Sep 04, 2025 02:07 AM Best Answer

Also there is no need to keep filtered resources via query in main SQL report query itself, there can be used a filter picker, selecting required filter for your report your will see report output only from required scope of computers

Example of your report (without Computer name column in report)

Download attached "Installed Software on managed computers (Filtered) without computer name column.xml" or "Installed Software on managed computers report (Filtered) with computer name column.xml"

Import required custom .xml report in Console

Best regards,
IP.