For query assistance, please see the following Best Practices guide
The Sophos UK Sales engineering team has been getting familiar with live discover. In the work they explored group policy and provided the following queries:
Deleted security groups -
Variable to specify the number of days to checkWindows
/* Deleted Security Groups */SELECT source, eventid, CAST(datetime(time, 'unixepoch') AS TEXT) AS 'Change Made',…
Last week SophosLabs published a report about the Glupteba malware. According to Sophos Labs this malware family has been growing in numbers. "This malware, with its hard-to-pronounce name, has been getting regular updates and feature enhancements that seem to be focused on its ability to conceal itself from detection on infected computers....The core malware is, in essence, a dropper with extensive backdoor functionality, but…
In the next two weeks we will be fully launching the EDR Live Discover for LINUX.
The capabilities on Linux are simply astounding, we have been busy creating the prebuilt queries and finishing the last bit of work before this is fully available.
In the video, Ethan Vince-Urwin, one of the core linux developers who has been building the features we all love takes the product for a test drive and shows off some of the power…
See the story from SophosLabs Uncut on KingMiner: https://news.sophos.com/en-us/2020/06/09/kingminer-report/
The article is both educational and enlightening. One of the aspects of KingMiner that is common with other attacks is that many of the indicators of compromise are non-deterministic. The domain names and URLs they use are all auto generated. I read…
We have added a new table to the sophos forensics journals. The sophos_process_activity table.
Often as part of an investigation you need to to get a quick view of what a process did in the past and this table provides a quick lookup location for that information.
This table contains a subject for each of the other Sophos 'journals' and collects some of…
Posting a query to the Live Discover Queries board will now include a review process. This will allow us to review any question and proposed answer prior to it being visible by others. We are adding this to ensure that the content of the queries do not contain anything inappropriate and that the query has been reviewed and tested and is not believed to cause harm. as for how well it does what it says. we advise administrators…
While we have the schema posted on the EAP community pages, I have had a number of request for how to find it and how to use it.
First how to find the schema(s):
From the Sophos Community: We provide a link to definition of the sophos windows schema on the community form in the documents section. You can downlaod the file with this link: https://community…
Starting on the week of may 18 we will be adding variable support to queries.
You can create queries that now include support for up to 6 variables. A variable will be given a $$ prefix and postfix and can be either a TEXT or DATE value. You will write your query and specify the variable information in the query. Then when you run it you will be able to simply drop in the information for the variable and we will automatically…
The week of May 18 we will be turning on two powerful new capabilities in the EAP, Edit Query and Query Variables.
CREATE, SAVE queries - With this new capability you can now create and save your own queries, This will allow you to start from scratch or modify an existing query. You will need to give your query a name, description, identify one or more categories it will be a part of and specify what operating systems…
Note: Use of all features and functionalities provided under the Early Access Program is subject to the Sophos End User License Agreement.
We are excited to announce that Live Response is now available in early access.
Live Response allows admins to remotely connect to devices and get access to a command line interface so that detailed investigations can be performed, or to take prompt action to contain or remediate a…
Can you help to shape our future products?
We're looking for customers and partners to join our Sophos Design Partner group. Sign up and you'll be able to give us your product feedback and ideas through surveys, interviews, or usability testing.
You'll be helping to make the world a safer place -- and you might win Amazon vouchers while you're doing it.
We’re particularly keen to talk to customers who…
I'm pleased to say that a new version of our endpoint user interface is being released to EAP customers this week. Windows devices (client and server) enrolled in the EAP will receive the update automatically.
The key goal of the update is to better represent Sophos' different endpoint components - Intercept X, Central Device Encryption and our upcoming UEM agent. It will also to bring a consistent look across platforms…
We are excited to announce that we have added our new Linux EDR agent to the New Server Protection and EDR Features early access program.
Joining the EAP:
To get access to the new agent you must first join the New Server Protection and EDR Features early access program. See this presentation on how to join the EAP.
Getting access to the agent and installing:
Once you have successfully joined, from the Protect Devices…
We are excited to announce that Intercept X Advanced with EDR v3.0 with Live Discover is now available in early access.
Live Discover allows admins to search their data to answer almost any question they can think of by searching across their endpoints and servers using SQL. You can…
In early April we are extending the Early Access Program to add Live Discover
Watch the 5 min video. https://vimeo.com/401888432