OXIESEC PANEL

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: CollectReportData.sh

#!/bin/sh

GID="";
DB="";

if [ "$1X" == "X" ];then
	echo "Pass database name as 1st Argument";
	echo " sh CollectReportData.sh sampledb 12345";
	exit 0;
else
	DB=$1;
fi
if [ "$2X" == "X" ];then
	echo "Pass Report id as 2nd Argument";
	echo " sh CollectReportData.sh sampledb 12345";
	exit 0;
else
	GID=$2;
fi

echo "DB=$DB GID=$GID"

mysql $DB <<!

select * from folder_tree where ft_id=$GID into outfile '/tmp/${GID}_foldertree.xt' fields terminated by '|';
select * from folder_properties where fp_id=$GID into outfile '/tmp/${GID}_folderproperties.xt' fields terminated by '|';
select * from folder_access where fa_id=$GID into outfile '/tmp/${GID}_folderaccess.xt' fields terminated by '|';
select * from graph_def where gf_id=$GID into outfile '/tmp/${GID}_graphdef.xt' fields terminated by '|';
select * from graph_series where gs_id=$GID into outfile '/tmp/${GID}_graphseries.xt' fields terminated by '|';
select * from graph_props where gp_id=$GID into outfile '/tmp/${GID}_graphprops.xt' fields terminated by '|';
select * from graph_access where ga_gf_id=$GID into outfile '/tmp/${GID}_graphaccess.xt' fields terminated by '|';
select * from data_series where ds_series_id in(select gs_series_id from graph_series where gs_id=$GID) into outfile '/tmp/${GID}_dataseries.xt' fields terminated by '|';
select * from data_seriesids where di_seriesid in(select gs_series_id from graph_series where gs_id=$GID) into outfile '/tmp/${GID}_dataseriesids.xt' fields terminated by '|';
select * from data_seriesvals where dv_seriesid in(select gs_series_id from graph_series where gs_id=$GID) into outfile '/tmp/${GID}_dataseriesvals.xt' fields terminated by '|';
select * from ds_stat where dt_series_id in(select gs_series_id from graph_series where gs_id=$GID) into outfile '/tmp/${GID}_dsstat.xt' fields terminated by '|';
select * from data_xy where xy_series_id in(select gs_series_id from graph_series where gs_id=$GID) limit 20 into outfile '/tmp/${GID}_dataxy.xt' fields terminated by '|';
!

rm -rf /tmp/${GID}_ReportData.tgz
tar -czf /tmp/${GID}_ReportData.tgz /tmp/${GID}_*.xt 2>1&>/dev/null
echo "Please e-mail/x-fer "/tmp/${GID}_ReportData.tgz" file to support team for further debugging"
rm -rf /tmp/${GID}_*.xt