Jump to content

Spread of virus


pavolk
 Share

Recommended Posts

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

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...