I have FileNet Image Services, version 4.0.40 (not 100% sure). No access to the administrative interface, only Unix console, and database (Oracle). I need to get total document size, and also size of specific document class on disk. How do I do that?
1 Answer
Normally you would use the API with the call get_ContentSize()
. If you can access the database, look for the docversion table in the object store db, I think you can also get the property directly from the DB there, If you then join the table with the classdefinition table you can look.
Here is an example of the query
select dv.object_id, vd.content_size from objectstore.docversion dv
inner join objectstore.classdefinition cl on dv.object_class_id = cl.object_id
where cl.symbolic_name = 'yourclassname'