Summary

Create a report that will display all NCP Trustees in eDirectory.

Details

The query spans the entire eDirectory tree but can be limited to a particular path by adding a simple WHERE clause.

Code

SELECT
    case when ncp.trustee_name = '[Inherited Rights Filter]' then null
    else ncp.trustee_name
    end as trustee_name,
    ncp.trustee_display_name,
    ncp.fullpath,
    ncp.rights_string
FROM
    srs.current_ncp_trustees AS ncp