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);
select client_id, reported_datetime, interval, delta FROM
...> ( (CLIENT_DYNCONFIG_BRIDGE_TABLE INNER JOIN CONFIG_DYNAMIC_TABLE USING(dynamic_config_id))INNER JOIN CONFIG_PULSE_TABLE USING(pulse_config_id) ) AS t1
...> where t1.reported_datetime = (SELECT MAX(reported_datetime) FROM
...> ( (CLIENT_DYNCONFIG_BRIDGE_TABLE INNER JOIN CONFIG_DYNAMIC_TABLE USING(dynamic_config_id))INNER JOIN CONFIG_PULSE_TABLE USING(pulse_config_id) ) AS t2
...> WHERE t2.client_id = t1.client_id);