Wednesday, March 31, 2010

List all files in DataStorage with their sizes

find /data -fstype jfs2 2>/dev/null -type f -exec ls -lau {} \;|awk '{user=$3; group=$4; size=$5; date=$6; month=$7; time=$8; $1=""; $2=""; $3=""; $4="";$5="";$6="";$7="";$8="";print user,group,size,date,month,time,$0}' > file-size-access-2010-03-25

Output is like this:

cogneuro bestgrid 1275692 11 Mar 20:06 /data/cogneuro/Permanent Folder from M Drive/Software/Win_View/Coherence.pdf

To convert to comma delimiter file use in CentOS:

sed -r 's/ /,/;s/ /,/;s/ /,/;s/ /,/;s/ /,/;s/\s+/,/' file-size-access-2010-03-25 > file-size-access-2010-03-25.csv

No comments: