Bulk Email Sender Tracker

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

Bulk Email Sender Tracker.pdf

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

Shubham Varshney - RPA Listings & Projects | UiPath Marketplace

What is the top ROI driver for this use case?: Accelerate growth and operational efficiency. Best for avoiding deadlock in server.