Return
-
Title
Need report for files deleted from HSM (Hierarchical Storage Management system). -
Description
Is there any way of obtaining the following information:- Total count of archived files deleted from HSM
- Total size of archived files deleted from HSM
- Details of archived files deleted from HSM
-
Cause
Need information of archived files deleted from HSM. -
Resolution
WORKAROUNDThe following SQL script provides the requested information.Note: Correct database name and schema to be used.---USE MAMFILE
/***** Total count of deleted archived files *****/
SELECT COUNT(PAM_FS_DOC_ID) as DeletedDocsCount
FROM [dbo].[PAM_FS_DELDOCUMENT]
/***** Total size of deleted archived files *****/
SELECT SUM(FILE_SIZE) as DeletedFileSize
FROM [dbo].[PAM_FS_DELDOCUMENT]
/***** Details of deleted archived files *****/
SELECT FILEPATH, FILENAMEA as FileName, FILE_SIZE,
CREATED_ON as ArchiveDate
FROM [dbo].[PAM_FS_DELDOCUMENT]
STATUSEnterprise Manager | Statistics tab provides several canned reports. Customized report is currently unavailable. -
Defect ID
446919 -
Attachments