Re: [ADSM-L] Select or Query help
2012-07-12 12:28:23
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
---------------------------------------------------------------------
|
|
|