Vault7: CIA Hacking Tools Revealed
Navigation: » Directory » User #20251227 » User #20251227’s Home
Owner: User #20251227
Scratch Pad
| ljkdjljdfj | jklkjlkjlkj | jljlkjljklj | ljljlkljlkjl |
|---|---|---|---|
| aaa | ssss | ssss | sssss |
select client_id, parent_id, instance_id, comment, prevsess as 'PREVIOUS SESSION (UTCCoordinate Universal Time)', LAST_KNOWN_CONFIG as 'CONFIG REPORTED ON', interval, delta FROM
(
CLIENT_TABLE LEFT OUTER JOIN(
select client_id, established_datetime as prevsess FROM
((CLIENT_TABLE LEFT OUTER JOIN SESSION_TABLE USING(client_id)) AS cs1)
where cs1.established_datetime = (
select MAX(established_datetime) FROM
((CLIENT_TABLE LEFT OUTER JOIN SESSION_TABLE USING(client_id)) AS cs2)
where cs1.client_id = cs2.client_id)
) USING(client_id) LEFT OUTER JOIN(
select client_id, reported_datetime as 'LAST_KNOWN_CONFIG', interval, delta FROM
((((CLIENT_TABLE LEFT OUTER JOIN CLIENT_DYNCONFIG_BRIDGE_TABLE USING(client_id)) LEFT OUTER JOIN CONFIG_DYNAMIC_TABLE USING(dynamic_config_id)) LEFT OUTER JOIN CONFIG_PULSE_TABLE USING(pulse_config_id)) as cp1)
where cp1.reported_datetime = (
select MAX(reported_datetime) FROM
((((CLIENT_TABLE LEFT OUTER JOIN CLIENT_DYNCONFIG_BRIDGE_TABLE USING(client_id)) LEFT OUTER JOIN CONFIG_DYNAMIC_TABLE USING(dynamic_config_id)) LEFT OUTER JOIN CONFIG_PULSE_TABLE USING(pulse_config_id)) as cp2)
where cp1.client_id = cp2.client_id)
) USING(client_id)
);
sqlite> .read scratchpad.txt
clien parent_id instance_id comment PREVIOUS SESSION (UTCCoordinate Universal Time) CONFIG REPORTED ON interval delta
----- ------------------------------------ ----------- ---------- ---------------------- ------------------ ---------- ----------
1 B596FD92-0AC2-465A-AC17-303FDDDB9191 Parent #1
2 F88663EC-85F6-425D-AC42-2A0A8FB03F93 Parent #2
3 E58A8D39-0AAA-48FD-8D34-3AFA623D4494 Parent #3
4 F88663EC-85F6-425D-AC42-2A0A8FB03F93 D7AB429D-D0 1st Chil1d 915180600 915180600 3600 600
5 F88663EC-85F6-425D-AC42-2A0A8FB03F93 D79272B5-74 2nd Chil1d 915222600 915222600 36000 3600