PostgreSQL

Submitted by rlagger on Wed, 02/13/2019 - 13:46

Submitted by rlagger on Thu, 01/04/2018 - 12:12

Submitted by rlagger on Mon, 10/31/2016 - 11:14

Summary with Quota and Owner

Submitted by richlagger on Tue, 07/14/2015 - 09:45
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Background

A customer needed to create a report for management that shows the file and folder counts, the users quota, and how much of their quota was being used. This customer wanted all empty directories to be ignored.

This custom query shows a summary of the folders in the path provided on line 7. The report summaries the file and folder counts, size used, the quota value set, and the quota remaining.

 

Find long file names in eDirectory

Submitted by rlagger on Thu, 07/09/2015 - 13:06
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

A 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:29
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 1

Summary

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.

Submitted by rkoktan on Mon, 06/22/2015 - 14:11

Locate All GW Archive Folders Within The Desired Path

Submitted by richlagger on Fri, 03/27/2015 - 15:37
  • 1
  • 2
  • 3
  • 4
  • 5
Total votes: 0

Summary

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

Pages