Activity log of all smartsheet usage under my admin

PMTommy

现在有一个API或某种程度上发现了什么the last time a smartsheet was accessed? I don't want to have to traverse the settings behind each smartsheet and export a report one-by-one.

I didn't see any recent threads about some API access to that information.

Thank you!!

ker9

It may depend on the type of plan you have and the your rights under that plan. As an Admin on an Enterprise plan, I have access to that information.

PMTommy

Yea, I have access to it as our primary admin. I can pull activity PER sheet, but I want to generate a report for all sheets with the click of a button and not by having to go thru each sheet. Then with that report I can gather the info I need about how they are being used.

Thanks for the response.

Karen Harker

I was just trying to do this myself and had the same desire. Also, the format of the activity log is not conducive to analysis.

ker9

@Karen Hansard@PMTommy

With an Enterprise plan, under User Management / More Actions you can download a Sheet Access report that will provide the last modified date/time for all sheets.

Hope this helps

PMTommy

Thanks at @ker9, but we are not asking for last time a sheet was modified. We want a report across all sheets in an account to show last time accessed. That's how we will know if sheets are being used.

We can do it per user, but I cannot log in to over 100 users (or get them to share with the admin) to check every sheet. And why doesn't an admin by default have access to all sheets.

It's all good. We are in the process of moving off of Smartsheet because we do not have a clear way of auditing across all users.

Andrée Starå

Hi@PMTommy

I hope you're well and safe!

Have you looked into the Event Reporting add-on?

It can provide you with much more information. Is that an option?

More info:

https://help.smartsheet.com/articles/2479296-event-reporting-monitor-how-data-is-used-across-your-organization

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PMTommy

@Andrée StaråIs that a paid add-on? I'll have to check and see if we have the Enterprise plan as well.