counting number of documents in CMOD

[kader]

Hi folks,

Is there a way to count the number of documents stored in CMOD?

Thanks,

Kader

[Joe Wolken]

You may find the information you are looking for by running various queries on the ARSSEG file.

[Justin Derrick]

Yup, there's an article on the Wiki that demonstrates exactly what you're asking:

http://cmod.wiki/index.php/Useful_SQL_Queries_for_Content_Manager_OnDemand

-JD.

[ODSA]

Hi Justin,

Thanks for sharing useful tips here.

I am trying to get count of all the documents that we have in our CMOD today, I tried below command but the AG count doesn't match with what I have in CMOD (the count comes to be less than what I have in CMOD).

db2 "select arsag.name,sum(arsseg.ins_rows-arsseg.del_rows) as Total_Rows from arsag,arsseg where arsag.agid=arsseg.agid group by arsag.name"

I get 1137 record(s) selected vs I have 1461 AGs in CMOD.

Would you know why there is the difference in the record count?

Thanks Ahead !!

[Justin Derrick]

I'm guessing you have a large number of empty App Groups.

-JD.

[ODSA]

I spot checked some of the AGs that are missing from the list, they are actually empty. Yeah, seems like we have few 100 empty AGs.

Thanks for the help!!