error in line 1458 of JSON file dashboards/clientdash.json

[tiiilerteee]

Thank you for these great dashboards for TRMM!

Just FYI: there is an error in line 1458 of JSON file dashboards/clientdash.json

There are special characters that are not properly escaped and need double backslashes

suggested to replace line 1458:

"rawSql": "SELECT \n count() as "count",\n (CASE \n WHEN wmi_detail->'cpu' IS NOT NULL\n THEN SUBSTRING(agents_agent.wmi_detail->'cpu'->0->0->>'Name','(?:AMD|\d\dth Gen Intel(R)||Intel(R)|Intel)(.)(?:@|Processor||with)')\n ELSE SUBSTRING(agents_agent.wmi_detail->'cpus'->>0,'(?:AMD|\d\dth Gen Intel(R)||Intel(R)|Intel)(.*)(?:@|Processor||with)')\n END) as "CPU Name"\nFROM agents_agent\n INNER JOIN clients_site ON agents_agent.site_id = clients_site.id\n INNER JOIN clients_client ON clients_site.client_id = clients_client.id\nWHERE\n clients_client.name IN ($Client)\n AND clients_site.name IN ($Sites)\nGroup by "CPU Name"\nOrder by "count" desc",

with:

"rawSql": "SELECT \n count() as "count",\n (CASE \n WHEN wmi_detail->'cpu' IS NOT NULL\n THEN SUBSTRING(agents_agent.wmi_detail->'cpu'->0->0->>'Name','(?:AMD|\d\dth Gen Intel\(R\)||Intel\(R\)|Intel)(.)(?:@|Processor||with)')\n ELSE SUBSTRING(agents_agent.wmi_detail->'cpus'->>0,'(?:AMD|\d\dth Gen Intel\(R\)||Intel\(R\)|Intel)(.*)(?:@|Processor||with)')\n END) as "CPU Name"\nFROM agents_agent\n INNER JOIN clients_site ON agents_agent.site_id = clients_site.id\n INNER JOIN clients_client ON clients_site.client_id = clients_client.id\nWHERE\n clients_client.name IN ($Client)\n AND clients_site.name IN ($Sites)\nGroup by "CPU Name"\nOrder by "count" desc",

[dinger1986]

Please PR and I will accept it