Current NCP Trustees

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
Last modified
Monday, January 11, 2021 - 11:04
Properties
Supported Version
Report Category
Includes a Report Layout
Yes
Tags
Downloads
AttachmentSize
Current NCP Trustees.zip64.7 KB
Sample Report
AttachmentSize
Current NCP Trustees.pdf65.65 KB
Preview Images