Licensed Programs section of Resource Manager doesn't show all Software
book
Article ID: 174723
calendar_today
Updated On:
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.
In SQL Management Studio, browse under the database, under Programmability.
Right-click on Stored Procedures and choose Filter > Filter Settings.
Under Name put: spGetFullPageLicencedProgramsSection and click OK.
Expand the Stored Procedure folder and Right-click on the found SP > Select Script Stored Procedure as > ALTER To > File.
Give it a file name and save to a location you can access later if needed.
In a New Query window, paste the following SQL and execute it:
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