Hello, I am having trouble with a query. Attached is sample data file that I am referencing.
1. I would like to query the number of records based on a Plugin ID
2. I need the output from above to truncate field using following syntax - substring([Plugin Output], 64, 150) AS Output_Truncate
3. I would like to resolve the hostname (masked in sample file); with information in the Plugin Output column
The desired query output includes:
Resolved Hostname | Host | Output_Truncate