Vault7: CIA Hacking Tools Revealed
Navigation: » Latest version
Owner: User #20251227
Scratch Pad
| ljkdjljdfj | jklkjlkjlkj | jljlkjljklj | ljljlkljlkjl |
|---|---|---|---|
| aaa | ssss | ssss | sssss |
sqlite> select parent_id, instance_id, MAX(established_datetime) AS 'MOST RECENT' from (CLIENT_TABLE LEFT OUTER JOIN SESSION_TABLE USING(client_id)) GROUP BY client_id ORDER BY parent_id,instance_id;
select * from ((CLIENT_TABLE LEFT OUTER JOIN CLIENT_DYNCONFIG_BRIDGE_TABLE USING(client_id)) LEFT OUTER JOIN (CONFIG_PULSE_TABLE LEFT OUTER JOIN CONFIG_DYNAMIC_TABLE USING(pulse_config_id)) USING(dynamic_config_id));
select parent_id, instance_id, MAX(reported_datetime), interval, delta from (
...> select * from ((CLIENT_TABLE LEFT OUTER JOIN CLIENT_DYNCONFIG_BRIDGE_TABLE USING(client_id)) LEFT OUTER JOIN (CONFIG_PULSE_TABLE LEFT OUTER JOIN CONFIG_DYNAMIC_TABLE USING(pulse_config_id)) USING(dynamic_config_id))
...> )
...> GROUP BY (client_id);