Report on user activity

SuiteCRM Forum - English Language SuiteCRM Feedback
1

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

2

Have you looked at the Reports module?

1 Like
3

Yes, but it seems to only report on a single module, say contacts. I’ve read the documentation https://docs.suitecrm.com/user/advanced-modules/reports/

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

Is there any other suggestions?

Julian

4

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.

1 Like
5

That sounds the best option, thanks

6

Did you ever write a script to extract this information, or find another solution?

Thanks

7

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. https://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.

8

That looks cool, Marnus! B-)

And a nice and generous MIT License too! Thanks!

1 Like
9

@jonsavas, @JulianHarmer

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

https://suitecrm.com/suitecrm/forum/developer-help/20227-how-to-add-other-charts-in-report-charts-for-ex-line-chart-bubble-chart-gauge-chart-funnel-chart-etc/

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