If you backup a folder with wildcard (Ex: dsmc i /tmp/*), then all files will stay active as you don't scan the full directory!!!
Change to
dsmc i /tmp/
Count the number of file version keep during lasts months
> cat count_versions.sh #!/bin/bash file=/tmp/tdpe.txt dsmadmc -id=admin -pa=xxxxxx -comma -tab "select * from backups where node_name='TDPExchange' order by BACKUP_DATE " > $file echo "Month,ACTIVE_versions,INACTIVE_versions,TOTAL_versions" for i in $(cat $file | cut -d',' -f9 | cut -d'-' -f1,2 | grep '^20' | sort | uniq ) do search=",ACTIVE"; linea=$(grep ",$i" $file | grep "$search" | wc -l) search=",INACTIVE"; linei=$(grep ",$i" $file | grep "$search" | wc -l) linet=$(grep ",$i" $file | wc -l) echo "$i,$linea,$linei,$linet" done
Output, in csv format
Month,ACTIVE_versions,INACTIVE_versions,TOTAL ... 2015-01,12,0,12 2015-02,11,0,11 2015-03,14,2,16 2015-04,151798,4973,156771 2015-05,728365,25234,753599 2015-06,851047,25996,877043 2015-07,931876,26813,958689 2015-08,791743,24138,815881 2015-09,907445,25122,932567 2015-10,269240,8066,277306
In april there was an upgrade Exchange, without patching TDP for Exchange, now it's no more supported on this version, but it also doesn't expire any backup !