Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 3 subscribers
  • Views 9265 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

Exporting Remote Access sessions as CSV through command line

giannis giannakou

Hello!

As the title suggests, i want to export Remote Access sessions as CSV through command line in order to run a script afterwards and store them in a Database.

Is this possible, or even to download the logs and then transform them to CSV?

 

Thanks in advance.

 



This thread was automatically locked due to age.
  • 0

    Hi, Giannis, and welcome to the UTM Community!

    What you want is already available in 'Logging & Reporting':

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
  • 0 in reply to BAlfson

    Hello Bob,

    Thanks for welcoming me and for the reply!

    I know that this exists, but what i want to know if there is a way for this file to be downloaded through shell.

    Basically i want to run a script that downloads that CSV file automatically. Can this be done?

     

    Thanks in advance,

    Giannis

     

    Edit:

    Or if i can store that CSV directly into an SQL Server

  • 0 in reply to giannis giannakou

    That information is not in a text file, Giannis, it's in a PostgreSQL database.  Someone with skills in that area should be able to do what you want.  All Reporting info is in the reporting DB.

    Cheers - Bob

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Unfiltered HTML