Cipafilter Support:
Support@Cipafilter.com
309 517 2022 option 2
Mon - Fri 7 AM - 6 PM CT
Knowledgebase:
How To - Configured a Custom Report Displaying Top 10 Users with Porn Trips (DRAFT)
Posted by Clayton Spencer, Last modified by Clayton Spencer on 10 January 2019 11:43 AM

This article is relevant to users on versions 9.0 and above.

Issue


This article will detail how to create an automatic report that is run daily that lists the top 10 users that tripped the pornography filter.


Solution

  1. On the Notifications page, select Add Report at the bottom of the page. An Add Custom Report window should be displayed.

    Add custom report window


  2. Enter the name of the report: Top 10 Users with Porn Trips for the Day.

  3. Enter the description of the report: Daily Report of Top 10 Users with Porn Trips.

  4. Enter the following text for the report:

    SELECT
        username AS "Username", COUNT(timestamp) AS "Porn Violations"
    FROM
        log_raw_special
    LEFT JOIN users USING (userid)
    WHERE
        timestamp > NOW() - INTERVAL '24 hours'
        AND commentid IN 
        (SELECT commentid FROM comments WHERE comment ILIKE 'pornography')
    GROUP BY
        username
    ORDER BY
        "Porn Violations" DESC
    LIMIT 10
    ;


    Top 10 users with porn trips for the day report window

  5. Click the Add Report button in the edit window to save the report.

  6. To dispatch this report, select the appropriate e-mail address in the E-mail Addresses section of the page and select the Daily option for this report in the Report Notifications section of the page.

    E-mail address section

Report notifications section


Daily reports are dispatched Monday through Friday at 6 PM. Weekly reports are dispatched Monday at 12:01 AM.


Note: 
This report is specified as a daily report. If you would like to utilize this report as a weekly report make the following changes:

  1. In the text of the report, change INTERVAL '1 day' to INTERVAL '1 week', and

  2. Select the Weekly option for this report in the Report Notifications section of the page.
(0 vote(s))
Helpful
Not helpful

Comments (0)
©Cipafilter 2017. All Rights Reserved.