Hi

Can anybody explain to me those output......

1. Running a Q OCC system_1 got:


Node Name            Type     Filespace      Storage        Number of
Physical       Logical
                             Name                      Pool Name   Files
Space         Space

Occupied    Occupied

(MB)          (MB)
----------------         ----       ----------         ----------
---------           ---------     ---------
---------           ---------     ---------
SYSTEM_1             Bkup      <file://\\system> \\system_-     SCA_PC
SYSTEM_1             Bkup      <file://\\system> \\system_-     SCA_PC
476              71.87         66.98
                                         1\c$


2. Running this macro to get the active version of this node got:

ANS8000I Server command: 'Select filespace_name, count(ll_name) as " Active
Data Files" from backups where node_name='SYSTEM_1' and
state='ACTIVE_VERSION' group by filespace_name'

FILESPACE_NAME          Active Data Files
------------------               -------------------
 <file://\\system_1\c$> \\system_1\c$                     2038
 <file://\\system_1\c$> \\system_1\c$                     2038

My question is how the number of files in Q OCC is lower (active and
inactive version)  than the output of the macro  ???????????????

Did my macro is wrong ..........

Regards Robert Ouzen