Hi,
I'm new to TSM, Right now I am trying to make an automation script to take TSM clients CSV and other things and email it
Right now I can only get some of the columns, is there any way I can get the info on the collum At Risk to show like TSM WEBUI Export.
My Command Something like this
P/S: "I still don't know of any better solution yet, so I remain open-minded for any suggestions."
Thank you.
I'm new to TSM, Right now I am trying to make an automation script to take TSM clients CSV and other things and email it
Right now I can only get some of the columns, is there any way I can get the info on the collum At Risk to show like TSM WEBUI Export.
My Command Something like this
dsmadmc -DATAONLY=YES -id=admin -password=admin -outfile=/tmp/clients_`date +'%Y%m%d'`.csv -comma "SELECT n.NODETYPE AS "Client", n.NODE_NAME AS "Node_Name", n.DOMAIN_NAME AS "Domain", n.PLATFORM_NAME AS "Platform", n.REPLICATION_PRIMARY_SERVER, n.LAST_REPLICATED_TO_SERVER cast(float(a.TOTAL_MB)/1024 AS DEC(8,2)) AS "TotalGB", TO_CHAR(n.LASTACC_TIME,'YYYY-MM-DD HH24:MI') AS "LastAccessTime",LOCKED AS "Lock" FROM NODESVIEW n, AUDITOCC a WHERE n.NODE_NAME=a.NODE_NAME ORDER BY LASTACC_TIME DESC"P/S: "I still don't know of any better solution yet, so I remain open-minded for any suggestions."
Thank you.
