Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 5652 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 Reporting : Latest Blocked Websites

PAGAN

I was trying to figure out how to use the Reports in Sophos to give me a list of :

Latest Blocked Websites

.

For the last week (past 7 days)

.

Grouped by User

.

Each event Listed

.

I can get a Summary such as :  USER has  3 Events

But what I'd like to see is the actual events listed

Anyone got a quick walkthrough for me to make this ?

:12251


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

    I got the SQL code I wanted :

    ..........................................

    SELECT     TOP (100) PERCENT dbo.ComputersAndDeletedComputers.Name, dbo.Events.ReportingName, dbo.Events_WebFilteringData.BlockedSite,
                          dbo.Events_WebFilteringData.ReferringURL, dbo.Events.EventTime
    FROM         dbo.ComputersAndDeletedComputers INNER JOIN
                          dbo.Events ON dbo.ComputersAndDeletedComputers.ID = dbo.Events.ComputerID INNER JOIN
                          dbo.Events_WebFilteringData ON dbo.Events.ID = dbo.Events_WebFilteringData.EventID
    ORDER BY dbo.ComputersAndDeletedComputers.Name, dbo.Events.EventTime DESC

    ..........................................

    Anyway to get it into the REPORTS table ?

    It is currently saved as a SQL-VIEW

    I'd like it to be available in the table REPORTS, and then allow it to be scheduled from the Mangement Console

    How do I go about getting this SQL code to be a Report in the Management Console ?

    .

    :12271
Reply
  • 0

    I got the SQL code I wanted :

    ..........................................

    SELECT     TOP (100) PERCENT dbo.ComputersAndDeletedComputers.Name, dbo.Events.ReportingName, dbo.Events_WebFilteringData.BlockedSite,
                          dbo.Events_WebFilteringData.ReferringURL, dbo.Events.EventTime
    FROM         dbo.ComputersAndDeletedComputers INNER JOIN
                          dbo.Events ON dbo.ComputersAndDeletedComputers.ID = dbo.Events.ComputerID INNER JOIN
                          dbo.Events_WebFilteringData ON dbo.Events.ID = dbo.Events_WebFilteringData.EventID
    ORDER BY dbo.ComputersAndDeletedComputers.Name, dbo.Events.EventTime DESC

    ..........................................

    Anyway to get it into the REPORTS table ?

    It is currently saved as a SQL-VIEW

    I'd like it to be available in the table REPORTS, and then allow it to be scheduled from the Mangement Console

    How do I go about getting this SQL code to be a Report in the Management Console ?

    .

    :12271
Children
No Data
Unfiltered HTML