Custom Attributes
Information stored for items can be extended using custom sections and attributes.
To access the display value of a custom attribute in a report, view the configuration of the custom attribute and note the identifier.
To access the display value of the custom attribute the GetCustomAttribute function can be used, for example
SELECT
[dbo].[ItemCore].[ItemID] AS [ItemID],
[dbo].[ItemCore].[Name] AS [Name],
[dbo].[GetCustomAttribute] ([dbo].[ItemCore].[ItemID], '5e6d074d-d7e704f9e-b0ee-eff73bde89b8') AS [Server Identifier]
FROM [dbo].[ItemCore]
WHERE
[dbo].[ItemCore].[ItemDeletedDate] IS NULL