Hi Eric, we use the following steps to identify large files in last nights backup:
Step 1 - Query the volumes used in last nights backup select volume_name as Volume, stgpool_name as Stgpool, date(last_write_date) as "Date", - time(last_write_date) as "Time" from volumes where - last_write_date > timestamp(date(current_date-1 day),'19:00:00') and - last_write_date < timestamp(date(current_date),'10:00:00') and - stgpool_name in (select stgpool_name from stgpools where pooltype='PRIMARY') Step 2 - List all files on volumes returned by Step 1 > x Bytes select node_name as Node, - filespace_name as Filespace,- file_name as Filename,- file_size as Size - from contents - where volume_name='$1' and - file_size>$2 Or we list the number of files and summarized size per node of a volume. So you see nodes with a small number of files but lots of gigas backed up: select node_name as Node, - filespace_name as Filespace,- count(file_name) as Files,- sum(file_size) as Size - from contents - where volume_name='$1' - group by node_name, filespace_name - order by files desc HTH Thomas Rupp Vorarlberger Illwerke Aktiengesellschaft ein Unternehmen von illwerke vkw Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN 59202m Firmenbuchgericht: LG Feldkirch, DVR 0008753, UID-Nr.: ATU 36737402 Vorarlberger Kraftwerke Aktiengesellschaft ein Unternehmen von illwerke vkw Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN58920y Firmenbuchgericht: LG Feldkirch, DVR 0027961, UID-Nr.: ATU 36737304
