When trying to add EXEs to a Software Product to Meter Files (add Program) when the box is checked to Show all program files the picker is blank.
Error in the server logs:
Failed to gather files at SoftwareService:GetPrograms
Could not find stored procedure 'spGetAllExecutableFiles'.
SQL Exception details: code=2812, line=1
The stored procedure had a different schema from dbo, making it inaccessible from the account used to work with SQL.
The following will add the correct stored procedure. Make sure:
Logged in as the Application Identity to SQL Enterprise Studio.
In the query below, make sure the database in use is the correct name. The name below is the default database name.
USE [Symantec_CMDB] GO
/****** Object: StoredProcedure [dbo].[spGetAllExecutableFiles] Script Date: 12/10/2018 11:15:45 ******/ SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
CREATE PROCEDURE [dbo].[spGetAllExecutableFiles] AS BEGIN SELECT r.Guid, r.Name, wf.FileVersionString FROM dbo.[RM_ResourceFile] r join Inv_Windows_File wf on wf._ResourceGuid = r.Guid where LOWER(r.Name) LIKE '%.exe' END GO
Subscribing will provide email updates when this Article is updated. Login is required.