Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: Report on user activity

Report on user activity 4 months 1 week ago #67831

  • JulianHarmer
  • JulianHarmer's Avatar
  • Offline
  • Junior Member
  • Posts: 37
  • Thank you received: 1
  • Karma: 0
I wanted an easy way of letting my partner know what I've been doing all day / week.

I thought I could write a report that queries the modules leads, contacts and accounts, to show all alterations my user, Julian, since date "Whatever it was on Monday"

I can't work out how to do this from the SuiteCRM interface. Does anyone have any pointers?

Thanks

julian
The administrator has disabled public write access.

Report on user activity 4 months 1 week ago #67835

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
Have you looked at the Reports module?

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: JulianHarmer

Report on user activity 4 months 1 week ago #67840

  • JulianHarmer
  • JulianHarmer's Avatar
  • Offline
  • Junior Member
  • Posts: 37
  • Thank you received: 1
  • Karma: 0
Yes, but it seems to only report on a single module, say contacts. I've read the documentation docs.suitecrm.com/user/advanced-modules/reports/

but it appears you can only generate reports on one module.

Is there any other suggestions?

Julian
The administrator has disabled public write access.

Report on user activity 4 months 1 week ago #67844

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
You can check the SuiteCRM Store for more advanced reporting, but you will probably have to pay...

If I were you I would just make an SQL script to extract the data from the database, and then feed it into Excel or some other tool to make it look pretty.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: JulianHarmer

Report on user activity 4 months 1 week ago #67846

  • JulianHarmer
  • JulianHarmer's Avatar
  • Offline
  • Junior Member
  • Posts: 37
  • Thank you received: 1
  • Karma: 0
That sounds the best option, thanks
The administrator has disabled public write access.

Report on user activity 4 days 15 hours ago #73107

  • jonsavas
  • jonsavas's Avatar
  • Offline
  • New Member
  • Posts: 7
  • Karma: 0
Did you ever write a script to extract this information, or find another solution?


Thanks
The administrator has disabled public write access.

Report on user activity 1 day 19 hours ago #73220

  • mvnrsa
  • mvnrsa's Avatar
  • Offline
  • New Member
  • Posts: 13
  • Thank you received: 4
  • Karma: 0
Hi,

Give my AdvancedReports module I try. It will allow you to build a report with any DB query which could be a UNION over multiple queries on multiple tables or even a storec proc on the database. mjvn.com/index.php/sugarcrm-tools/

It's a work in progress, but it can definitely do what you want. If you can write a DB query that returns the data, it can turn it into a pretty(ish) report for you.
Marnus van Niekerk
The administrator has disabled public write access.

Report on user activity 1 day 13 hours ago #73227

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
That looks cool, Marnus! B-)

And a nice and generous MIT License too! Thanks!

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
The following user(s) said Thank You: mvnrsa

Report on user activity 21 hours 42 minutes ago #73249

  • pgr
  • pgr's Avatar
  • Offline
  • Administrator
  • Posts: 7883
  • Thank you received: 1221
  • Karma: 286
@jonsavas, @JulianHarmer

Also check out this any-SQL Dashlet solution that produces Google Charts:

suitecrm.com/suitecrm/forum/developer-he...rt-funnel-chart-etc/

Note that Google Charts can just as easily output a nice, interactive table.

My SuiteCRM In-depth blog.
Thank you for always stating your SuiteCRM version, checking your logs, reading the Docs, and searching before you ask!
The administrator has disabled public write access.
Time to create page: 0.061 seconds
Powered by Kunena Forum