Hi,
I have the following tables:
asset table: asset_id solution_id vulnerability_id
solution table: solution_id solution summary
vulnerability table: vulnerability_id title severity
How do I write a splunk query to show a table that has the asset_id, solution summary, title, and severity?
This would be the SQL query that I use:
SELECT a.asset_id, b.solution_id, b.summary as solution_summary, c.vulnerability_id, c.title as vulnerability_title, c.severity
FROM asset a
JOIN solution b USING (solution_id)
JOIN vulnerability c USING(vulnerability_id)
... View more