Generate/export script to view endpoint antivrus version

Question

Hello, Does anyone know how to generate report or script to export and view endpoint antivirus version?. Thanks :25145

jak · Accepted Answer

As Christian, says, choose the right view, column and sort order in SEC and Ctrl-C, Ctrl-V into Excel for example. 
 This only works on SEC 5 If I remember rightly.

The other option would be to use the Sophos Reporting Interface (SRI) to connect to the database and get the data that way. /search?q= 8285 should start you off. You can connect directly to the SQL database using Excel for example.

Even if you don't want to bother with installing the SRI, you could still connect to the Sophos database using something like Excel. Using the view, ComputerListData2 has most of the information you are likely to need. The only downside to this is, it's unsupported and maybe dissapear on the next version, whereas the reporting interface will, should, always offer the same views. ComputerListData2 has been around a long time though, so I doubt it is going anywere anytime soon.

To do so: 
 
 Open Excel 
 Choose "Data" tab 
 Choose "From other sources" 
 Choose "From SQL Server" 
 Enter the server name, e.g. secservername\sophos (where sophos is the name of the SQL instance) 
 Choose "Use Windows Authentication" 
 Choose the Sophos database, i.e. for SEC 4.7 - SOPHOS47, SEC 5 -SOPHOS50 
 Choose ComputerListData2 (this is a view) 
 Click Finish - OK - You can add the data to the worksheet 
 
 You can use this same approach, in combination with the reporting interface views also, which would be more supported than using ComputerListData2.

Also, If you're interested in threats: you could use the view: ThreatInstancesAll.

Regards, 
 Jak

:25159