Oy. I thought we were in the deep end of the pool for chargeback. We do chargeback, but we base it on info we can get from the server side. Specifically, the occupancy table. This will give you granularity down to the filespace level, but not beyond that. For what you want to do, you would need to process the "archives" table, which would potentially be huge. In fact, the SQL query against this table would probably run for quite a long time and could potentially hold locks on your server which might lead to operational problems.
The session accounting records record all sessions to the TSM server, and I believe they contain the userid. This would allow you to capture "data transmitted" metrics down the user level. Perhaps others have ideas on how to do this. ..Paul At 11:17 AM 8/1/2006, Jim Zajkowski wrote:
Hi folks, Right now we only backup servers to TSM. We are considering allowing individuals to use TSM as an archive repository, and the first question that came up was how to figure out how much space a particular client or person is using in the archive, so we can send them a bill. The caveat: one of the machines that people will archive from is used by more than one billable group (specifically, more than one research lab). I will need to be able to figure out which person has archived however much they did. While the idea of having more than one management class with different tape pools seems like a sound idea, I cannot necessarily rely on the users choosing the right class. Each user's directory has their name on it, so we can probably figure it out from a q arch on the client. Has anyone done this? I know how much we all love recharging, but that is out of my control. Thanks! --Jim
-- Paul Zarnowski Ph: 607-255-4757 Manager, Storage Services Fx: 607-255-8521 719 Rhodes Hall, Ithaca, NY 14853-3801 Em: [EMAIL PROTECTED]
