In servicenow hrsd A&B team receives an excel report "inactive user in active hr groups" as an attachment on an email. Then an agent reviews the excel sheet apply filter as below on columns of excel sheet to get desired data:
A) column A- In "Emp status" filter out 'Ac' ,'AGE','ALF' values
B) column B- in "Web only" keep values 'false'
C) column C - in "Int user" keep value false
D) column D in "active" column filter out 'true'
E) in column E i.e. working: filter out 'yes'
Once the agent derives the desired data they submit a ritm via a catalog items to remove inactive users from active hr groups for that the agent needs to submit one ritm for each assignment group. The ask here is to automate this whole process. Also if the email is not received in sys_email table is there any way we can still achieve this
