select * from listening_ports;

select liu.*, p.name, p.cmdline, p.cwd, p.root from logged_in_users liu, processes p where liu.pid = p.pid;

select distinct pid, path from process_open_files where path not like '/private/var/folders%' and path not like '/System/Library/%' and path not in ('/dev/null', '/dev/urandom', '/dev/random');

select distinct pid, family, protocol, local_address, local_port, remote_address, remote_port, path from process_open_sockets where path <> '' or remote_address <> '';

select opera_extensions.* from users join opera_extensions using (uid);

select * from pci_devices;

select * from process_envs;

select * from block_devices where type = 'Virtual Interface';

select * from users join shell_history using (uid);

select * from smbios_tables;