Hello @KrishnaMohan
The sysevent table will only have the last 7 days of data. To get the information you are looking for, you must create a customized script on a sysevent table to capture the required information to a custom table of your choice and use that table for reporting.
If you use a real-time Business Rule, it can create a lot of load on the instance as this is one of the busiest/frequently accessed system tables of the instance platform.
You can plan for a scheduled custom script that pulls the required information once a day during your NON-business hours. This can pull the required information (columns/data required) daily into the custom table of your choice and be used for reporting.
https://instancename.service-now.com/sysevent_list.do?sysparm_query=name%3Dlogin%5EORname%3Dlogout
- Name ==> login/logout
- Instance==> Session ID of the user
- Parm 1==> Username
- User id ==> sys_id of the user
- Username
- Claimed By ==> Node on which the user was logged.
- Created ==> timestamp of Login/logout activity
Please mark my answer helpful and solution accepted if it serves the purpose..
Regards,
Vaibhav
