Computer - How to Track when laptop was last used?

[GChat]

Hi All,

I'm looking to build a report that shows when a user was last logged into a laptop but I cant find the best way to do it.

I've checked sys_user and this is good for service now login times but I'm trying to track users last login time  on their laptop if possible.

Does anyone know best way to do this?

[Paulo Andrielli]

Do you have any external database connection in Servicenow, like SCCM?

Usually, the SCCM, or other discovery tools scans the company's network, and log this in a database; this database can be linked to cmdb_ci_pc_computer table in Servcienow, and it includes the "Most Recent Discovery" date, when user was logged in the system.

We have such conneciton here, and we leverage this field for many kind of reports, like computer in use that are not logged for a while, or even computers set as "retired" that has a recent discovery date.

[GChat]

Hi Paulo,

Yeah we use MECM for laptops. I'm pretty sure this has the info on it too but was looking to build out a dashboard to use.

Yeah we have similar rules here that move computer to retired after 45 days no use. So the info is there but how is best to get into Snow?

[Paulo Andrielli]

If you have this info and is not connected to Servicenow, maybe you can export to other kind of databases and merge both info (usually serial number is the key field).

[RaghavSh]

Check "sys_user_presence" table and columns in that table, it give you information about user's device and other useful informations.