Export xml

s7
Tera Contributor

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.

1 ACCEPTED SOLUTION

Saurav11
Kilo Patron
Kilo Patron

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:-

 

Saurav11_2-1669969094333.png

 

 

Saurav11_0-1669968966160.png

 

Same way apply filter for sys_user_has_role table:-

 

User.last login is last 6 months:-

 

Saurav11_1-1669969024629.png

 

Then export the xml of both tables.

 

Please mark my answer as correct based on Impact.

 

View solution in original post

3 REPLIES 3

Gunjan Kiratkar
Kilo Patron
Kilo Patron

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 :-

GunjanKiratkar_0-1669968955666.png

 


Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy

Saurav11
Kilo Patron
Kilo Patron

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:-

 

Saurav11_2-1669969094333.png

 

 

Saurav11_0-1669968966160.png

 

Same way apply filter for sys_user_has_role table:-

 

User.last login is last 6 months:-

 

Saurav11_1-1669969024629.png

 

Then export the xml of both tables.

 

Please mark my answer as correct based on Impact.

 

Hello,

 

If my answer helped you can you also mark it as correct.

 

Thanks.