Hi all,
Our compliance team is looking to generate a report on a monthly basis of computer assets where the last 5 logins are not by the assigned user of the asset showing in ServiceNow. "Assets in use, last 5 consecutive logins of any user which is not the "Assigned to" user of the asset (workstation)".
We are storing the following information in custom fields in "cmdb_ci_computer" table. The below fields are audited and every day SCCM is updating the following fields.
Last Access Time
Last User Email
Last User Login
The generated report should have the following information,
- Login user name
- login user id
- Last Access time of unassigned user login
And also the following information
- Assigned to user name
- Assigned to
- Assigned to Last access time
- Assigned to Asset tag/Property ID
- Assigned to Department
- Assigned to Division
- Assigned to VIP
What should be the design and how do I implement this?
