Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT FROM_UNIXTIME(`oob_time_sec`) AS "Data", INET_NTOA(CONV(TRIM(LEADING 'FFFF' FROM TRIM(LEADING '0' FROM HEX(`ip_saddr`))), 16, 10)) AS "Source IP", INET_NTOA(CONV(TRIM(LEADING 'FFFF' FROM TRIM(LEADING '0' FROM HEX(`ip_daddr`))), 16, 10)) AS "Dst. IP", `tcp_sport` AS "Source port", `tcp_dport` AS "Dst. Port", `mac_saddr` AS "Source MAC", `mac_daddr` AS "Dst. MAC" FROM `nulog`.`nulog`
Advertisement
Add Comment
Please, Sign In to add comment
