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 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 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