Help us enhance your Sophos Community experience. Share your thoughts in our Sophos Community survey.

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

Custom Report returns no results

Kevin Thomas

The custom reports when I try to run them always return no records found. I am running SFOS 16.05.7 MR-7. As you see in the screen shot below I have data to report on, for this example I used 9-5-17 through 9-6-17. 

 

But when I run a custom report I get this. I am clicking the generate button.

 

I have checked an on box reporting is enabled.

 

What am I missing?



This thread was automatically locked due to age.
  • 0 in reply to rfcat_vk

    Hi Ian,

    I scheduled a User App Risks & Usage report to report on Source Zones, Destination Zones, and Hosts. All 3 reports contained data.

     

    This is the Hosts reports.

  • 0 in reply to Kevin Thomas

    1. Could you check the report disk space, particularly the /var partition on the console of XG:

     console> system diagnostics show disk

     

    2. Please check the following services are running (advanced shell):

    service –S

    postgres RUNNING

    reportdb RUNNING

    garner RUNNING  

     

    3. Ensure logging is enabled on your firewall rules for outbound traffic

    4. Lastly, verify that the FW rule does not have any Filters set to NONE. Reason is that when any filter is configured as NONE the proxy is bypassed. If the proxy’s bypassed then there will be no categorization and as a result no logging.

    Karlos
    Community Support Engineer | Sophos Technical Support
    Knowledge Base  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'This helped me' link.
  • 0 in reply to Karlos

    Hi Karlos,

    1. The disk usage report.

    2. The command service is unknown.

    3. The is currently only one rule (the default networking rule the system creates on install. It is configured to log traffic.

    4. The firewall rule shows no options for filtering.

  • 0 in reply to Kevin Thomas

    Hi Kevin,

    For the second command I sent you, this must be entered in the Advanced Shell (option 5 then option 3)

    Also, for my fourth request, all the filters can be located in the Advanced settings section. Specifically, in the section that says Web Policy. If it is "none", instead choose "Allow All" 

    Thanks!

    - Karlos

    Karlos
    Community Support Engineer | Sophos Technical Support
    Knowledge Base  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'This helped me' link.
  • 0 in reply to Karlos

    Hi Karlos,

    Sorry, I missed the advanced shell part. The postgres, reportdb, and garner services are running.

    The web policy setting was set to none and I have changed it to Allow ALL. So far I'm still getting no result returned on my reports.

     

    Update-

    The custom reports are now working. It looks like setting the Web Policy to Allow All has corrected the issue. 

     

    I would recommend a few things;

    1. A detailed reports guide. I know off of your support site it says Coming Soon, to really be helpful it should cover topics like this that will prevent reports from working. 

    2. It may be better to change the default web policy from none to Allow All as it stops custom reports from running.

  • 0 in reply to Kevin Thomas

    Hi  

    Thanks for the update. Glad to hear the issue is resolved. You've brought up great recommendations which you can submit as a request here.

    Best,

    Karlos

    Karlos
    Community Support Engineer | Sophos Technical Support
    Knowledge Base  |  @SophosSupport  | Sign up for SMS Alerts
    If a post solves your question use the 'This helped me' link.
Unfiltered HTML