Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 5972 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Generate/export script to view endpoint antivrus version

Azwan

Hello,

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

:25145


This thread was automatically locked due to age.
Parents
  • 0

    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:

    1. Open Excel
    2. Choose "Data" tab
    3. Choose "From other sources"
    4. Choose "From SQL Server"
    5. Enter the server name, e.g. secservername\sophos  (where sophos is the name of the SQL instance)
    6. Choose "Use Windows Authentication"
    7. Choose the Sophos database, i.e. for SEC 4.7 - SOPHOS47, SEC 5 -SOPHOS50
    8. Choose ComputerListData2 (this is a view)
    9. 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
Reply
  • 0

    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:

    1. Open Excel
    2. Choose "Data" tab
    3. Choose "From other sources"
    4. Choose "From SQL Server"
    5. Enter the server name, e.g. secservername\sophos  (where sophos is the name of the SQL instance)
    6. Choose "Use Windows Authentication"
    7. Choose the Sophos database, i.e. for SEC 4.7 - SOPHOS47, SEC 5 -SOPHOS50
    8. Choose ComputerListData2 (this is a view)
    9. 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
Children
No Data