Bulk Email Sender Tracker
Use Case Description
Block Email Sender Tracker, use-case is a way to track number or emails send out in an organization or shared server by a user. Doing so we try to find out users who are sending spam/unwanted/bulk emails in the organization and avoid server clogging or bottle neck due to unwanted emails.
This can cause SLA breach for companies and cause server outage leading to email delivery time to be delayed.
Problem Statement:
Companies are unable to track the emails sent out in by the users in real time, till server outage occurs as it take a lot of time for them and need 3 FTE to track number of emails sent out by the users.
Solution:
Bot check’s the mundane repetitive task for the IT server team by checking the count of emails send out by the users and also calculate the count of emails sent out by the user per day. IT server team has set a threshold for email volume per user per hour. IT team has also white listed a few email id’s such as HR, CEO. In case the bot identifies any user that crosses the threshold and is not in the white listing, the bot triggers an email to the IT server management team and also goes into the system to block the user email id from sending any more email’s.
The bot also calculates number of emails sent out in a day per user and informs the server team in case it finds any user sending out many emails in a day above the set threshold.
Bot has an added functionality of finding out the number of emails sent out in an organization and informing the IT server team at end of every week. The bot basically uses these data to predict the number of emails that will be send out in the coming next week or year using Python code so that the server team can choose to either increase the server capacity or decrease the threshold value.
All the data is stored in a database and the same is visible on a dashboard for the IT server team.
Frequency of run - Every One Hour
FTE saved - 3-4 FTE Saved
Time for execution - 2 minutes
Pros - Real time monitoring and avoiding server clogging
AS-IS WORKFLOW, TO-BE WORKFLOW
Other information about the use case
Industry categories for this use case: Compliance, Information Technology and Services, Operations, Telecom
Skill level required: Intermediate
UiPath Products that were used: UiPath Studio, UiPath Action Center, UiPath AI Center, UiPath Assistant, UiPath Orchestrator
Other applications that were used: SQL, Email Server Management Tool
Other resources: Components Used:
You can view my other components by visiting the following link
What is the top ROI driver for this use case?: Accelerate growth and operational efficiency. Best for avoiding deadlock in server.