OCA 7.1 Custom SQL Help

[backupG]

I am hoping somone can help me create a custom sql script.  I need the following information:

For each client in the environments,

• A count of unexpired images
• Sum of the total size in GB or TB for client's unexpired images

Thanks for any help you can provide.

[Filip_Hasa]

Hi man,

 you shloud start here SELECT * FROM "DBA"."domain_Image".

 Be carefour Symantec has time in milisecond from begin of UNIX epoch. ;o)

 Here is explanation of each column http://www.symantec.com/docs/TECH5584

filip