HackMD
    • Create new note
    • Create a note from template
    • Sharing Link copied
    • /edit
    • View mode
      • Edit mode
      • View mode
      • Book mode
      • Slide mode
      Edit mode View mode Book mode Slide mode
    • Customize slides
    • Note Permission
    • Read
      • Only me
      • Signed-in users
      • Everyone
      Only me Signed-in users Everyone
    • Write
      • Only me
      • Signed-in users
      • Everyone
      Only me Signed-in users Everyone
    • Commenting & Invitee
    • Publishing
      Please check the box to agree to the Community Guidelines.
      Everyone on the web can find and read all notes of this public team.
      After the note is published, everyone on the web can find and read this note.
      See all published notes on profile page.
    • Commenting Enable
      Disabled Forbidden Owners Signed-in users Everyone
    • Permission
      • Forbidden
      • Owners
      • Signed-in users
      • Everyone
    • Invitee
    • No invitee
    • Options
    • Versions and GitHub Sync
    • Transfer ownership
    • Delete this note
    • Note settings
    • Template
    • Save as template
    • Insert from template
    • Export
    • Dropbox
    • Google Drive Export to Google Drive
    • Gist
    • Import
    • Dropbox
    • Google Drive Import from Google Drive
    • Gist
    • Clipboard
    • Download
    • Markdown
    • HTML
    • Raw HTML
Menu Note settings Sharing Create Help
Create Create new note Create a note from template
Menu
Options
Versions and GitHub Sync Transfer ownership Delete this note
Export
Dropbox Google Drive Export to Google Drive Gist
Import
Dropbox Google Drive Import from Google Drive Gist Clipboard
Download
Markdown HTML Raw HTML
Back
Sharing
Sharing Link copied
/edit
View mode
  • Edit mode
  • View mode
  • Book mode
  • Slide mode
Edit mode View mode Book mode Slide mode
Customize slides
Note Permission
Read
Only me
  • Only me
  • Signed-in users
  • Everyone
Only me Signed-in users Everyone
Write
Only me
  • Only me
  • Signed-in users
  • Everyone
Only me Signed-in users Everyone
Comment & Invitee
Publishing
Please check the box to agree to the Community Guidelines.
Everyone on the web can find and read all notes of this public team.
After the note is published, everyone on the web can find and read this note.
See all published notes on profile page.
More (Comment, Invitee)
Commenting Enable
Disabled Forbidden Owners Signed-in users Everyone
Permission
Owners
  • Forbidden
  • Owners
  • Signed-in users
  • Everyone
Invitee
No invitee
   owned this note    owned this note      
Published Linked with GitHub
Like BookmarkBookmarked
Subscribed
  • Any changes
    Be notified of any changes
  • Mention me
    Be notified of mention me
  • Unsubscribe
Subscribe
# osquery office hours 2022-06-07 YouTube Link: https://www.youtube.com/watch?v=Lxa8s54jdA8 ## Announcements and Highlights since the last meeting * 5.3.0 wsa cut * In q3, ToB is likely to work on windows arm support * Sharvil might be giving a talk on endpointsecurity and osquery at macdevops * WWDC22 Announced some new ES things. These are some interesting looking events. Might be an Apple tool to explore. TBD! ## Any Questions / Issues / PRs people want to discuss? The intent of this section is to provide a clear time for community members to bring up _anything_. Broad questions? Bugs? Deployment questions? Blocked PRs? ## 5.3.0 Can we mark it as stable? There's a known issues in the tests, but this is testing only. (https://github.com/osquery/osquery/pull/7621) Anyone tested it? * Sharvil on a couple machines * Zach will try to push to Fleet's Edge channel * seph will try to push to Kolide's beta channel ## Watcher for disk Should osquery measure the disk usage in terms of IOPS or write/read throughput? Some queries will do a lot of rocks access, which will, in turn, cause a lot of disk IO. Alessandro is concerned that this is an odd direction: * If one is interested in data integrity, than you have to take the diskIO * If one is interested in performance, than we should explore alternate DBs (Like the PR from packetzero from a couple years ago) Alessandro thinks that the watchdog is incompatable with rocks DB and integrity. Some additional questions about whether it's meaningful to blocklist queries, if the issue is coming from an event stream. And discussion about performance vs integrity tradeoffs around rocksDB and other storage engines. Discussion about whether there are visible metrics about what is causing disk IO. * Maybe, but it probably requires a lot of knowledge * There's the `events` table, but that's very coarse * translating events to actual diskio requires specialized knowledge * connecting scheduled queries to to events, also requires local knowlege * Let alone additional disk load from things like hashing your filesystem * and distributed queries ## Deprecate the foreign tables concept https://github.com/osquery/osquery/issues/7611 Native are tables that have an implementation on the platform you're on. Foriegn tables stubs for the tables that are only there are other platforms. Problems: * Currently, this is broken. (Probably when we moved off `buck`). * It requires a lot of additional linking * Probably doesn't work with extended schemas Might be for some internal Facebook use case? That's sort of the implication from the commit https://github.com/osquery/osquery/commit/e79d0ae5ce5ec13962fb9bef4063e7328e08f953 Given that it's already broken, there's some support for just removing it. Some discussion about what might be interesting to replace it. Maybe a use case is to make it simpler to write queries to handle tables that might not be present. Say if an extension was missing. This use case isn't really clear yet, nor is an approach. ## New macOS features at WWDC this week for osquery * New event types for EndpointSecurity: authentication, login sessions, screensharing connections, and XProtect detections * Noted that the XProtect table in osquery has been "broken" since macOS stopped storing detection events to the filesystem [#6588](https://github.com/osquery/osquery/issues/6588) and collecting XProtect in an evented table would re-enable this osquery use-case Discussion about notarization and codesignging, and what the non-macOS tools are for this: * https://github.com/sassoftware/relic/tree/master/lib/fruit * https://github.com/indygreg/PyOxidizer/tree/main/apple-codesign (good blog posts) * https://github.com/akeru-inc/xcnotary * Apple's java transporter ## Code Reviews * [macOS EndpointSecurity based FIM](https://github.com/osquery/osquery/pull/7594) * [macOS `password_policy`](https://github.com/osquery/osquery/pull/7579) * [macOS Unified Access Logging (UAL)](https://github.com/osquery/osquery/pull/7598) * [macOS kernel_panics table](https://github.com/osquery/osquery/pull/7585) (Not a big PR to review, test files are provided) ## Security * We are not affected by a reported OpenSSL bug https://github.com/osquery/osquery/issues/7616 * Two sqlite reports -- https://github.com/osquery/osquery/issues/7617 * There's a memory access violation in sqlite bad databases. Might be vulnerable in ATC * Probably not vulnerable to the other * libarchive, uncompressed function. Probably not affected https://github.com/osquery/osquery/issues/7618 ## Look at old PRs _(If there's time, we've been trying to re-visit old PRs)_ [Reverse Sorted List of PRs](https://github.com/osquery/osquery/pulls?q=is%3Apr+is%3Aopen+sort%3Acreated-asc)

