Who is this article for?

Users who want to learn about Extracting Metadata into a custom report.

Elevated permissions are not required.

This article provides an Example of how Metadata can be extracted into a custom report. These Examples can be used as a general overview of extracting Metadata into reports for customers aiming to create their own templates.

1. Example 1
2. Example 2

1. Example 1

1. This is an example of a query that will allow clients to extract bespoke Metadata information into a custom report.
2. This example shows how to extract the Metadata Items Period Covered From (Date), Period Covered To (Date), Report Distribution List (User List). 

Select ID, Name,
            !PeriodCoveredFrom, !PeriodCoveredTo,
            !ReportDistributionList->[DisplayName]
From Audit

2. Example 2

1. This is an example of a query that will allow clients to extract bespoke Metadata information into a custom report.
2. Some Metadata fields can begin with the character ! .
3. Some entity metadata fields will have a number like 1 or 2 (e.g. !1:FieldName). 1 or 2 means that there are different templates associated to the entity.
4. This example shows how to extract the Audit Metadata Items Frequency (List) and planned audit metadata PA Ext Users (User list)

Select ID, Name,
            !Frequency->[Name],
            !1:PaExtUsers->[DisplayName]
From Audit