ag-michael

<style>
#reportrow {
  position:relative;
  overflow-wrap:anywhere;
  border-bottom:solid 1px;
}
</style>

<div class="panel panel-info" ng-if="success">
    <div class="panel-heading">

ag-michael

timestamp convert:

 convert ctime(timestamp/1000)

.top,.club,.xyz,.ru domain lookups where the amount of lookup for the domain is more than 1 and less than 4 per computer

aid=* event_simpleName=DnsRequest | regex DomainName=".*\.top$|.*\.club$|.*\.xyz$|.*\.ru$|[0-9]+.*\.\w$" | stats values(ComputerName) count by DomainName| where count <4 | sort – count

ag-michael

def thehive_alert(alert):
    global CONFIG
    authheader={'Content-Type': 'application/json', 'Authorization': 'Bearer '+CONFIG['thehiveapikey']}
    print(requests.post("http://127.0.0.1:9000/api/alert",headers=authheader,data=json.dumps(alert),verify=False))

myfile=''
try:
    with open(fname,"rb") as f:
        myfile=fname+";text/plain;"+base64.b64encode(f.read())
except Exception:

ag-michael

import sys
import datetime
from thehive4py.api import TheHiveApi
from thehive4py.query import String

def mkstmp(ts,tfmt='%m/%d/%Y %H:%M CDT'):
        if not type(ts) is int:
                ts=int(ts)
        return datetime.datetime.fromtimestamp(ts/1000).strftime(tfmt)