Hi everyone,
I’m currently working on a project where I need to visualize CVEs data using Grafana. The data is fetched from a remote source, processed, and then indexed into Elasticsearch. However, I’m facing significant challenges with querying nested data structures in Grafana.
I am using Grafana to query and visualize the data, but it seems to have limitations when it comes to querying nested data structures effectively.
I have a field ““Software_Affected”” structured as nested data, and the number of affected products can vary :
[
{
“Vendor”: “",
“Product”: "”,
“Versions”: [
{“Version”: “", “LessThan”: "”, “Status”: “"},
{“Version”: "”, “LessThan”: “", “Status”: "”}
],
“CPEs”: [“", "”]
},
{
“Vendor”: “",
“Product”: "”,
“Versions”: [
{“Version”: “", “LessThan”: "”, “Status”: “"},
{“Version”: "”, “LessThan”: “", “Status”: "”}
],
“CPEs”: [“", "”]
}]
Are there any best practices for structuring and indexing CVE data to optimize it for Grafana visualizations?
Has anyone else faced similar issues with nested data in Grafana, and how did you resolve them?
Any help or insights would be greatly appreciated!
Thank you!