In NS6 there was a function called "GetItemPath" in which return the path for an object in the Console. How can I get the folder path in NS 7? "GetItemPath" function does not exist in the NS 7 database. Here is the sql behind creating that function for changes in the NS 7 database:
USE [Symantec_CMDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[GetItemPath] ( @Guid Varchar(40) ) Returns varchar(8000) AS Begin DECLARE @SearchGuid VARCHAR(40), @ItemPath VARCHAR(500), @ExitCounter INT SET @SearchGuid = @Guid SET @ItemPath = '' SET @ExitCounter = 0 WHILE @ExitCounter = 0 BEGIN IF EXISTS (SELECT * FROM ItemFolder WHERE ItemGuid = @SearchGuid AND ParentFolderGuid != 'D0E33520-C160-11D2-8612-00104B74A9DF') BEGIN SET @ItemPath = (SELECT TOP 1 [Name] + '/' FROM Item WHERE [Name] NOT LIKE '/_%' escape '/' and Guid = (SELECT TOP 1 ParentFolderGuid FROM ItemFolder WHERE ItemGuid = @SearchGuid) ) + @ItemPath SET @SearchGuid = (SELECT TOP 1 ParentFolderGuid FROM ItemFolder WHERE ItemGuid = @SearchGuid) END ELSE BEGIN SET @ExitCounter = 1 END END RETURN @ItemPath END
Usage of this function:
SELECT [Symantec_CMDB].[dbo].[GetItemPath] ('GUID')