Results 1 to 1 of 1
Thread: Extracting Archive Information
11-07-2012, 05:47 AM #1
- Join Date
- Oct 2010
- Thanked 0 Times in 0 Posts
Extracting Archive Information
Hi, inexperienced at scripting.
Need to extract archive information from database (TSm v5.5.3).
Would like to produce an output list showing distinct description, class_name, archive date which outputs only one line per archive description. Any ideas???
Have tried using select description, class_name, archive_date but it gives me a line for each archived file, I really want to add the class_name and archive date to the distinct look up.
Also, can't seem to get sqldisplaywide to work, run dsmadmc -id -password set sqldisplaymode wide then run dsmadmc select but it still gives narrow output???
By Nicke in forum OthersReplies: 1Last Post: 10-24-2011, 03:26 AM
By sunny19 in forum TSM ServerReplies: 3Last Post: 12-01-2010, 03:07 PM
By destafford in forum TSM Reporting & MonitoringReplies: 6Last Post: 08-31-2004, 05:34 AM
By johngiggs in forum TSM Reporting & MonitoringReplies: 1Last Post: 03-10-2003, 06:55 AM
By johngiggs in forum TSM Reporting & MonitoringReplies: 0Last Post: 01-14-2003, 02:24 PM