OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
bin
/
utils
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
02/03/2023 08:06:37 AM
rwxr-xr-x
📄
.auditreport.sh.swp
12 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
CollectReportData.sh
2.17 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
ComapreCubotTableData.sh
1.06 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
VBox.sh
1.59 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
auditreport.sh
1.35 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cleanSRCid.sql
386 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
cleancache.sh
8.89 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
compare_database.sh
148 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
compressCSS.sh
262 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
compressJS.sh
251 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubbackup.sh
1.43 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubbackup_sync.sh
314 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubmonitor.sh
3.77 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
cubotmail
29.64 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
esalesforce.pl
1.87 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
etl_xform_template.sh
543 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
killrunaway.sh
609 bytes
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
migrateSharedreports.sh
1.14 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
mysql2pgsql.perl
40.98 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
removenewlinechar.awk
292 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
removenewlinechar.pl
534 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
removenewlinechar2.awk
82 bytes
02/03/2023 07:34:08 AM
rw-r--r--
📄
renameCubUser.sh
2.38 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
sendmail.pl
2.13 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
updatealldb.sh
1.08 KB
02/03/2023 07:34:08 AM
rw-r--r--
📄
yuicompressor-2.4.6.jar
832.85 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
📄
zap
1.86 KB
02/03/2023 07:34:08 AM
rwxr-xr-x
Editing: auditreport.sh
Close
echo 'Started : ' `date` ; mysql demo_mutual<<! insert ignore into mst_audit_user select distinct lu_id from login_users; #--insert into trn_user_audit select lc_uid, date(lc_logintime), lc_logintime, lc_logouttime, time_to_sec(timediff(lc_logouttime, lc_logintime)), count(*) from login_connects where date(lc_logintime)=date_sub(current_date,interval 1 day) group by 1, date(lc_logintime); insert into trn_user_audit select lc_uid, date(lc_logintime), lc_logintime, lc_logouttime, time_to_sec(timediff(lc_logouttime, lc_logintime)), count(*) from login_connects group by 1, date(lc_logintime); truncate table tmp_reptime ; insert into tmp_reptime select gs_id id, sum(dt_query_time)/1000 time from graph_series, ds_stat where dt_series_id=gs_series_id and gs_id>100000 and dt_status='V' group by 1; update trn_rep, tmp_reptime set fp_gentime=time where id=ft_id; update trn_rep set cnt=0 where fp_createdt = fp_laccessdt; update trn_rep set cnt=1 where fp_createdt < fp_laccessdt; update trn_rep_hist a, trn_rep b set a.cnt=a.cnt+b.cnt, a.fp_laccessdt=b.fp_laccessdt where a.ft_name=b.ft_name and a.ft_id=b.ft_id and a.fp_laccessdt < b.fp_laccessdt; insert into trn_rep_hist select * from trn_rep b where b.ft_id not in (select a.ft_id from trn_rep_hist a); update trn_rep_hist set cnt=1 where fp_createdt = fp_laccessdt; ! echo 'Done : ' `date` ;