Licensed Programs section of Resource Manager doesn't show all Software

Products

• Inventory Solution

Issue/Introduction

You have noticed that under "Licensed Programs" section of Resource Manager doesn't show all Software if those are set to "hidden" in Add/Remove programs on client machines.

Environment

ITMS 8.x
Inventory Solution 8.x

Cause

By default, we do not show any software that is set to "hidden" from Add Remove Programs.

Resolution

If you need all software to show, regardless of the state in Add Remove Programs, please walk through this process.
Note that any repair or upgrade will revert the changes and they will need to be done again. Make sure you have a backup of your database as a precaution.

1. In SQL Management Studio, browse under the database, under Programmability.
2. Right-click on Stored Procedures and choose Filter > Filter Settings.
3. Under Name put: spGetFullPageLicencedProgramsSection and click OK.
4. Expand the Stored Procedure folder and Right-click on the found SP > Select Script Stored Procedure as > ALTER To > File.
5. Give it a file name and save to a location you can access later if needed.
6. In a New Query window, paste the following SQL and execute it:
   1. ALTER PROCEDURE [dbo].[spGetFullPageLicencedProgramsSection]
      @resourceGuid uniqueidentifier,
      @installedOnly bit = 1
      AS
      BEGIN
      declare @c integer
      select @c = count(*) from INFORMATION_SCHEMA.[TABLES]
      where TABLE_NAME in ('Inv_AddRemoveProgram','Inv_Software_Component')
      
      if @c = 2
      begin
      select a._SoftwareComponentGuid, a.[DisplayName], b.[Version], a.[InstallFlag]
      from Inv_AddRemoveProgram a
      inner join vInstalledItem i
      on a._ResourceGuid = i.Guid
      and a._ResourceGuid = @resourceGuid
      --and a.Hidden = 0
      and (@installedOnly = 0 or a.InstallFlag = 1)
      left join Inv_Software_Component b
      on a._SoftwareComponentGuid = b._ResourceGuid
      order by [DisplayName]
      end
      END
7. Done!