Can I use osquery (v4.6.0) to determine the keyboard type installed? If so, what would that query look like?

Are you talking external keyboard or the built-in keyboard of the laptop? And by “type” do you mean layout? Or type of internal switching mechanism?

@terracatta The built-in keyboard. Yes, I want to identify the different layouts we're supporting (e.g. en, jp, uk, sk).

I looked this up in ioreg forever ago... let me find the code

There's a luncher table wrapped over ioreg, but I'm not sure there's anything quite the same in osquery directly.

one of the practical concerns was sending a computer localized in the wrong OS and expecting people to log in when the keyboard input method didn't match. With current DEP and locally-sourced hdwe this should be LESS of a concern, since setup assistant should help vs. the old days when we were imaging

@allister ty. 🤔 I was hoping there was a way to pull the usb/bluetooth device info. In my world, we're supporting employees in Japan and EMEA with the variety of keyboard options. Sometimes when ordering a new laptop, we'll pull the info from Jamf which doesn't give the ability to show keyboard layout. Where Jamf could not provide the info, I'd create a EA using output from osquery.

definitely been there https://github.com/arubdesu/eas

ty 🙂

USB/bluetooth stuff can definitely be tricky, as a shortterm using the launcher @seph mentioned means you can look at HID's from system_profiler output

Launcher is kolides open source agent. It's runs osquery, adds custom tables, and manages updates. You can use it, or extract the tables.

@allister @seph I think I may have found something that could give me what I need with osquery:

select key,value from plist where path = '/Library/Preferences/com.apple.HIToolbox.plist' and value like '%keylayout%';