

SELECT * FROM malware_removal WHERE file_path='/tmp/hello0'.osqueryi -extension /osquery-malware-removal/osquery-malware-removal.Test Osquery extension Load Osqueri with extension GOOS=linux GOARCH=amd64 go build -o osquery_malware_removal.elf osquery-malware-removal.go.GOOS=darwin GOARCH=amd64 go build -o osquery_malware_removal.macho osquery-malware-removal.go.GOOS=windows GOARCH=amd64 go build -o osquery_malware_removal.exe osquery-malware-removal.go.Each description, a.k.a rule, consists of a set of strings and a boolean expression which determine its logic. With YARA you can create descriptions of malware families (or whatever you want to describe) based on textual or binary patterns. YARA is a tool aimed at (but not limited to) helping malware researchers to identify and classify malware samples. You can then have Osquery load the extension in your desired context (ie: in a long-running instance of OsqueryD or during an interactive query session with Osqueryi). To create an extension, you must create an executable binary that instantiates an ExtensionManagerServer and registers the plugins that you would like to be added to Osquery. This project contains Go bindings for creating Osquery extensions in Go. are implemented via a robust plugin and extensions API. In Osquery, SQL tables, configuration retrieval, log handling, etc. SQL tables are implemented via a simple plugin and extensions API.

With Osquery, SQL tables represent abstract concepts such as running processes, loaded kernel modules, open network connections, browser plugins, hardware events or file hashes. This allows you to write SQL-based queries to explore operating system data. Osquery exposes an operating system as a high-performance relational database. This blog post will act as documentation for the setup and operation of this Osquery extension. This extension has the ability to delete files, kill processes, delete directories, and can be used with the builtin YARA table. This blog post is going to cover an Osquery extension that I engineered with osquery-go to eradicate malware.
