eDirectory
Find long file names in eDirectory
Submitted by rlagger on Thu, 07/09/2015 - 13:06A customer asked for a query to find filenames that are too long, and might cause issues when migrating files from eDirectory to AD. The customer requested that query find filenames longer than 128 characters. The filename length to be reported by changing line 12, and the scope can limited by adding sd.scan_target = '\\server\share' to the where clause.
Note: If you have downloaded an older version of the is query and have moved to version 3.5 of the product, the old active_fs_scandata views have been replaced with current_fs_scandata.
Suspect Permissions: An evaluation of direct user-assigned trustees in NCP.
Submitted by rlagger on Wed, 07/01/2015 - 13:29Summary
Create a report to locate all of the directly assigned user permissions in a particular NCP scan target.
Back Story
The customer has a number of volumes where the trustees should only ever be assigned granted via groups. They need a report to locate any permissions that have been granted to the individual user object, so that it can be evaluated.
Information
The scope of the query to limited to NCP trustees in the desired scan target. The scan_target will need to be modified to make it work based on the environment.
Locate All GW Archive Folders Within The Desired Path
Submitted by richlagger on Fri, 03/27/2015 - 15:37Summary
I need way of locating, within a particular path, all of the GW Archive folders matching the 'ofxxxarc' pattern where the xxx is equal to the FID of the GW user. I also need the fullpath where the archive is located, and the space consumed by the archive.
You will need to change the path in line 8 to match your environment. Note: Case-Sensitive.
Submitted by richlagger on Fri, 03/13/2015 - 10:39
Submitted by richierich on Wed, 03/11/2015 - 13:22
Current NCP Trustees
Submitted by richlagger on Fri, 03/06/2015 - 16:09Summary
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.
Top 5 Largest Files Per Volume
Submitted by richierich on Fri, 03/06/2015 - 15:28Summary
Neeed to find the five largest files per scan target and their owners for both eDirectory and Active Directory.
The largest file count can be changed by changing the value in row 17.
Submitted by richlagger on Thu, 03/05/2015 - 14:53
Find Files Renamed By The Crypto or Wanna Cry Ransomeware Viruses
Submitted by richlagger on Wed, 03/04/2015 - 15:25Summary
Over the past few years computer systems everywhere have been dealing with ransomeware viruses. Crypo, Wanna Cry, and others have hit networks all over the world. How can I find these infected files, so I can restore them from back up?