1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TSM 6.2.3 select staement

Discussion in 'Command Line Administrator Client' started by dhipp, Feb 6, 2012.

  1. dhipp

    dhipp Active Newcomer

    Joined:
    Feb 2, 2011
    Messages:
    14
    Likes Received:
    0
    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.  
  3. chad_small

    chad_small ADSM.ORG Moderator

    Joined:
    Dec 17, 2002
    Messages:
    2,210
    Likes Received:
    45
    Occupation:
    AIX/SAN/TSM
    Location:
    Gilbert, AZ
    Easy!

    select node_name, cast((lastacc_time)as date) AS LASTACC_DATE from nodes where lastacc_time<current_timestamp - 30 days
     
  4. dhipp

    dhipp Active Newcomer

    Joined:
    Feb 2, 2011
    Messages:
    14
    Likes Received:
    0
    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?
     

Share This Page