OnDemand User Group

Support Forums => Report Indexing => Topic started by: kader on September 23, 2016, 08:56:44 AM

Title: counting number of documents in CMOD
Post by: kader on September 23, 2016, 08:56:44 AM

Hi folks,

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

Thanks,

Kader

Title: Re: counting number of documents in CMOD
Post by: Joe Wolken on September 23, 2016, 10:10:27 AM

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

Title: Re: counting number of documents in CMOD
Post by: Justin Derrick on September 24, 2016, 04:02:13 AM

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.

Title: Re: counting number of documents in CMOD
Post by: ODSA on June 08, 2022, 01:18:33 PM

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

Title: Re: counting number of documents in CMOD
Post by: Justin Derrick on June 08, 2022, 02:33:49 PM

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

-JD.

Title: Re: counting number of documents in CMOD
Post by: ODSA on June 10, 2022, 03:07:48 PM

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