The osQuery Tool is a cross-platform tool to query your devices like a database for Windows, Linux and iOS.
Osquery uses basic SQL commands to leverage a relational data-model to describe a device.
You can dowload it here
osQuery installation on Windows is running the MSI to get it running.
After the installation you will see the binaries in C:\ProgramData\osquery
As you can see it has a few PowerShell scripts as well.
But most importantly is the osQuery Shell called osqueryi.exe
If you run the shell command you can see all features like this :
in the background it uses SQLite
You can list all the tables that can be queried like this
Since you now have the list of the tables you can start using it in a Query.
How to use it :
osqueryi -line "select * from video_info"
osqueryi -line "select * from cpu_info"
You can use osqueryi.exe in PowerShell like this