blackcatkempo
asked on
SQL Query assistance linking between columns
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
28589134SAMPLE-DATA3.csv
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
28589134SAMPLE-DATA3.csv
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER