Bad Rabbit Scheduled Tasks

[ksnihur]

Description: Bad Rabbit Scheduled Tasks

What The Data Shows: Provides IOC for BadRabbit

SQL: 

SELECT name,action,path,enabled,state,hidden,
    datetime(last_run_time,"unixepoch","localtime") AS last_run_time,
    datetime(next_run_time,"unixepoch","localtime") AS next_run_time,
    last_run_message,last_run_code
FROM (`scheduled_tasks` )
WHERE (`name` = 'drogon') or (`name` = 'Rhaegel');

[jnelson]

@ksnihur would you please consider converting the time stamps from the table? Maybe something like this:

SELECT name,action,path,enabled,state,hidden,
    datetime(last_run_time,"unixepoch","localtime") AS last_run_time,
    datetime(next_run_time,"unixepoch","localtime") AS next_run_time,
    last_run_message,last_run_code
FROM (`scheduled_tasks` )
WHERE (`name` = 'drogon') or (`name` = 'Rhaegel');

[ksnihur]

hey @jnelson 

Updated as requested. I'll start doing that on all the new ones I submit. 

[jnelson]

@ksnihur Thanks on both counts!!