How can Flow Designer email the schedule for the day?

[Sato3]

Hi, All.

I would like to use Flow Designer to fulfill the following requirements. Do you have any advice?

Requirements : 

Every day, once a day, if the Last_login field in the User [sys_user] table contains today's date, I would like to email the user who is the instance administrator with the login record information for the day.

This requirement seems feasible, but is there any good idea?

Thank you

[Sato3]

Hi, @Vishnu Prasad K G .

As a requirement, when the last login field is updated in Flow Designer, we want to be notified on a daily basis, so we do not want to be notified repeatedly during the day.

[Hitoshi Ozawa]

Hi Sato,

It would be easier to create a Report and then set up Scheduled Reports to send the report in email.

1. Create a report
1. From Navigator, select "Reports" > "Create New"
2. Enter as follows and click on the "Next" button
   Report name: Users logged in Today
   Source type: Table
   Table: User [sys_user]
3. Select "List" as report type
4. Set filter condition as follows.
   "Last login" "on" "Today"
   It may be better to filter by "Yesterday" depending on when the reports is to be generated.
   
5. Click on the "Run" button to create a report. If alright, click on the "Save" button.
2. Create a Scheduled Report
1. From Navigator, select "Reports" > "Scheduled Reports"
2. Click on the "New" button
3. Enter necessary information and click on the "Submit" button.

[Sato3]

Hi, @Hitoshi Ozawa .

Certainly it works easily and is perfect for performance.

However, as a requirement this time, in Flow Designer, the instance administrator must be notified to the user who logs in to the instance every day (holds admin authority).

I haven't dared to mention permissions, but from an administrative point of view of SserviceNow, implementing in Flow Designer is the only approach to customers.

If possible, it would be greatly appreciated if you could provide information on that approach in Flow Designer.

[Hitoshi Ozawa]

> the instance administrator must be notified to the user who logs in to the instance every day (holds admin authority).

I'm not understanding. The statement just implies sending an email to an instance administrator. Does the question imply only listing and emailing instance administrator's login activities? This can also be setup in a filter.

ServiceNow allows users to define dynamic filters that can be used as filter conditions. Dynamic filters are capable of calling Script Includes.

https://docs.servicenow.com/bundle/quebec-platform-user-interface/page/use/using-lists/task/t_Dynami...

[Sato3]

Hi, @Hitoshi Ozawa .

In instance management, it is natural to manage users, but it is also necessary to manage users who have Admin privileges, which are privileged users.

インスタンス管理において、ユーザー管理を行うのは当然ですが、特権ユーザーであるAdmin権限を保持しているユーザーの管理も怠ることは出来ません。

Therefore, if a user with Admin privileges logs in to the instance that day, they must notify the responsible person of the logged-in user information for that day, because they just want to implement it in Flow Designer.

したがって、その日にAdmin権限を持つユーザーがインスタンスにログインした場合、その日の分のログインしたユーザー情報を責任者へ通達しなければなりません、それをただFlow Designerで実装したいだけなのでです。