Hello,
When I visualized spread of viruses under ERA v5 I had sql queries, which generate inputs for Gephi (gephi org).
First input are NODES:
SELECT *
FROM (
SELECT Virus AS Label, Virus AS Id, COUNT(*) AS Weight, "Virus" AS Target
FROM threatlog
WHERE NOT Virus=''
GROUP BY Virus
UNION
SELECT ComputerName AS Label, ComputerName AS Id, COUNT(*) AS Weight, "PC" AS Target
FROM threatlog
LEFT JOIN client
ON (threatlog.ClientID=client.ID)
GROUP BY ComputerName
) AS Table
Second input is EDGE:
SELECT Virus AS Source, ComputerName AS Target, COUNT(*) AS Weight
FROM threatlog
LEFT JOIN client
ON (threatlog.ClientID=client.ID)
WHERE NOT Virus=''
GROUP BY Virus, ComputerName
In Web Console ERA v6.4 I have a problem create reports for input to Gephi. Could you please help me with this problem?
Thanks