HSM Reporting?

[moorecj79]

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.

 

[flex]

Doesn't "dsmls" command help you? What is the OS? UNiX or Windows?

 

[moorecj79]

I'll check that command and we're running windows.

 

[moorecj79]

Got it. If I run this command, it'll give me the information I require:

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

 

[cfhoffmann]

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.