Hi,
Need a little advise regarding the objects in my content store.
The CMOBJPROPS7 is used to store the XML of reports right?
I have 2 schemas prod and test, I've taken a copy of prod at a database level and copied it into test and did a rowcount on each to check, both have 298737 rows.. all good.
I ran a clean up in test using "New Content Maintenance Task wizard: Content Removal" not sure if this is new to 11, but anyway, after checking "run history" and "output versions" and removing anything older than 3 months, my row count comes down to 47097
So my question is, does Cognos keep version of xml or has it just deleted 250'000 reports ?