Computes a cryptographic MD5-hashing of an input string of one
field or an array of fields. The hashed output is returned as a
hex string, meaning the
hexadecimal representation of the MD5 hash of data.
This function can be used to calculate checksums to compare
outside of LogScale or collect multiple fields into a
combined string of fixed length.
Click + next to an example below to get the full details.
MD5 Hash Multiple Fields
MD5 hash multiple fields using the crypto:md5() function
Query
logscale
crypto:md5(field=[a,b,c])
Introduction
In this example, the crypto:md5()
function is used to hash the fields
a,b,c and return the
result into a field named
_md5.
Step-by-Step
Starting with the source repository events.
logscale
crypto:md5(field=[a,b,c])
Performs a cryptographic MD5-hashing of
a,b,c. The
field argument can be omitted to write:
crypto:md5([a,b,c])
Event Result set.
Summary and Results
The query is used to encode a string using the MD5 hash. When
called with multiple values, crypto:md5()
function creates a single MD5 sum from the combined value of the
supplied fields. Combining fields in this way and converting to an
MD5 can be an effective method of creating a unique ID for a given
fieldset which could be used to identify a specific event type.
The MD5 is reproducible (for example, supplying the same values
will produce the same MD5 sum), and so it can sometimes be an
effective method of creating unique identifier or lookup fields
for a join() across two different datasets.
MD5 Hash a Field With a Given Value
MD5 hash a field with a given value using the crypto:md5() function
Query
logscale
a:="Hello, world!"|crypto:md5(a)
Introduction
In this example, the
crypto:md5() function is used to hash the
field a with value
Hello, world! and convert
the result into _md5.
Step-by-Step
Starting with the source repository events.
logscale
a:="Hello, world!"
Assigns the value Hello,
world! to the field a.
logscale
|crypto:md5(a)
Performs a cryptographic MD5-hashing of
a:= "Hello, world!". The
output value would be _md5 =
"6cd3556deb0da54bca060b4c39479839"
Event Result set.
Summary and Results
The query is used to encode a string using the MD5 hash. The
hash generators MD5,
SHA-1, and
SHA-256 are for example
useful for encoding passwords or representing other strings in
the system as hashed values.