Automate a report for user inactivity

RDRGSJ00 · 02/12/24

Hi, I was wondering if there was a way to automate a report that could be emailed for all users who haven't logged into Smartsheets in an "x" amount of time. So for example, a report would run monthly and email me all users who last logged in over 3 months. Any information is greatly appreciated.

Genevieve P. · 02/14/24

Hi @RDRGSJ00

I believe @Ryan Kramer's answer may have been generated by AI, and unfortunately this means it has incorrect information.

If you're a System Admin in Smartsheet you can download a Login History report in the Admin Center. This is a CSV file emailed to you with a list login history from the past 6 months. Here's a Help Article with more information: More actions in User Management

Cheers,

Genevieve

Ryan Kramer · 02/12/24

Hi there! Absolutely, there is a way to automate the report you're looking for in Smartsheet. Here's one approach you can take:

1. Create a report in Smartsheet that filters users based on their last login date. You can set the filter criteria to display all users who last logged in over 3 months.

2. Save the report for future use and ensure that it captures all the necessary information you want to include in the email.

3. Set up a recurring job using a task scheduler or a third-party automation tool (like Zapier or Integromat) that triggers the report to run and be emailed to you on a monthly basis.

4. Make sure to configure the email settings in the automation tool to send the report as an attachment to your desired email address.

By following these steps, you should be able to automate the generation and delivery of the report to your inbox every month, featuring all the users who haven't logged into Smartsheets for over 3 months.

Let me know if you have any further questions or need additional assistance!

Best,

Ryan Kramer (ryan@dynamicduo.io)

Automation Specialist / CEO @ DynamicDuo

Have you backed up your solution lately? Try SmartsheetBackups today!

RDRGSJ00 · 02/12/24

Thank you so much for the prompt response. I'm still new to Smartsheets so apologies for all the questions, but how would I:

1. Create a report in Smartsheet that filters users based on their last login date. You can set the filter criteria to display all users who last logged in over 3 months.

Genevieve P. · 02/14/24

Hi @RDRGSJ00

I believe @Ryan Kramer's answer may have been generated by AI, and unfortunately this means it has incorrect information.

If you're a System Admin in Smartsheet you can download a Login History report in the Admin Center. This is a CSV file emailed to you with a list login history from the past 6 months. Here's a Help Article with more information: More actions in User Management

Cheers,

Genevieve

RDRGSJ00 · 02/15/24

Thank you @Genevieve P.

MHalvey · 07/24/24

https://community.smartsheet.com/discussion/comment/419821#Comment_419821

@Genevieve P. - Is there a way to automate running these reports (Log in History, Sheet Access, etc) in the admin center? I'd like to have them run weekly to my email and then get the data to move back into Smartsheet to review for security reasons approved IP addresses or sheet access, etc.

Thanks - Michael

Genevieve P. · 08/14/24

Hi @MHalvey

There currently isn't a way to have these reports run automatically at this time - you will need to go into the Admin Center manually to download/export them.

Automate a report for user inactivity

Best Answer

Answers

Categories