Search:

Yup...thats what I was looking for! You are good! And you beat me to the wait time field too! My version would have been a bit more complicated. I was going to do another CASE WHEN ELSE dividing...

Hi again, may be testing the limits on this one. Here's the script so far:

select client_name, session_id, state, -
wait_seconds as "Wait Time", -
substr(cast((start_time) as char(29)),1,10) as...

Sweet! Thank you!

Ok. Thanks. Here's another challenge, at least for me. In this same script can I get it to display bytes received as xxx K, or xxx M, or xxx G, or xxx T depending on the number? Like the Q SE ...

Ok. Thanks. But could you uh 'translate' :redface: that tanslate statement please? Mainly the '________abcdef______' part but the whole thing would be nice. Thanks.

Here's the answer: :smile:

select client_name, session_id, state, -
substr(cast((start_time) as char(29)),1,10) as "Start Date", -
substr(cast((start_time) as char(29)),12,8) as "Start Time", -...

Hello all, I have this script that is working except that in the hours, minutes and seconds fields when any of them have a leading zero the zero gets dropped. For instance: if a session has been...

The answer to this ended up being a firmware upgrade to the TS3200 library. Thanks Tiger22 for your input.

ok. I have the tech going back in. What about the 'Restore Factory Defaults' option. Reading about that in the manual it sounds kind of drastic. Is it? Should we try that? The tech suggested doing...

Oh. And the 3 IO slots are still not visible / usable. Still cant check the ENABLE option.

Ok. We did a reboot. Didnt change anything. But we did move (via the gui) the cleaning tape from its original slot, slot 12, to one of those *RES* slots. That got rid of a couple errors on the GUI...

Yes. Admin / secure

Hello, I have a new TS3200 that was just installed. Actually just the frame/robot is new. We used the old tape drives. Its a 4U so it has 48 slots. 44 for data. 3 for the IO station and 1 for the...

Yes it is working now. Perfect! Thank you!

Oh. 6.2.4 is the TSM version on a Windows 2003 server

Ok. i copied the code from this thread to 2 new scripts and ran them a few times in a row. Results below. The archive total changes and so do the totals numbers. :(

I think the previous activity...

Ok. Here is the output and the code. As you will notice I created TSM scripts that contain the code. I cut and pasted from there to below along with a cut and paste of the output. My comments are in...

Ok. I have tried this totals code. it must be interpreting the time logic different. the total it comes up with doesnt match all the individual totals from the first select. and it keeps changing as...

YES !!!! Thank you !!! Any chance that a total GBs could be displayed also?



ACTIVITY the last 5pm to 5pm time frame
GBs processed


ARCHIVE
3265.27

Hi Harry, yes you are correct. "Define volume diskpool \\ipaddressofbuffalo\tsmbackup\test.dsm formatsize=10000 " worked. A backup was then run to diskpool and it ran just fine. Thanks for...

Does anyone know if its possible to get a Buffalo device assigned to the Windows OS so you can then define a storage pool and volumes to it? I'm pretty sure that me just network mapping a drive...

I found this select to list all activity in the last 24 hours. But I would like it to go back 2 days and start at 5pm for 24 hours. Preferably using -2 to go back two days instead of supplying an...

Hello all, is there a download spot to get the TSM TDP for Exchange client software?
Running TSM 5.5.6 on a Windows 2003 server. Thanks!

Hi all, I'm wondering if there is a way to start a windows VBS script from a TSM admin script. I think I see it eluded to in this thread but I'm not sure. For example: I'm at the TIP Command Line and...

It must be. How do I tell? Also, looking back it looks like 2 incrementals kicked in. One at 5:39 am and one at 7:46 am. So whats going on to generate all those log entries?

Date/Time : 9/9/11...

Q LOG F=D

Total Space(MB) : 16,384
Used Space(MB) : 184
Free Space(MB) : 16,120
Active Log Directory : H:\tsm\log
Archive Log...

Hi all, every once in a while (maybe once every 3 months or so) I get this message:
ANR4529I An automatic full or incremental database backup will be started. The active log space used is 14511.94...

I'm struggling with this command in a windows script that does tsm commands and sends the output to a file. First of all, on my TSM 5.5 server I have a script with this command that works fine....

Fairly new at tsm sql scripting. I have this script:

select -
volume_name As "Volume", -
state As "State", -
upd_date As "Date", -
/* location As "Location", - */
stgpool_name As...

Got it. Thanks. Just a little to inexpereinced in some of this stuff I guess. Using the F=D on the Q EVE showed me the domain name which I probably should have known anyway but oh well. Thanks again.

When I do a Q EVE * * I see one out there titled: @223 nodename Pending. Its been trying to run for several ours. I started it with a script we have: RUN BACKUP nodename. There is something...

Ok. I'll review as you suggested. I'm finding that the Q OCC is also helping me see the connection between a node and the storage pools that receive its data.

Ok. That helps. But I still dont see the 'node to storage pool' connection. I'm pretty sure its: 'client option set' to 'management class' to 'storage pool'. I'm looking at lots of different nodes in...

I've been supporting (or more like helping to support) TSM for awhile now. And I've always been frustrated that you cant easily determine what storage pool a node goes to. I know it has to do with...

Sorry if some of this is probably TSM 101 stuff but I need to create a new management class (I think) so i can copy a new clients data directly to new LTO4 tapes. I want to test a backup and a...

Yes, it shows up in the database backup query list. That answers that. Thank you!

Uh, sense my first post I've discovered the error of my ways. It helps to put the full name of the volume in the command. I was forgetting the L4 on the end. Duh.
BUT, this one tape, 500170L4 I...

How do you list the contents of a DRM tape? Thanks!

After many google searches, here is one answer. The chr(34) got me past the problem.

email_msg = """Exchange backup has been missed. """
Const forreading = 1
set fs = createobject...

I'm trying to figure how to send 2 quoted parms to another vb script. the first parm is a hard coded constant so I can get quotes around it easy enough. The second one is a record read from a text...

Good news! :up: I copied the .VBS to the folder where dsmadmc.exe is and its working like a champ! Thanks THE_WIPET! And to all you others who took the time to help a stranger! :)

Thanks for the suggestions but I must be doing something wrong. I just cant get any output to go anywhere. If anyone can run dsmadmc in a windows shell script and get the the output from the command...

Using Windows Scripting, trying to figure out how to get the output from a TSM command to a file. This is the command that I have so far. Nothing shows up in c:\testing.txt. I suspect I need some...

Mike, perfect! Thanks! I'm at 5.5 by the way. Ed, I'll do that. I suspect I have a bit to learn. I did find this link on the internet yesterday:
http://www.general-storage.de/tsmsqlbt01.html
...

I'm new to TSM / SQL scripting. Where do I start? I want to create a script that issues a checkin command and then replies to the request number. Thanks!