Richard,

Thank you very much, that worked.

Geoff

-----Original Message-----
From: Richard Sims [mailto:rbs AT BU DOT EDU]
Sent: Wednesday, July 09, 2003 10:34 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Issues with auditocc table


>I am running the following SQL command against my database and coming up
>with several nodes that have 0 MB in the archive_mb and backup_mb columns,
>but they should not be that way.
>
>select node_name,backup_mb,archive_mb from auditocc
>
>Yet if I run the command below to the occupancy table, it shows that these
>same nodes have data in the database.  Can anyone explain the difference in
>the two tables, and why the auditocc table shows no data for these nodes?
>
>select node_name,physical_mb,logical_mb from occupancy

You didn't say whether you ran the requisite 'AUDit LICenses' before
querying the AUDITOCC table... ?

  Richard Sims, BU