Need to create a Report when user location changes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 10:15 AM
Hi,
I have to create a Report whenever the user location changes but location is a reference filed I'm unable to find changes operator. And need to check whether that user is a member of a specific group.
Can you provide a solution to achieve this requirement.
Thanks in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 10:36 AM
Hi, @AshokB442025363
To create a report in ServiceNow that triggers whenever a user's location changes and checks whether that user is a member of a specific group, follow these steps:
- Use a Business Rule to detect changes in the location field and log the changes to a custom table.
- Check Group Membership within the same Business Rule.
- Create a report based on the data logged in the custom table.
- Optionally, set up notifications to alert relevant stakeholders of the location change.
This approach ensures that you can track changes in the user's location and verify their group membership efficiently.
Let me know if you need further clarifications!
Thanks, Regards!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-19-2024 12:04 PM
I don't think the issue is that it is a reference field. I think the issue is that you are trying to create a report. Reports do not have the operator of changes. Can you explain more of what you are trying to achieve so we can help you with a solution?