Spread of virus

[pavolk 0]

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