I don't think the criteria for getting auditocc info for the node names is
quite right. Try this:

select nodes.node_name as "Client_Name", \
       date(nodes.lastacc_time) as "Last Access", \
       auditocc.total_mb as "Total Storage" \
   from nodes, auditocc \
   where nodes.node_name = auditocc.node_name \
   order by 2

Also, make sure you run AUDIT LICENSE prior to the above in order to
ensure most up-to-date numbers.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/27/2006
01:08:42 PM:

> I'm trying to generate a report for storage abusers, just three columns:
>
> Client Name      Last Access         Total Storage
>
>
> This is the SQL statement That comes close:
>
> select distinct(nodes.node_name) as "Client
Name",date(nodes.lastacc_time)
> as "Last Access" ,auditocc.total_mb as "Total Storage" from
nodes,auditocc
> where auditocc.node_name in (select node_name from nodes where
> domain_name='xxx ) order by 2
>
> but column three is always wrong.
>
> What do I need to do to make the proper join here?
>
>
>
> Fred Johanson
> ITSM Administrator
> University of Chicago
> 773-702-8464