Welcome to Dell Technologies Data Domain - How to Series.
How to list files in Data Domain system using sfs_dump and importing it to Excel. Reference Dell Knowledge Base Article number 81345. This video was created to: Demonstrate how to use sfs_dump feature of Data Domain to list files available into mtree.
We can see the files with their age, size, and compression values. This Knowledge Base video is applicable to: All Data Domain systems. All Software versions.
Comparing against a list of files managed by a backup application to check for any files orphaned from that backup application. Listing all files for a certain age threshold.
Let's begin. Log in to "Data Domain SSH" using "sysadmin" user, and then go to "se" mode. If you have security officer setup, then please provide security username and password and then provide DD serial number as system password to go into "se" mode.
Now you need to list mtrees and then select the mtree for which you want to list files. Now go to "PuTTY" bar to generate log. You need to go to "Change Settings", then go to "Logging".
Then click on "All Session Output" and select the log location. Give it a name like "sfs_dump.out", and always append to the end of it. Click on "Apply" and "OK".
Now we need to generate "sfs_dump" for the selected mtree. Please type command "sesfs_dump -c" mtree name and hit "Enter". It will generate "sfs_dump" and save that to file "sfs_dump.out".
Now we need to disable "PuTTY" logging to avoid that log file update. Now you need to check if the created log file is available at the given location. Now you need to import it into Excel.
Open Microsoft Excel and click "File" on the top left corner, then select "Open", and then "Browse" for the log location where the file exists. Choose the option as "All Files", and then select the file to be opened in Excel.
The "Text Import Wizard" will open. Accept "Delimited". Click "Next" and then "Tab" separated, and click "Finish". Now the file is opened in the Excel workbook.
Delete all of the rows before the "name" row, and the last two rows from the workbook. Column "A" contains file "name". Column "B" contains "mtime", which is going to be converted into the last written date format.
Column "C" contains "fileid" for each file. Column "D" contains the original "size" of a file. Column "E" contains "seg_bytes", which means the size of a file after segmentation.
Column "F" contains "seg_count", which means the count of segments created for the file. Column "G" contains "redun_seg_count", how many redundant segments are stored on DD.
Column "H" contains the size after global compression. Column "I" contains the size after global and local compression. Column "J" contains the date stamp for when the file was last written.
Please note that these values are derived at the time of ingest. Now we need to apply a formula to change the mtime value into a human readable format. Go to column "J" and click on "J1", and then paste this formula into "J1".
Copy this from KB Article number 81345. Right-click column "J1" and select "Format Cells". Select "Date" format as per your choice and then click "OK".
Now copy cell "J1" and paste it in whole column "J" until the last row. Rename the cell "J1" as "Last Written date". This will be the date and time on which the files are stored in DD. Expand all the columns to see it properly.
Please select cell "A1", and then from the menu bar, click on "Format as Table" and then select the desired table. And then select "OK". You can filter with a date for any desired date from column "J" and then see which files are created on those dates. Based on that, you can decide what to do with those files.
Thank you for watching.
