Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17
  1. #11
    jjj
    jjj is offline
    Untanglit
    Join Date
    Mar 2009
    Posts
    25

    Default

    The following was found on the forum somewhere:
    ----

    Here are the SQL statements I used to explore http traffic from a particular client:


    SET search_path = reports, events;

    SELECT W.time_stamp, R.host, L.uri
    FROM n_http_req_line L
    INNER JOIN n_http_evt_req R
    ON L.request_id = R.request_id
    INNER JOIN webpages W
    ON L.request_id = W.request_id
    WHERE W.c_client_addr = '***** IP ADDRESS ****'
    ORDER BY W.time_stamp DESC;

    Simply replace the ***** IP ADDRESS **** with the local ip address (eg. 192.168.1.x) that is of interest to you.

  2. #12
    Master Untangler
    Join Date
    May 2009
    Location
    Belfast, Northern Irelaand
    Posts
    221

    Default

    Quote Originally Posted by jjj View Post
    The following was found on the forum somewhere:
    ----

    Here are the SQL statements I used to explore http traffic from a particular client:


    SET search_path = reports, events;

    SELECT W.time_stamp, R.host, L.uri
    FROM n_http_req_line L
    INNER JOIN n_http_evt_req R
    ON L.request_id = R.request_id
    INNER JOIN webpages W
    ON L.request_id = W.request_id
    WHERE W.c_client_addr = '***** IP ADDRESS ****'
    ORDER BY W.time_stamp DESC;

    Simply replace the ***** IP ADDRESS **** with the local ip address (eg. 192.168.1.x) that is of interest to you.

    You my friend are a genius, I've been after something like this for ages.
    Will test this on Monday when I'm back to work.

  3. #13
    jjj
    jjj is offline
    Untanglit
    Join Date
    Mar 2009
    Posts
    25

    Default

    So I figured I would start here....

    Updated to 7.0 and now back-end SQL access is broken.... Anyone know what happened?

  4. #14
    Untangle Junkie dmorris's Avatar
    Join Date
    Nov 2006
    Location
    San Carlos, CA
    Posts
    17,486

    Default

    Quote Originally Posted by jjj View Post
    So I figured I would start here....

    Updated to 7.0 and now back-end SQL access is broken.... Anyone know what happened?
    the schema changed.

    you can now download this information in a CSV file through the reports UI anyway...
    Attention: Support and help on the Untangle Forums is provided by volunteers and community members like yourself.
    If you need Untangle support please call or email support@untangle.com

  5. #15
    Untangle Ninja Mathiau's Avatar
    Join Date
    Feb 2008
    Location
    Costa Frickn' Rica
    Posts
    1,630

    Default

    the csv just shows the same info on the GUI though, it doesnt add anything else? I love the new reporting and that it is reliable, but it seems to be providing alot of numbers that mean very little to me or dont tell me what i want to know.

  6. #16
    Master Untangler
    Join Date
    May 2009
    Location
    Belfast, Northern Irelaand
    Posts
    221

    Default

    Quote Originally Posted by Mathiau View Post
    the csv just shows the same info on the GUI though, it doesnt add anything else? I love the new reporting and that it is reliable, but it seems to be providing alot of numbers that mean very little to me or dont tell me what i want to know.

    What is missing?
    CSV shows everything including time stamps etc.

  7. #17
    Untangle Ninja Mathiau's Avatar
    Join Date
    Feb 2008
    Location
    Costa Frickn' Rica
    Posts
    1,630

    Default

    i am going into Reports / View Reports / Hosts - choose a host

    then i go to web filter, cause i want to see all the sites the people have viewed or the URL for sites they tried to get to as my main fight is stopping websites that allow people to sign into IM's like meebo.com or imo.im.

    now say under top 10 sites of violated sites it has categories for some like Proxies



    Proxy Sites

    357 hits

    all it says, i check the CVS file, says the same thing in it, nothing extra, has slice and value.

    i want to see, like you could in 6.2 an actual list of the sites they went to.

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO 3.6.0 PL2