theopolis
~/git/osquery(branch:master*)0 » git --no-pager diff
diff --git a/specs/os_version.table b/specs/os_version.table
index 90bc7f2..a796f9d 100644
--- a/specs/os_version.table
+++ b/specs/os_version.table
@@ -8,7 +8,11 @@ schema([
Column("patch", INTEGER, "Optional patch release"),
Column("build", TEXT, "Optional build-specific or variant string"),
Column("platform", TEXT, "OS Platform or ID"),
+])
+extended_schema(LINUX, [
Column("platform_like", TEXT, "Closely related platforms"),
+])
+extended_schema(WINDOWS, [
Column("codename", TEXT, "OS version codename"),
])
implementation("system/os_version@genOSVersion")
------------------------------------------------------------
~/git/osquery(branch:master*)0 » ./build/linux/osquery/osqueryi -A os_version
+--------+----------------------------+-------+-------+-------+-------+----------+---------------+
| name | version | major | minor | patch | build | platform | platform_like |
+--------+----------------------------+-------+-------+-------+-------+----------+---------------+
| Ubuntu | 16.04.3 LTS (Xenial Xerus) | 16 | 4 | 0 | | ubuntu | debian |
+--------+----------------------------+-------+-------+-------+-------+----------+---------------+
------------------------------------------------------------
~/git/osquery(branch:master*)0 » ./build/linux/osquery/osqueryi ".schema" | grep os_version
CREATE TABLE os_version(`name` TEXT, `version` TEXT, `major` INTEGER, `minor` INTEGER, `patch` INTEGER, `build` TEXT, `platform` TEXT, `platform_like` TEXT, `codename` TEXT HIDDEN);