1. Announcement:
    Forum Rules (PLEASE READ BEFORE POSTING)
    admin (ADSM.ORG Admin)
    08-24-2007
    Views:
    41,577
Page 1 of 21 123456789101112 ... LastLast
Threads 1 to 50 of 1026

Forum: Scripting

TSM and SQL Scripting

  1. Maintenance script error

    Started by bluesman, 02-23-2012 06:02 AM
    • Replies: 3
    • Views: 756
    marcinek
    05-16-2013, 10:58 AM Go to last post

  2. Red face Script to list ALL backup contents

    Started by jazz, 04-29-2013 04:53 AM
    sql contents script
    • Replies: 4
    • Views: 769
    DazRaz
    05-06-2013, 11:44 PM Go to last post

  3. Scheduling Daily maintenance jobs - is there a better way?

    Started by droach, 04-24-2013 01:51 PM
    • Replies: 2
    • Views: 548
    droach
    04-25-2013, 08:08 AM Go to last post

  4. Status Failed does not show up in EVENTS Table?

    Started by influx, 04-21-2013 08:18 AM
    • Replies: 1
    • Views: 233
    LED888
    04-21-2013, 10:14 PM Go to last post

  5. Selecting subset of SQL output

    Started by sra006, 03-28-2013 05:18 PM
    • Replies: 2
    • Views: 298
    sra006
    04-01-2013, 08:45 AM Go to last post

  6. Script to gather info on a TSM server

    Started by Bancal, 03-26-2013 02:13 AM
    • Replies: 5
    • Views: 390
    Bancal
    03-28-2013, 06:32 AM Go to last post

  7. SQL start_time syntax -2 days and start at 5pm for 24 hours

    Started by rdemaat, 02-12-2013 02:32 PM
    • Replies: 11
    • Views: 537
    rdemaat
    03-19-2013, 12:57 PM Go to last post

  8. SQL Quesry

    Started by Bulbousmoses, 03-07-2013 09:34 AM
    • Replies: 1
    • Views: 276
    CoMaboy
    03-11-2013, 10:47 AM Go to last post

  9. Joined or Nested SQL Statement

    Started by Bulbousmoses, 02-25-2013 11:24 AM
    • Replies: 3
    • Views: 366
    CoMaboy
    03-07-2013, 10:19 AM Go to last post

  10. Scheduling scripts

    Started by spiffy, 02-28-2013 03:17 PM
    • Replies: 3
    • Views: 268
    domino
    03-01-2013, 10:21 AM Go to last post

  11. Combining two SQL statements into one

    Started by kpovenz, 02-26-2013 03:34 PM
    sql
    • Replies: 2
    • Views: 260
    kpovenz
    02-27-2013, 08:40 AM Go to last post

  12. dsmadmc output format

    Started by pbd1978, 02-13-2013 11:08 AM
    • Replies: 2
    • Views: 376
    moon-buddy
    02-14-2013, 01:54 PM Go to last post

  13. Select Statement for Backup Storage Pool Statistics

    Started by magrillo, 11-05-2008 10:29 AM
    • Replies: 4
    • Views: 2,488
    manojsuyal
    02-10-2013, 12:33 PM Go to last post

  14. How to combine tables, sort them and remove the duplicates from results via TSM sql

    Started by lokicfb, 02-05-2013 07:43 AM
    • Replies: 5
    • Views: 366
    lokicfb
    02-07-2013, 06:44 AM Go to last post

  15. Tape History by node

    Started by redplumptomato, 01-30-2013 09:00 AM
    history, tape, volume
    • Replies: 1
    • Views: 314
    moon-buddy
    01-30-2013, 09:32 AM Go to last post

  16. Question Script to cancel all process

    Started by barouch, 05-15-2007 12:54 PM
    • Replies: 20
    • Views: 10,355
    jonathan274
    01-28-2013, 05:16 PM Go to last post

  17. Number of Sessions at a given time , date

    Started by redplumptomato, 01-11-2013 10:31 AM
    log, number, sessions
    • Replies: 6
    • Views: 429
    dbias1601
    01-24-2013, 03:04 AM Go to last post

  18. Find nodes by Platform

    Started by redplumptomato, 01-09-2013 01:44 PM
    find, nodes, platform, report
    • Replies: 3
    • Views: 220
    RaCol
    01-09-2013, 05:18 PM Go to last post

  19. Select statement to find drive/disk usage

    Started by spiffy, 04-25-2008 09:08 AM
    • Replies: 4
    • Views: 1,711
    chahil2
    01-09-2013, 04:51 PM Go to last post

  20. Finding Tape Drive Utilisation

    Started by DazRaz, 01-02-2013 08:02 PM
    • Replies: 2
    • Views: 263
    DazRaz
    01-03-2013, 02:06 PM Go to last post

  21. Scripting in Windows Powershell or CMD - Quotes

    Started by FloXXI, 12-19-2012 03:55 AM
    • Replies: 3
    • Views: 681
    FloXXI
    12-19-2012, 03:08 PM Go to last post

  22. Speedup a "dsmc q backup "MydirectoryPath"

    Started by HajoEhlers, 12-13-2012 10:32 AM
    • Replies: 0
    • Views: 295
    HajoEhlers
    12-13-2012, 10:32 AM Go to last post

  23. Can I pipe commands to dsmadmc?

    Started by droach, 12-06-2012 10:41 AM
    • Replies: 2
    • Views: 366
    droach
    12-06-2012, 04:39 PM Go to last post

  24. Lightbulb Script to show occupancy on stgpool for inactive nodes

    Started by redplumptomato, 11-27-2012 02:21 PM
    inactive, node, stgpool
    • Replies: 2
    • Views: 619
    redplumptomato
    11-30-2012, 08:59 AM Go to last post

  25. Need a script that displays NODE REPLICATION DETAILS in daily report

    Started by jquonce, 08-22-2012 04:21 PM
    • Replies: 4
    • Views: 1,024
    balkark
    11-18-2012, 03:02 AM Go to last post

  26. SQL "cast" rounding for tsm v 5 vs v6

    Started by sra006, 10-26-2012 02:25 PM
    • Replies: 1
    • Views: 544
    CoMaboy
    11-11-2012, 06:54 PM Go to last post

  27. Extracting Archive Information

    Started by kevlee, 11-07-2012 04:47 AM
    • Replies: 0
    • Views: 405
    kevlee
    11-07-2012, 04:47 AM Go to last post

  28. Duration of last night's backups

    Started by redplumptomato, 10-04-2012 01:38 PM
    backups, duration, night
    • Replies: 3
    • Views: 655
    redplumptomato
    10-26-2012, 03:27 PM Go to last post

  29. List all schedules for all nodes

    Started by jca001, 10-23-2012 06:06 PM
    • Replies: 2
    • Views: 458
    jca001
    10-23-2012, 06:57 PM Go to last post

  30. Script doesn't work since TSM V6.2 is used

    Started by schuhb, 07-03-2012 08:03 PM
    • Replies: 3
    • Views: 825
    CoMaboy
    10-21-2012, 07:25 PM Go to last post

  31. How do I get the data to save other than c:\ drive?

    Started by khawts, 10-17-2012 11:18 PM
    • Replies: 1
    • Views: 548
    LED888
    10-18-2012, 07:52 PM Go to last post

  32. script for adding a new node

    Started by tsmuser10, 09-26-2012 10:30 AM
    • Replies: 2
    • Views: 987
    tomk
    10-17-2012, 08:25 AM Go to last post

  33. query Scheduler Results and No Scheduler association

    Started by tomk, 10-17-2012 04:06 AM
    scheduler, script
    • Replies: 0
    • Views: 498
    tomk
    10-17-2012, 04:06 AM Go to last post

  34. why does select * from nodes returns empty tcp_address

    Started by melvernon, 09-19-2012 10:04 AM
    tcp_address
    • Replies: 1
    • Views: 586
    meurnt
    09-19-2012, 03:06 PM Go to last post

  35. Angry Show size of Inactive Files

    Started by redplumptomato, 09-14-2012 03:52 PM
    filesize, query, script, size
    • Replies: 0
    • Views: 565
    redplumptomato
    09-14-2012, 03:52 PM Go to last post

  36. delete and define script - is this right ?

    Started by unixandtsm, 09-06-2012 01:41 PM
    • Replies: 2
    • Views: 718
    unixandtsm
    09-06-2012, 02:49 PM Go to last post

  37. Want a command to find out all the nodes that have been failing or missing backups

    Started by rohitrohitgeorge, 08-31-2012 12:55 AM
    backup, failed, missed, tivoli storage manager, tsm
    • Replies: 2
    • Views: 1,065
    gimlet
    08-31-2012, 12:18 PM Go to last post

  38. Awful SQL output with v6

    Started by Rigido, 11-22-2011 03:24 AM
    • Replies: 7
    • Views: 1,232
    chad_small
    08-24-2012, 11:56 AM Go to last post

  39. Getting the date at the end of a query

    Started by rallingham, 08-17-2012 10:51 AM
    • Replies: 2
    • Views: 539
    rallingham
    08-17-2012, 12:07 PM Go to last post

  40. Need help converting Select statement to useable TSM 6.2 format

    Started by pbrukner, 08-14-2012 12:52 PM
    select, tsm 6, tsm6.2.1
    • Replies: 4
    • Views: 970
    pbrukner
    08-16-2012, 03:44 PM Go to last post

  41. Select file files space

    Started by cwb, 08-03-2012 02:14 PM
    • Replies: 2
    • Views: 516
    drivechip
    08-04-2012, 03:03 AM Go to last post

  42. Daily Admin script not working after upgrade/migration to TSM 6.3

    Started by AndrewEvans, 08-01-2012 10:05 PM
    • Replies: 1
    • Views: 582
    AndrewEvans
    08-02-2012, 01:22 AM Go to last post

  43. Question How to use IF statement along with day of week in TSM script?

    Started by TMan, 07-31-2012 12:07 PM
    daily, date, if-then, logic, scripting
    • Replies: 3
    • Views: 797
    TMan
    07-31-2012, 02:56 PM Go to last post

  44. Need an 'Q EVENT' script that can use a file for the 'nodes' option

    Started by dhipp, 07-31-2012 10:54 AM
    • Replies: 7
    • Views: 543
    moon-buddy
    07-31-2012, 01:31 PM Go to last post

  45. Script for automate backup

    Started by dhammika, 06-25-2012 06:58 PM
    • Replies: 6
    • Views: 680
    chad_small
    07-31-2012, 12:25 PM Go to last post

  46. Question Simple query about timestamps

    Started by etchingsj, 07-30-2012 11:44 AM
    • Replies: 6
    • Views: 629
    etchingsj
    07-30-2012, 05:35 PM Go to last post

  47. Need a script to count NON dissociated windows clients

    Started by tsmhelum, 07-30-2012 02:43 PM
    • Replies: 1
    • Views: 492
    moon-buddy
    07-30-2012, 02:47 PM Go to last post

  48. Question TSM select query randomly creating extra line feeds

    Started by Arledge, 07-30-2012 08:51 AM
    linefeed, select, tab delimited
    • Replies: 2
    • Views: 558
    Arledge
    07-30-2012, 10:37 AM Go to last post

  49. Automatically add 'Yes' answer at TSM server prompt

    Started by BUR-admin, 07-06-2012 05:42 AM
    schedule delete, tsm, vba
    • Replies: 5
    • Views: 1,109
    smajl
    07-29-2012, 12:15 AM Go to last post

  50. HELP!! select statement for DRM

    Started by garychan789, 07-19-2012 02:20 PM
    • Replies: 7
    • Views: 595
    garychan789
    07-22-2012, 06:23 AM Go to last post
Page 1 of 21 123456789101112 ... LastLast

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 12 replies or 1400 views
Hot thread with unread posts
More than 12 replies or 1400 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules