1 files changed, 18 insertions, 0 deletions
diff --git a/src/data/sql/hi-view.sql b/src/data/sql/hi-view.sql
new file mode 100644
index 0000000..39886db
--- /dev/null
+++ b/src/data/sql/hi-view.sql
@@ -0,0 +1,18 @@
+SELECT
+	HEX(instance_id),
+	inserted,
+	updated,
+	parent_uptime,
+	child_uptime,
+	bne_cnt,
+	infect_cnt,
+	parent_pid,
+	child_pid,
+	HEX(prog_ver),
+	HEX(boot_id),
+	cred_id,
+	cred_pw,
+	crash_cnt,
+	arch,
+	INET6_NTOA(ipaddr)
+FROM prne.`prne-hi`;