I am newly using XG Home Firewall (SFOS 17.5.10 MR-10), but I have found the reporting to be inadequate. I have taken a backup copy of the corporate database from the advanced command shell and transferred it to my computer using Putty SCP. I restored a copy of the Postgres database into a new corporate database on my computer. I am using pgAdmin4 to view the tables and functions in pg_proc. I located the "Web Detail Report" of interest using this SQL query "select * from public.tblreport where title = 'Web Detail Report';". The query column in the public.tblreport table shows this query "select substring(CAST(date_trunc(''second'',to_timestamp("5mintime")) AS varchar),0,20) as time, username, "domain", url, category, usergroup,hostipv6 as host,content,categorytype,application,ruleid,activityname from {4} [[ and eduusergroup in ({7}) ]] order by {5} {6} limit {3} OFFSET {2}" for the "Web Detail Report" row. It also shows a value of "available_web_access_log_details" for the tablename column for this same row. However, cannot locate the "available_web_access_log_details" table anywhere in the corporate database. I am also seeing "Select web_usage_proc_012();" in the reportdb.log, but I am unable to locate the the web_usage_proc_012() function or procedure in any of the tables, including the pg_proc system catalog. Where can I locate the available_web_access_log_details table and the web_usage_proc_012() function or procedure to be able to create my own custom report offline from my computer? Thanks in advance.
This thread was automatically locked due to age.
