1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

HSM Reporting?

Discussion in 'Hierarchical Storage Management' started by moorecj79, Jul 25, 2011.

  1. moorecj79

    moorecj79 Active Newcomer

    Joined:
    Nov 14, 2009
    Messages:
    16
    Likes Received:
    0
    Occupation:
    Server Technician
    Location:
    Melbourne, Australia
    Hi all,

    We're currently piloting HSM and management are asking for some detailed reports. For example, they want to know the drive, folder and end data (word doc, excel spreadsheet etc) that was migrated into HSM.

    I'm very aware that the HSM client has very limited reporting functions.

    I was maybe thinking about querying the hsm filespace that’s associated to the HSM node? Is this a valid option? Problem is I have no idea on how to construct the SQL statement.

    Can anyone assist? OR does anyone else have a better method? I would be most grateful for any assistance.

    Thanks,
    Chris.
     
  2.  
  3. flex

    flex ADSM.ORG Member

    Joined:
    Aug 26, 2004
    Messages:
    47
    Likes Received:
    0
    Occupation:
    TSM engineer
    Location:
    Budapest, HUNGARY
    Doesn't "dsmls" command help you? What is the OS? UNiX or Windows?
     
  4. moorecj79

    moorecj79 Active Newcomer

    Joined:
    Nov 14, 2009
    Messages:
    16
    Likes Received:
    0
    Occupation:
    Server Technician
    Location:
    Melbourne, Australia
    I'll check that command and we're running windows.
     
  5. moorecj79

    moorecj79 Active Newcomer

    Joined:
    Nov 14, 2009
    Messages:
    16
    Likes Received:
    0
    Occupation:
    Server Technician
    Location:
    Melbourne, Australia
    Got it. If I run this command, it'll give me the information I require:

    dsmclc list -g filespace "drive\directory" *.*
     
  6. cfhoffmann

    cfhoffmann ADSM.ORG Member

    Joined:
    Jun 2, 2005
    Messages:
    112
    Likes Received:
    3
    Occupation:
    TSM Storage Specialist
    Location:
    Sydney, Australia
    On the server side 'SELECT * FROM SPACEMGFILES' (or variations thereof ...WHERE NODE_NAME='XYZ') will also work and provide the information you want that you can dump into a report. Columns returned are:

    COLNAME: CLASS_NAME
    COLNAME: DELETE_DATE
    COLNAME: EXTOBJID
    COLNAME: FILESPACE_NAME
    COLNAME: FILE_NAME
    COLNAME: INSERT_DATE
    COLNAME: NODE_NAME
    COLNAME: OBJECT_ID
    COLNAME: STATE

    Obviously, these queries may take a while to run if you have lots of HSM data so take care.
     

Share This Page