Current NCP Trustees

Details

Summary

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

Back Story

The customer wanted to create a catalog of the NCP trustees for reference purposes.

Information

The scope of the query is eDirectory Tree wide, but can be limited to a particular path by adding a simple where clause.

*Starting in version 2.6.0, the "srs.active_ncp_trustees" database view has been renamed to "srs.current_ncp_trustees". While the "active" version will still with version 3.0 work it has been deprecated.

*Starting with version 3.5 the "srs.active_ncp_trustees" database view has been removed. The "srs.current_ncp_trustees" view along with it's counter parts "srs.previous_ncp_trustees", and "srs.baseline_ncp_trustees" views have taken it's place.

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

Author

rlagger

Post date

Tuesday, January 5, 2021 - 17:02

Last modified

Friday, April 26, 2024 - 12:48

Properties

Supported Version

3.6

Report Category

Permissions

Includes a Report Layout