Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 19 subscribers
  • Views 15532 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

Sophos Enterprise Console reporting feature request

JoeLansing

Lets say I have 30 PC's that are showing Unmanaged.  And 51 Out of Date.  I want to be able to export a list of them ( A Report? ) that I can give to those who will then go fix the issues.    All the reports seem to just contain X Number of Computers and nothing specific as far as PC names.   They are pretty looking reports, but fairly useless.  I'd rather have a practical report that will assist me in fixing the issues shown on the report.

:51244


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

    Hello RubinCompServ,

    the following query against the database (use the applicable instance and database names) would give you (just) the names of the Computers with alerts (no further breakdown virus, sus, or PUA):

    sqlcmd -E -S .\Sophos -d SOPHOS5xx -Q "Select Name From AliveComputers where LastThreatInstanceID is not NULL"

     A similar query could be used to list the computers with errors.

    Policy compliance is, as far as I can see, not so simple and up-to-dateness is a challenge. The Dashboard considers only connected computers.

    Christian

    :55015
Reply
  • 0

    Hello RubinCompServ,

    the following query against the database (use the applicable instance and database names) would give you (just) the names of the Computers with alerts (no further breakdown virus, sus, or PUA):

    sqlcmd -E -S .\Sophos -d SOPHOS5xx -Q "Select Name From AliveComputers where LastThreatInstanceID is not NULL"

     A similar query could be used to list the computers with errors.

    Policy compliance is, as far as I can see, not so simple and up-to-dateness is a challenge. The Dashboard considers only connected computers.

    Christian

    :55015
Children
No Data
Unfiltered HTML