logged_in_users

Users with an active shell on the system.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: logged_in_users

  • Windows

  • Linux

  • Mac OSX

  • Free BSD

Table schema

Name

Type

Description

type

TEXT

Login type

user

TEXT

User login name

tty

TEXT

Device name

host

TEXT

Remote hostname

time

INTEGER

Time entry was made

pid

INTEGER

Process (or thread) ID

sid

TEXT

The user’s unique security identifier

registry_hive

TEXT

HKEY_USERS registry hive

Query examples

Select all the results for the given table.

SELECT * FROM logged_in_users;