View Node Archive Data from Server

BDMcGrew

ADSM.ORG Member
Joined
Mar 9, 2015
Messages
74
Reaction score
1
Points
0
PREDATAR Control23

How do I view node archive data from the server? I've searched for a day and can't seem to find it. I'd like to see all nodes and all their archive data in detail. I'm running TSM716. I have several nodes backing up/archiving that I do not have physical or remote access and can't view the client.

Thanks...
 
PREDATAR Control23

select * from archives where node_name='NODENAME'
 
PREDATAR Control23

Thanks! That did show me all the archived files, one by one, line by line. So I know there is data there lol.

Are there any tools or does anyone have a script that'll show me all the archive sets and/or all the files in an archive set?
 
PREDATAR Control23

If you use unique descriptions, you can use:
select distinct description from archives where node_name....
select * from archives where node_name='...' and description='...'
 
PREDATAR Control23

Or: select * from archives where node_name='...' and date(archive_date)='yyyy-mm-dd'
Note, will only work if the archive is all the same day, if it starts before midnight and ends after midnight, it won't work.
 
Top