VOLUME OF DOCUMENTS ON ALFRESCO APPLICATION

[blueflame....@gmail.com]

Good Evening All,

Is it possible to know the volume of documents uploaded to the Alfresco application at any given time and if it is please how do i go about it.

Thanks and BR,

Ejike

[Younes REGAIEG]

Hey Ejike,

Did you check the DB query from this link : http://blog.dbi-services.com/alfresco-some-useful-database-queries/ ?

-- Younes

[blueflame....@gmail.com]

Thanks Younes.

Will do and give feedback.

[blueflame....@gmail.com]

Good day Younes,

Please Where do I have to put the sql queries? or can you give me a step by step approach as to where i can run the sql queries.

I know you need to execute them on the DB directly but how do i go about this and where do i extract the generated results?

Expecting your kind response.

Regards,

On Wednesday, January 11, 2017 at 1:29:47 PM UTC+1, Younes REGAIEG wrote:

[Younes REGAIEG]

Morning,

Depending on your DB, you may need to use a different client (mysql, psql, pg_admin...).

The steps for installing and using such a utility may differ from one OS to an other. You will probably need to ask google on how to do it on your own infrastructure.

Just one tip: make sure that you have access to the DB from the host you are running the client on (might need tweaking of pg_hba.conf or other config file depending on your db). But you can go safe and use the alfresco host to connect to the database and execute your query.

If you are interested I can provide a tool that we developed internally (care4alf), and are willing to share it for free. This addon will give you the possibility to evaluate SQL queries directly from a web interface (along with around 40 other cool features); But it needs to be installed as a dynamic extension https://github.com/laurentvdl/dynamic-extensions-for-alfresco/releases . Are you interested in giving it a run and providing some feedback about it ?

Regards,

Younes

--
You received this message because you are subscribed to a topic in the Google Groups "Alfresco Technical Discussion" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/alfresco-technical-discussion/AJQ-Ew24MKs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to alfresco-technical-discussion+unsub...@googlegroups.com.
To post to this group, send email to alfresco-technical-discussion@googlegroups.com.
Visit this group at https://groups.google.com/group/alfresco-technical-discussion.
For more options, visit https://groups.google.com/d/optout.

[sujay pillai]

** If you are using the default postgres provided by alfresco

Then the other option would be to navigate to your alfresco installation folder and you may find "postgres" and navigate to bin folder and execute -

./psql -U alfresco -d alfresco   [the password would be the same as in alf-global.properties]

​

Regards,

Sujay Pillai

On Thu, Jan 12, 2017 at 6:03 PM, Younes REGAIEG <y.re...@gmail.com> wrote:

Morning,

Depending on your DB, you may need to use a different client (mysql, psql, pg_admin...).

The steps for installing and using such a utility may differ from one OS to an other. You will probably need to ask google on how to do it on your own infrastructure.

Just one tip: make sure that you have access to the DB from the host you are running the client on (might need tweaking of pg_hba.conf or other config file depending on your db). But you can go safe and use the alfresco host to connect to the database and execute your query.

If you are interested I can provide a tool that we developed internally (care4alf), and are willing to share it for free. This addon will give you the possibility to evaluate SQL queries directly from a web interface (along with around 40 other cool features); But it needs to be installed as a dynamic extension https://github.com/laurentvdl/dynamic-extensions-for-alfresco/releases . Are you interested in giving it a run and providing some feedback about it ?

Regards,

Younes

On Thu, Jan 12, 2017 at 10:25 AM, <blueflame.engineering@gmail.com> wrote:

Good day Younes,

Please Where do I have to put the sql queries? or can you give me a step by step approach as to where i can run the sql queries.

I know you need to execute them on the DB directly but how do i go about this and where do i extract the generated results?

Expecting your kind response.

Regards,

On Wednesday, January 11, 2017 at 1:29:47 PM UTC+1, Younes REGAIEG wrote:

Hey Ejike,

Did you check the DB query from this link : http://blog.dbi-services.com/alfresco-some-useful-database-queries/ ?

-- Younes

On Tuesday, January 10, 2017 at 6:45:29 PM UTC+1, blueflame....@gmail.com wrote:

Good Evening All,

Is it possible to know the volume of documents uploaded to the Alfresco application at any given time and if it is please how do i go about it.

Thanks and BR,

Ejike

--
You received this message because you are subscribed to a topic in the Google Groups "Alfresco Technical Discussion" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/alfresco-technical-discussion/AJQ-Ew24MKs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to alfresco-technical-discussion+unsub...@googlegroups.com.
To post to this group, send email to alfresco-technical-discussion@googlegroups.com.
Visit this group at https://groups.google.com/group/alfresco-technical-discussion.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Alfresco Technical Discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to alfresco-technical-discussion+unsub...@googlegroups.com.