ADSM-L

Re: [ADSM-L] Select or Query help

2012-07-12 12:28:23
Subject: Re: [ADSM-L] Select or Query help
From: Ben Bullock <BBullock AT BCIDAHO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 12 Jul 2012 16:25:15 +0000
It looks like a select from the database. To make my best guess, I would think 
it was going against the backup table and selecting the BACKUP_DATE, HL_NAME & 
LL_NAME.      

tsm: ADSM>run q_columns backups

Table backups          REMARKS           
------------------     ------------------
NODE_NAME              Node Name         
FILESPACE_NAME         Filespace Name    
FILESPACE_ID           FSID              
STATE                  File state (active, inactive)        
TYPE                   Object type       
HL_NAME                Client high-level  name             
LL_NAME                Client low-level  name             
OBJECT_ID              Server object ID for the client  object           
BACKUP_DATE            Date/time that the object was backed up               
DEACTIVATE_DATE        Date/time that the object was deactivated      
OWNER                  Client objec  owner            
CLASS_NAME             Mgmt Class Name   

Ben

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Geoff Gill
Sent: Thursday, July 12, 2012 10:13 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Select or Query help

Good day all,
 
Below is a section of a file I was sent. I'm told the person who did this is 
long gone and nobody knows what command he used to get it. I was hoping someone 
might recognize it and help recreate it since I'm not sure we'll even be able 
to contact that person for help.
 
There are no headers for the columns but they seem obvious. You can see from 
the output the date, file://server/drive, file\path and filename. The filename 
and data in the file seems to indicate that this command is run to output one 
specific dates worth of data of every file a specific node backed up.
 
If anyone has any siggestions I would be eternally grateful because I'm being 
hammered to get an answer so I can run it and get the data.
 
      2011-10-17         \\bpsnt91\c$     \DOCUMENTS AND         NTUSER.DAT
02:36:24.000000                          SETTINGS\AFSADEV\
      2011-10-17         \\bpsnt91\c$     \DOCUMENTS AND         NTUSER.DAT.LOG
02:36:24.000000                          SETTINGS\AFSADEV\ 
 
     2011-10-17         \\bpsnt91\c$     \DOCUMENTS AND         NTUSER.INI
02:36:24.000000                          SETTINGS\AFSADEV\ Thank You Geoff Gill

The BCI Email Firewall made the following annotations
---------------------------------------------------------------------
*Confidentiality Notice: 

This E-Mail is intended only for the use of the individual
or entity to which it is addressed and may contain
information that is privileged, confidential and exempt
from disclosure under applicable law. If you have received
this communication in error, please do not distribute, and
delete the original message. 

Thank you for your compliance.

You may contact us at:
Blue Cross of Idaho 
3000 E. Pine Ave.
Meridian, Idaho 83642
1.208.345.4550

---------------------------------------------------------------------

<Prev in Thread] Current Thread [Next in Thread>