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
    ncp.trustee_name,
    ncp.trustee_display_name,
    ncp.fullpath,
    ncp.rights_string
FROM
    srs.current_ncp_trustees AS ncp 
 
Author
richlagger
Last modified
Monday, July 2, 2018 - 12:45
Properties
Minimum Version
Report Category
Includes a Report Layout
Yes
Databases
Tags
Rating
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0
Downloads
AttachmentSize
Current NCP Trustees.zip38.91 KB
Preview Images