https://github.com/osquery/osquery logo
Title
d

defensivedepth

11/11/2019, 9:25 PM
I have a column that returns a very large hex value (from
registry
). I need to do some quick comparisons to look for some known values - I would typically generate a hash of the value for easier comparisons and long-term storage, but am not finding any sqlite hashing function. Any ideas?
t

theopolis

11/11/2019, 9:54 PM
I think we added one, give me a second to look through the code.
Does sha256(column_name) work?
d

defensivedepth

11/11/2019, 9:56 PM
@theopolis NICE yes it does, thanks!