Results 1 to 3 of 3
  1. #1
    Newcomer
    Join Date
    Feb 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default TSM 6.2.3 select staement

    I need a select statement that shows me a list of node_name from nodes that have NOT backed up in 30+ days. The script I had that was functional for TSM 5.5.52 does not work for TSM 6.2.3. I looked at the lasconstorage scripts, and they don't appear to have one. Anyone have one on file that they can respond with?

    Thanks

  2. #2
    Moderator chad_small's Avatar
    Join Date
    Dec 2002
    Location
    Gilbert, AZ
    Posts
    2,191
    Thanks
    1
    Thanked 24 Times in 23 Posts

    Default

    Easy!

    select node_name, cast((lastacc_time)as date) AS LASTACC_DATE from nodes where lastacc_time<current_timestamp - 30 days
    Chad Small
    IBM Certified Deployment Professional
    chadsmal@gmail.com
    http://www.tsmadmin.com

  3. #3
    Newcomer
    Join Date
    Feb 2011
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks Chad ! Worked like a charm. Do you know of a more detailed website than Lascon for pre-defined scripts for TSM 6.2.3 reporting? Or, better yet, has anyone used TCR?

Similar Threads

  1. TSM - Select
    By girreis in forum Administrative Client
    Replies: 2
    Last Post: 12-08-2011, 05:16 PM
  2. TSM - Help SELECT part 2
    By girreis in forum Command Line Administrator Client
    Replies: 8
    Last Post: 03-03-2011, 01:34 PM
  3. TSM - Help SELECT
    By girreis in forum Command Line Administrator Client
    Replies: 9
    Last Post: 02-18-2011, 02:50 PM
  4. Select in TSM 6.1
    By staham in forum TSM Server
    Replies: 1
    Last Post: 02-03-2011, 05:34 AM
  5. Need some help converting select to TSM 6.1
    By MrStormy in forum Scripting
    Replies: 0
    Last Post: 11-06-2009, 12:47 PM

Posting Permissions

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