In databases, we often find columns that are stored in a hierarchy structure, not unlike a file path on your drive. For example, in the Microsoft Logs sample database the
Perf
table stores its counter path this way:\\computername\Memory\Available MBytes
.It would be helpful to have a way to easily break this path out into its individual parts. KQL provides us a way of doing this using the
split
function.
Check out examples of how you can perform splitting.