- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2022 12:11 AM
Hii,
How to take XML back up of "sys_user" , "sys_user_grmember " , "sys_user_has_role" - based on last login of 6 months?
>>for "sys_user" table i have taken export of xml, and i want to know how "sys_user_grmember " , "sys_user_has_role"
tables to export based on last 6 months??
Please someone help me.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2022 12:18 AM
Hello,
You can use the below filter on sys_user_grmember for logged in users in last 6 months:-
User.last login is last 6 months:-
Same way apply filter for sys_user_has_role table:-
User.last login is last 6 months:-
Then export the xml of both tables.
Please mark my answer as correct based on Impact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2022 12:16 AM
Hi @s7 ,
On the basis of what you want the report based on last 6 months?
Is it created or updated ?
Apply filter as below :-
Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2022 12:18 AM
Hello,
You can use the below filter on sys_user_grmember for logged in users in last 6 months:-
User.last login is last 6 months:-
Same way apply filter for sys_user_has_role table:-
User.last login is last 6 months:-
Then export the xml of both tables.
Please mark my answer as correct based on Impact.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2022 12:24 AM
Hello,
If my answer helped you can you also mark it as correct.
Thanks.