Text only | Text with Images

OnDemand Users Group

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

Title: counting number of documents in CMOD
Post by: kader on September 23, 2016, 03:56:44 PM
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, 05:10:27 PM
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, 11: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, 08: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, 09: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, 10: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!!
Text only | Text with Images