Current NCP Trustees
Create a report that will display all NCP Trustees in eDirectory.
The customer wanted to create a catalog of the NCP trustees for reference purposes.
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.
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