search cancel

Show all Program Files when adding EXEs to Meter comes up blank

book

Article ID: 173194

calendar_today

Updated On:

Products

Software Management Solution

Cause

The stored procedure had a different schema from dbo, making it inaccessible from the account used to work with SQL.

Resolution

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