Import from clipboard

Advanced permission required

Your current role can only read. Ask the system administrator to acquire write and comment permission.

This team is disabled

Sorry, this team is disabled. You can't edit this note.

This note is locked

Sorry, only owner can edit this note.

Reach the limit

Sorry, you've reached the max length this note can be.
Please reduce the content or divide it to more notes, thank you!

Import from Gist

Import from Snippet

or

Export to Snippet

Are you sure?

Do you really want to delete this note?
All users will lost their connection.

Create a note from template

Create a note from template

Oops...
This template is not available.


Upgrade

All
  • All
  • Team
No template found.

Create custom template


Upgrade

Delete template

Do you really want to delete this template?

This page need refresh

You have an incompatible client version.
Refresh to update.
New version available!
See releases notes here
Refresh to enjoy new features.
Your user state has changed.
Refresh to load new user state.

Sign in

Forgot password

or

By clicking below, you agree to our terms of service.

Sign in via Facebook Sign in via Twitter Sign in via GitHub Sign in via Dropbox

New to HackMD? Sign up

Help

  • English
  • 中文
  • Français
  • Deutsch
  • 日本語
  • Español
  • Català
  • Ελληνικά
  • Português
  • italiano
  • Türkçe
  • Русский
  • Nederlands
  • hrvatski jezik
  • język polski
  • Українська
  • हिन्दी
  • svenska
  • Esperanto
  • dansk

Documents

Tutorials

Book Mode Tutorial

Slide Mode Tutorial

YAML Metadata

Contacts

Facebook

Twitter

Discord

Feedback

Send us email

Resources

Releases

Pricing

Blog

Policy

Terms

Privacy

Cheatsheet

Syntax Example Reference
# Header Header 基本排版
- Unordered List
  • Unordered List
1. Ordered List
  1. Ordered List
- [ ] Todo List
  • Todo List
> Blockquote
Blockquote
**Bold font** Bold font
*Italics font* Italics font
~~Strikethrough~~ Strikethrough
19^th^ 19th
H~2~O H2O
++Inserted text++ Inserted text
==Marked text== Marked text
[link text](https:// "title") Link
![image alt](https:// "title") Image
`Code` Code 在筆記中貼入程式碼
```javascript
var i = 0;
```
var i = 0;
:smile: :smile: Emoji list
{%youtube youtube_id %} Externals
$L^aT_eX$ LaTeX
:::info
This is a alert area.
:::

This is a alert area.

Versions

Versions and GitHub Sync

Sign in to link this note to GitHub Learn more
This note is not linked with GitHub Learn more
 
Add badge Pull Push GitHub Link Settings
Upgrade now

Version named by    

More Less
  • Edit
  • Delete

Note content is identical to the latest version.
Compare with
    Choose a version
    No search result
    Version not found

Feedback

Submission failed, please try again

Thanks for your support.

On a scale of 0-10, how likely is it that you would recommend HackMD to your friends, family or business associates?

Please give us some advice and help us improve HackMD.

 

Thanks for your feedback

Remove version name

Do you want to remove this version name and description?

Transfer ownership

Transfer to
    Warning: is a public team. If you transfer note to this team, everyone on the web can find and read this note.

      Link with GitHub

      Please authorize HackMD on GitHub

      Please sign in to GitHub and install the HackMD app on your GitHub repo. Learn more

       Sign in to GitHub

      HackMD links with GitHub through a GitHub App. You can choose which repo to install our App.

      Push the note to GitHub Push to GitHub Pull a file from GitHub

        Authorize again
       

      Choose which file to push to

      Select repo
      Refresh Authorize more repos
      Select branch
      Select file
      Select branch
      Choose version(s) to push
      • Save a new version and push
      • Choose from existing versions
      Available push count

      Upgrade

      Pull from GitHub

       
      File from GitHub
      File from HackMD

      GitHub Link Settings

      File linked

      Linked by
      File path
      Last synced branch
      Available push count

      Upgrade

      Danger Zone

      Unlink
      You will no longer receive notification when GitHub file changes after unlink.

      Syncing

      Push failed

      Push successfully