DIR : /home/kozerus/public_html/ko_center/grep_smbsql.sql

/home/kozerus/public_html/ko_center

cabamps.sql:-- cabamps.sql
cabamps.sql:
cabamps.sql:-- 20121130_1430 jk
cabamps.sql:
cabamps.sql:	select planid, cab, cab1, cab2 , sum( amps ) samps
cabamps.sql:	from  koplans
cabamps.sql:	group by planid, cab, cab1, cab2
cabamps.sql:	order by planid, samps desc
cabamps.sql:
cabamps.sql:
cabamps.sql:	;
cabamps.sql:
cabamps.sql:
cabamps.sql:-- 	select * from koplans where loadmode == '';
cabamps.sql:
cabitems.sql:-- cabitems.sql
cabitems.sql:
cabitems.sql:-- 20121130_1430 jk
cabitems.sql:
cabitems.sql:
cabitems.sql:        select planid, cab, cab1, cab2 , item, amps, sn, hrctag, machinename, os   
cabitems.sql:        from  koplans
cabitems.sql:        group by planid, cab, cab1, cab2, item
cabitems.sql:        order by planid, cab, cab1, cab2, amps desc 
cabitems.sql:
cabitems.sql:
cabitems.sql:        ;
cabitems.sql:
cabitems.sql:
cabitems.sql:--      select * from koplans where loadmode == '';
cabitems.sql:
cabitems.sql:--	;
cabitems.sql:
cabitems.sql:
cr_kocab.sql:-- cr_kocab.sql
cr_kocab.sql:
cr_kocab.sql:-- 20121130_1430 jk
cr_kocab.sql:
cr_kocab.sql:	select * rpts
cr_kocab.sql:
cr_kocab.sql:	;
cr_kocab.sql:
cr_kocab.sql:
cr_kohw.sql:-- cr_kohw.sql
cr_kohw.sql:
cr_kohw.sql:-- 20121130_1430 jk
cr_kohw.sql:
cr_kohw.sql:	select * 
cr_kohw.sql:	from rpts
cr_kohw.sql:
cr_kohw.sql:	;
cr_kohw.sql:
cr_kohw.sql:
cr_koplans.sql:-- cr_koplans.sql
cr_koplans.sql:
cr_koplans.sql:-- 20121130_1430 jk
cr_koplans.sql:
cr_koplans.sql:	select * 
cr_koplans.sql:	from rpts
cr_koplans.sql:
cr_koplans.sql:	;
cr_koplans.sql:
cr_koplans.sql:
defrag_fromcabs.sql:-- defrag_fromcabs.sql
defrag_fromcabs.sql:
defrag_fromcabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs.sql:--	from kohw
defrag_fromcabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_fromcabs.sql:--	order by cab, amps desc;
defrag_fromcabs.sql:
defrag_fromcabs.sql:
defrag_fromcabs.sql:	select 'defrag_fromcabs', date('now'), planid, cab, item, amps, hostname, sn, hrctag, bluetag, ip from koplans
defrag_fromcabs.sql:	order by planid, cab;
defrag_fromcabs.sql:
defrag_fromcabs.sql:
defrag_fromcabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs.sql:--	from kohw
defrag_fromcabs.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_fromcabs.sql:--	order by cab, amps desc;
defrag_fromcabs.sql:
defrag_fromcabs.sql:
defrag_fromcabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_fromcabs_sum.sql:-- defrag_fromcabs_sum.sql
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs_sum.sql:--	from kohw
defrag_fromcabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_fromcabs_sum.sql:--	order by cab, amps desc;
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
defrag_fromcabs_sum.sql:	group by planid, cab
defrag_fromcabs_sum.sql:	order by planid, cab;
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs_sum.sql:--	from kohw
defrag_fromcabs_sum.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_fromcabs_sum.sql:--	order by cab, amps desc;
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_items.sql:-- defrag_fromcabs.sql
defrag_items.sql:
defrag_items.sql:	select cab,item,amps,hostname,sn,hrctag,bluetag,ip,os,osver
defrag_items.sql:	from kohw
defrag_items.sql:	where cab in ( select cab from koplans where planid == 'plan1' );
defrag_items.sql:	order by cab, item
defrag_items.sql:	;
defrag_plans_items_amps.sql:-- defrag_plans_items_amps
defrag_plans_items_amps.sql:
defrag_plans_items_amps.sql:	select 'defrag_plans_items_amps', date('now'), planid, item, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_amps.sql:	group by planid, cab, cab2, item
defrag_plans_items_amps.sql:	order by planid, amps desc, cab, cab2;
defrag_plans_items_cab.sql:-- defrag_plans_items_cab
defrag_plans_items_cab.sql:
defrag_plans_items_cab.sql:	select 'defrag_plans_items_cab', date('now'), planid, item, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_cab.sql:	group by planid, cab, cab2, item
defrag_plans_items_cab.sql:	order by planid, cab, cab2, amps desc;
defrag_plans_items.sql:-- defrag_plans_items
defrag_plans_items.sql:
defrag_plans_items.sql:	select 'defrag_plans_items', date('now'), planid, item, cab, cab2, sum(amps) amps from koplans
defrag_plans_items.sql:	group by planid, cab, cab2, item
defrag_plans_items.sql:	order by planid, item, cab, cab2, amps desc;
defrag_plans_items_sumamps.sql:-- defrag_plans_items_sumamps
defrag_plans_items_sumamps.sql:
defrag_plans_items_sumamps.sql:	select 'defrag_plans_items_sumamps', date('now'), planid, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_sumamps.sql:	group by planid, cab, cab2
defrag_plans_items_sumamps.sql:	order by planid, amps desc, cab, cab2;
defrag_plans_items_sum.sql:-- defrag_plans_items_sum
defrag_plans_items_sum.sql:
defrag_plans_items_sum.sql:	select 'defrag_plans_items_sum', date('now'), planid, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_sum.sql:	group by planid, cab, cab2
defrag_plans_items_sum.sql:	order by planid, cab, cab2;
defrag_plans_itrems_sumamps.sql:-- defrag_plans_itrems_sumamps.sql
defrag_plans_itrems_sumamps.sql:
defrag_plans_itrems_sumamps.sql:-- 20121130_1430 jk
defrag_plans_itrems_sumamps.sql:
defrag_plans_itrems_sumamps.sql:
defrag_plans_itrems_sumamps.sql:        select *
defrag_plans_itrems_sumamps.sql:        from ko_plans
defrag_plans_itrems_sumamps.sql:	where loadmode == ''
defrag_plans_itrems_sumamps.sql:	;
defrag_plans_itrems_sumamps.sql:
defrag_plans_itrems_sumamps.sql:
defrag_plans.sql:-- defrag_plans
defrag_plans.sql:
defrag_plans.sql:	select 'defrag_plans', date('now'), cab,cab2,item,amps,sn,hostname,hrctag,ip from koplans;
defrag_plans_sum.sql:-- defrag_plans_items_sum
defrag_plans_sum.sql:
defrag_plans_sum.sql:	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, sum(amps) samps 
defrag_plans_sum.sql:	from koplans
defrag_plans_sum.sql:	where loadmode == ''
defrag_plans_sum.sql:	group by planid, cabnum, cablim
defrag_plans_sum.sql:	order by planid, cabnum, cablim
defrag_plans_sum.sql:	;
defrag_plans_sum.sql:
defrag_plans_sum.sql:
defrag_plans_sum.sql:--	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
defrag_plans_sum.sql:--	from koplans
defrag_plans_sum.sql:--	where loadmode==''
defrag_plans_sum.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
defrag_plans_sum.sql:--	order by planid, cabnum, cablim, cab, cab1, cab2
defrag_plans_sum.sql:--	;
defrag_sel_kohw_amps.sql:-- defrag_sel_kohw_amps.sql
defrag_sel_kohw_amps.sql:
defrag_sel_kohw_amps.sql:
defrag_sel_kohw_amps.sql:
defrag_sel_kohw_amps.sql:--	select 'defrag_sel_kohw_amps', date('now'), planid, cab, cab2, item, amps from koplans where amps == '';
defrag_sel_kohw_amps.sql:	select 'defrag_sel_kohw_amps', date('now'), item, cab, amps from kohw where amps != ''
defrag_sel_kohw_amps.sql:	order by item, cab;
defrag_sel_kohw_nullamps.sql:-- defrag_sel_nullamp
defrag_sel_kohw_nullamps.sql:
defrag_sel_kohw_nullamps.sql:
defrag_sel_kohw_nullamps.sql:
defrag_sel_kohw_nullamps.sql:--	select planid, cab, cab2, item, amps from koplans where amps == '';
defrag_sel_kohw_nullamps.sql:	select 'defrag_del_nullamp', date('now'), cab, item, amps from kohw where amps == '';
defrag_sel_koplans_nullamps.sql:-- defrag_sel_koplans_nullamp
defrag_sel_koplans_nullamps.sql:
defrag_sel_koplans_nullamps.sql:
defrag_sel_koplans_nullamps.sql:	select 'defrag_sel_koplans_nullamp', date('now'), planid, cab, cab2, item, amps from koplans where amps == '';
defrag_sel_koplans_nullamps.sql:
defrag_sel_nullamps.sql:-- defrag_sel_nullamp
defrag_sel_nullamps.sql:
defrag_sel_nullamps.sql:
defrag_sel_nullamps.sql:
defrag_sel_nullamps.sql:	select 'defrag_sel_nullamp', date('now'), cab, item, amps from kohw where amps == '';
defrag_tocabs.sql:-- defrag_tocabs.sql
defrag_tocabs.sql:
defrag_tocabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs.sql:--	from kohw
defrag_tocabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_tocabs.sql:--	order by cab, amps desc;
defrag_tocabs.sql:
defrag_tocabs.sql:
defrag_tocabs.sql:	select 'defrag_tocabs', date('now'), planid, cab2, item, amps, hostname, sn, hrctag, bluetag, ip from koplans
defrag_tocabs.sql:	order by planid, cab2;
defrag_tocabs.sql:
defrag_tocabs.sql:
defrag_tocabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs.sql:--	from kohw
defrag_tocabs.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_tocabs.sql:--	order by cab, amps desc;
defrag_tocabs.sql:
defrag_tocabs.sql:
defrag_tocabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_tocabs_sum.sql:-- defrag_tocabs_sum.sql
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs_sum.sql:--	from kohw
defrag_tocabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_tocabs_sum.sql:--	order by cab, amps desc;
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:	select 'defrag_tocabs_sum', date('now'), planid, cab2, sum(amps) from koplans 
defrag_tocabs_sum.sql:	group by planid, cab2
defrag_tocabs_sum.sql:	order by planid, cab2;
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs_sum.sql:--	from kohw
defrag_tocabs_sum.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_tocabs_sum.sql:--	order by cab, amps desc;
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_upd_kohw.sql:-- defrag_upd_kohw.sql
defrag_upd_kohw.sql:
defrag_upd_kohw.sql:	update kohw set ip='ip' where ip == '';
defrag_upd_kohw.sql:	update kohw set ips='ips' where ips == '';
defrag_upd_kohw.sql:	update kohw set sn='sn' where sn == '';
defrag_upd_kohw.sql:	update kohw set hrctag='hrctag' where hrctag == '';
defrag_upd_kohw.sql:	update kohw set bluetag='bluetag' where bluetag == '';
defrag_upd_kohw.sql:	update kohw set hostname='hostname' where hostname == '';
defrag_upd_kohw.sql:	update kohw set os='os' where os == '';
defrag_upd_kohw.sql:	update kohw set osver='osver' where osver == '';
defrag_upd_kohw.sql:
defrag_upd_kohw.sql:
defrag_upd_kohw.sql:	update koplans set ip = (select ip from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set os = (select os from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set sn = (select sn from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set osver = (select osver from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set hrctag = (select hrctag from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set bluetag = (select bluetag from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set hostname = (select hostname from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
from_cabs.sql:-- from_cabs.sql
from_cabs.sql:
from_cabs.sql:-- 20121130_1430 jk
from_cabs.sql:
from_cabs.sql:	select * from rpts
from_cabs.sql:
from_cabs.sql:	;
from_cabs.sql:
from_cabs.sql:
hrc_hosts.sql:-- hrc_hosts.sql
hrc_hosts.sql:
hrc_hosts.sql:-- 20121130_1430 jk
hrc_hosts.sql:
hrc_hosts.sql:	select * 
hrc_hosts.sql:	from hrc_hosts
hrc_hosts.sql:
hrc_hosts.sql:	;
hrc_hosts.sql:
hrc_hosts.sql:
hrc_servers.sql:-- hrc_servers.sql
hrc_servers.sql:
hrc_servers.sql:-- 20121130_1430 jk
hrc_servers.sql:
hrc_servers.sql:	select * 
hrc_servers.sql:	from hrc_servers
hrc_servers.sql:
hrc_servers.sql:	;
hrc_servers.sql:
hrc_servers.sql:
hw_ampscab.sql:-- hw_ampscab.sql
hw_ampscab.sql:
hw_ampscab.sql:-- 20121130_1430 jk
hw_ampscab.sql:
hw_ampscab.sql:	select  planid, items, amps 
hw_ampscab.sql:	from kohw 
hw_ampscab.sql:	order by planid, amps desc 
hw_ampscab.sql:	where loadmode == ''
hw_ampscab.sql:
hw_ampscab.sql:
hw_ampscab.sql:	;
hw_ampscab.sql:
hw_ampscab.sql:
hw_cabamps.sql:-- hw_cabamps.sql
hw_cabamps.sql:
hw_cabamps.sql:-- 20121130_1430 jk
hw_cabamps.sql:
hw_cabamps.sql:	select cab, sum(amps) samps
hw_cabamps.sql:	from kohw
hw_cabamps.sql:	group by cab
hw_cabamps.sql:	order by samps desc, cab
hw_cabamps.sql:
hw_cabamps.sql:	;
hw_cabamps.sql:
hw_cabamps.sql:
hw.sql:-- hw.sql
hw.sql:-- ======
hw.sql:
hw.sql:--	20121128_1215 jk	
hw.sql:
hw.sql:	select * from hw
hw.sql:	;
hw.sql:
hw.sql:--	select planid, loadmode, cabnum, cablim, cab,cab1,cab2, sum(amps) samps
hw.sql:--	from koplans
hw.sql:--	where loadmode != ''
hw.sql:--	group by planid, loadmode, cabnum,cablim, cab, cab1, cab2 
hw.sql:--	order by planid, loadmode, cabnum,cablim, cab, cab1, cab2
hw.sql:--	;
hw.sql:	
items.sql:-- items.sql
items.sql:
items.sql:-- 20121130_1430 jk
items.sql:
items.sql:	select items, amps, sn, os, hrctag, osver, os, ip, machinename
items.sql:	from kohw
items.sql:	order by items, amps
items.sql:
items.sql:	;
items.sql:
items.sql:
jk1_20121129_134713.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1_20121129_134713.sql:
jk1_20121129_134713.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_134713.sql:--	from kohw
jk1_20121129_134713.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_134713.sql:--	order by cab, amps desc;
jk1_20121129_134713.sql:
jk1_20121129_134713.sql:
jk1_20121129_134713.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1_20121129_134713.sql:	group by planid, cab
jk1_20121129_134713.sql:	order by planid, cab;
jk1_20121129_134713.sql:
jk1_20121129_134713.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_134713.sql:--	from kohw
jk1_20121129_134713.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1_20121129_134713.sql:--	order by cab, amps desc;
jk1_20121129_134713.sql:
jk1_20121129_134713.sql:
jk1_20121129_134713.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_140853.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1_20121129_140853.sql:
jk1_20121129_140853.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_140853.sql:--	from kohw
jk1_20121129_140853.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_140853.sql:--	order by cab, amps desc;
jk1_20121129_140853.sql:
jk1_20121129_140853.sql:
jk1_20121129_140853.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1_20121129_140853.sql:	group by planid, cab
jk1_20121129_140853.sql:	order by planid, cab;
jk1_20121129_140853.sql:
jk1_20121129_140853.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_140853.sql:--	from kohw
jk1_20121129_140853.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1_20121129_140853.sql:--	order by cab, amps desc;
jk1_20121129_140853.sql:
jk1_20121129_140853.sql:
jk1_20121129_140853.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_141045.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1_20121129_141045.sql:
jk1_20121129_141045.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_141045.sql:--	from kohw
jk1_20121129_141045.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_141045.sql:--	order by cab, amps desc;
jk1_20121129_141045.sql:
jk1_20121129_141045.sql:
jk1_20121129_141045.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1_20121129_141045.sql:	group by planid, cab
jk1_20121129_141045.sql:	order by planid, cab;
jk1_20121129_141045.sql:
jk1_20121129_141045.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_141045.sql:--	from kohw
jk1_20121129_141045.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1_20121129_141045.sql:--	order by cab, amps desc;
jk1_20121129_141045.sql:
jk1_20121129_141045.sql:
jk1_20121129_141045.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_141234.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1_20121129_141234.sql:
jk1_20121129_141234.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_141234.sql:--	from kohw
jk1_20121129_141234.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_141234.sql:--	order by cab, amps desc;
jk1_20121129_141234.sql:
jk1_20121129_141234.sql:
jk1_20121129_141234.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1_20121129_141234.sql:	group by planid, cab
jk1_20121129_141234.sql:	order by planid, cab;
jk1_20121129_141234.sql:
jk1_20121129_141234.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_141234.sql:--	from kohw
jk1_20121129_141234.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1_20121129_141234.sql:--	order by cab, amps desc;
jk1_20121129_141234.sql:
jk1_20121129_141234.sql:
jk1_20121129_141234.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_141744.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1_20121129_141744.sql:
jk1_20121129_141744.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_141744.sql:--	from kohw
jk1_20121129_141744.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121129_141744.sql:--	order by cab, amps desc;
jk1_20121129_141744.sql:
jk1_20121129_141744.sql:
jk1_20121129_141744.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1_20121129_141744.sql:	group by planid, cab
jk1_20121129_141744.sql:	order by planid, cab;
jk1_20121129_141744.sql:
jk1_20121129_141744.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121129_141744.sql:--	from kohw
jk1_20121129_141744.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1_20121129_141744.sql:--	order by cab, amps desc;
jk1_20121129_141744.sql:
jk1_20121129_141744.sql:
jk1_20121129_141744.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121130_115347.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1_20121130_115347.sql:
jk1_20121130_115347.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121130_115347.sql:--	from kohw
jk1_20121130_115347.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1_20121130_115347.sql:--	order by cab, amps desc;
jk1_20121130_115347.sql:
jk1_20121130_115347.sql:
jk1_20121130_115347.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1_20121130_115347.sql:	group by planid, cab
jk1_20121130_115347.sql:	order by planid, cab;
jk1_20121130_115347.sql:
jk1_20121130_115347.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1_20121130_115347.sql:--	from kohw
jk1_20121130_115347.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1_20121130_115347.sql:--	order by cab, amps desc;
jk1_20121130_115347.sql:
jk1_20121130_115347.sql:
jk1_20121130_115347.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1.sql:
jk1.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1.sql:--	from kohw
jk1.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1.sql:--	order by cab, amps desc;
jk1.sql:
jk1.sql:
jk1.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1.sql:	group by planid, cab
jk1.sql:	order by planid, cab limit 5;
jk1.sql:
jk1.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1.sql:--	from kohw
jk1.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1.sql:--	order by cab, amps desc;
jk1.sql:
jk1.sql:
jk1.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1.sql:
jk_20121129_113306.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121129_113306.sql:
jk_20121129_113306.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_113306.sql:--	from kohw
jk_20121129_113306.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_113306.sql:--	order by cab, amps desc;
jk_20121129_113306.sql:
jk_20121129_113306.sql:
jk_20121129_113306.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121129_113306.sql:	group by planid, cab
jk_20121129_113306.sql:	order by planid, cab;
jk_20121129_113306.sql:
jk_20121129_113306.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_113306.sql:--	from kohw
jk_20121129_113306.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121129_113306.sql:--	order by cab, amps desc;
jk_20121129_113306.sql:
jk_20121129_113306.sql:
jk_20121129_113306.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_113345.sql:
jk_20121129_113345.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121129_113345.sql:
jk_20121129_113345.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_113345.sql:--	from kohw
jk_20121129_113345.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_113345.sql:--	order by cab, amps desc;
jk_20121129_113345.sql:
jk_20121129_113345.sql:
jk_20121129_113345.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121129_113345.sql:	group by planid, cab
jk_20121129_113345.sql:	order by planid, cab;
jk_20121129_113345.sql:
jk_20121129_113345.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_113345.sql:--	from kohw
jk_20121129_113345.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121129_113345.sql:--	order by cab, amps desc;
jk_20121129_113345.sql:
jk_20121129_113345.sql:
jk_20121129_113345.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_113345.sql:
jk_20121129_140623.sql:
jk_20121129_140623.sql:
jk_20121129_140623.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121129_140623.sql:
jk_20121129_140623.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_140623.sql:--	from kohw
jk_20121129_140623.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_140623.sql:--	order by cab, amps desc;
jk_20121129_140623.sql:
jk_20121129_140623.sql:
jk_20121129_140623.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121129_140623.sql:	group by planid, cab
jk_20121129_140623.sql:	order by planid, cab;
jk_20121129_140623.sql:
jk_20121129_140623.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_140623.sql:--	from kohw
jk_20121129_140623.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121129_140623.sql:--	order by cab, amps desc;
jk_20121129_140623.sql:
jk_20121129_140623.sql:
jk_20121129_140623.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_140623.sql:
jk_20121129_140623.sql:
jk_20121129_140815.sql:
jk_20121129_140815.sql:
jk_20121129_140815.sql:
jk_20121129_140815.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121129_140815.sql:
jk_20121129_140815.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_140815.sql:--	from kohw
jk_20121129_140815.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_140815.sql:--	order by cab, amps desc;
jk_20121129_140815.sql:
jk_20121129_140815.sql:
jk_20121129_140815.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121129_140815.sql:	group by planid, cab
jk_20121129_140815.sql:	order by planid, cab;
jk_20121129_140815.sql:
jk_20121129_140815.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121129_140815.sql:--	from kohw
jk_20121129_140815.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121129_140815.sql:--	order by cab, amps desc;
jk_20121129_140815.sql:
jk_20121129_140815.sql:
jk_20121129_140815.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121129_140815.sql:
jk_20121129_140815.sql:
jk_20121129_140815.sql:
jk_20121130_110427.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_110427.sql:
jk_20121130_110427.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_110427.sql:--	from kohw
jk_20121130_110427.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_110427.sql:--	order by cab, amps desc;
jk_20121130_110427.sql:
jk_20121130_110427.sql:
jk_20121130_110427.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_110427.sql:	group by planid, cab
jk_20121130_110427.sql:	order by planid, cab;
jk_20121130_110427.sql:
jk_20121130_110427.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_110427.sql:--	from kohw
jk_20121130_110427.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_110427.sql:--	order by cab, amps desc;
jk_20121130_110427.sql:
jk_20121130_110427.sql:
jk_20121130_110427.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_110427.sql:
jk_20121130_110427.sql:
jk_20121130_110427.sql:
jk_20121130_111634.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_111634.sql:
jk_20121130_111634.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_111634.sql:--	from kohw
jk_20121130_111634.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_111634.sql:--	order by cab, amps desc;
jk_20121130_111634.sql:
jk_20121130_111634.sql:
jk_20121130_111634.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_111634.sql:	group by planid, cab
jk_20121130_111634.sql:	order by planid, cab;
jk_20121130_111634.sql:
jk_20121130_111634.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_111634.sql:--	from kohw
jk_20121130_111634.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_111634.sql:--	order by cab, amps desc;
jk_20121130_111634.sql:
jk_20121130_111634.sql:
jk_20121130_111634.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_111634.sql:
jk_20121130_111634.sql:
jk_20121130_111634.sql:
jk_20121130_111956.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_111956.sql:
jk_20121130_111956.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_111956.sql:--	from kohw
jk_20121130_111956.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_111956.sql:--	order by cab, amps desc;
jk_20121130_111956.sql:
jk_20121130_111956.sql:
jk_20121130_111956.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_111956.sql:	group by planid, cab
jk_20121130_111956.sql:	order by planid, cab;
jk_20121130_111956.sql:
jk_20121130_111956.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_111956.sql:--	from kohw
jk_20121130_111956.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_111956.sql:--	order by cab, amps desc;
jk_20121130_111956.sql:
jk_20121130_111956.sql:
jk_20121130_111956.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_111956.sql:
jk_20121130_111956.sql:
jk_20121130_111956.sql:
jk_20121130_112054.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112054.sql:-- test 20121130_1125
jk_20121130_112054.sql:
jk_20121130_112054.sql:
jk_20121130_112054.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112054.sql:--	from kohw
jk_20121130_112054.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112054.sql:--	order by cab, amps desc;
jk_20121130_112054.sql:
jk_20121130_112054.sql:
jk_20121130_112054.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112054.sql:	group by planid, cab
jk_20121130_112054.sql:	order by planid, cab limit 5;
jk_20121130_112054.sql:
jk_20121130_112054.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112054.sql:--	from kohw
jk_20121130_112054.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112054.sql:--	order by cab, amps desc;
jk_20121130_112054.sql:
jk_20121130_112054.sql:
jk_20121130_112054.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112054.sql:
jk_20121130_112054.sql:
jk_20121130_112054.sql:
jk_20121130_112054.sql:
jk_20121130_112325.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112325.sql:-- test 20121130_1126
jk_20121130_112325.sql:
jk_20121130_112325.sql:
jk_20121130_112325.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112325.sql:--	from kohw
jk_20121130_112325.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112325.sql:--	order by cab, amps desc;
jk_20121130_112325.sql:
jk_20121130_112325.sql:
jk_20121130_112325.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112325.sql:	group by planid, cab
jk_20121130_112325.sql:	order by planid, cab limit 6;
jk_20121130_112325.sql:
jk_20121130_112325.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112325.sql:--	from kohw
jk_20121130_112325.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112325.sql:--	order by cab, amps desc;
jk_20121130_112325.sql:
jk_20121130_112325.sql:
jk_20121130_112325.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112325.sql:
jk_20121130_112325.sql:
jk_20121130_112325.sql:
jk_20121130_112325.sql:
jk_20121130_112325.sql:
jk_20121130_112425.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112425.sql:-- test 20121130_1128
jk_20121130_112425.sql:
jk_20121130_112425.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112425.sql:--	from kohw
jk_20121130_112425.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112425.sql:--	order by cab, amps desc;
jk_20121130_112425.sql:
jk_20121130_112425.sql:
jk_20121130_112425.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112425.sql:	group by planid, cab
jk_20121130_112425.sql:	order by planid, cab limit 8;
jk_20121130_112425.sql:
jk_20121130_112425.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112425.sql:--	from kohw
jk_20121130_112425.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112425.sql:--	order by cab, amps desc;
jk_20121130_112425.sql:
jk_20121130_112425.sql:
jk_20121130_112425.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112425.sql:
jk_20121130_112425.sql:
jk_20121130_112425.sql:
jk_20121130_112425.sql:
jk_20121130_112425.sql:
jk_20121130_112425.sql:
jk_20121130_112534.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112534.sql:-- test 20121130_1129
jk_20121130_112534.sql:
jk_20121130_112534.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112534.sql:--	from kohw
jk_20121130_112534.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112534.sql:--	order by cab, amps desc;
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112534.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112534.sql:	group by planid, cab
jk_20121130_112534.sql:	order by planid, cab limit 9;
jk_20121130_112534.sql:
jk_20121130_112534.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112534.sql:--	from kohw
jk_20121130_112534.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112534.sql:--	order by cab, amps desc;
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112534.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112534.sql:
jk_20121130_112556.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112556.sql:-- test 20121130_1130
jk_20121130_112556.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112556.sql:--	from kohw
jk_20121130_112556.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112556.sql:--	order by cab, amps desc;
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112556.sql:	group by planid, cab
jk_20121130_112556.sql:	order by planid, cab limit 3;
jk_20121130_112556.sql:
jk_20121130_112556.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112556.sql:--	from kohw
jk_20121130_112556.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112556.sql:--	order by cab, amps desc;
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112556.sql:
jk_20121130_112634.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112634.sql:-- test 20121130_1130
jk_20121130_112634.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112634.sql:--	from kohw
jk_20121130_112634.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112634.sql:--	order by cab, amps desc;
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112634.sql:	group by planid, cab
jk_20121130_112634.sql:	order by planid, cab limit 3;
jk_20121130_112634.sql:
jk_20121130_112634.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112634.sql:--	from kohw
jk_20121130_112634.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112634.sql:--	order by cab, amps desc;
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112634.sql:
jk_20121130_112814.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112814.sql:-- test 20121130_1130
jk_20121130_112814.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112814.sql:--	from kohw
jk_20121130_112814.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112814.sql:--	order by cab, amps desc;
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112814.sql:	group by planid, cab
jk_20121130_112814.sql:	order by planid, cab limit 3;
jk_20121130_112814.sql:
jk_20121130_112814.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112814.sql:--	from kohw
jk_20121130_112814.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112814.sql:--	order by cab, amps desc;
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112814.sql:
jk_20121130_112852.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112852.sql:-- test 20121130_1131
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112852.sql:--	from kohw
jk_20121130_112852.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112852.sql:--	order by cab, amps desc;
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112852.sql:	group by planid, cab
jk_20121130_112852.sql:	order by planid, cab limit 1;
jk_20121130_112852.sql:
jk_20121130_112852.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112852.sql:--	from kohw
jk_20121130_112852.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112852.sql:--	order by cab, amps desc;
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112852.sql:
jk_20121130_112925.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112925.sql:-- test 20121130_1134
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112925.sql:--	from kohw
jk_20121130_112925.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112925.sql:--	order by cab, amps desc;
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112925.sql:	group by planid, cab
jk_20121130_112925.sql:	order by planid, cab limit 4;
jk_20121130_112925.sql:
jk_20121130_112925.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112925.sql:--	from kohw
jk_20121130_112925.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112925.sql:--	order by cab, amps desc;
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112925.sql:
jk_20121130_112944.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_112944.sql:-- test 20121130_1105
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112944.sql:--	from kohw
jk_20121130_112944.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112944.sql:--	order by cab, amps desc;
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_112944.sql:	group by planid, cab
jk_20121130_112944.sql:	order by planid, cab limit 5;
jk_20121130_112944.sql:
jk_20121130_112944.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_112944.sql:--	from kohw
jk_20121130_112944.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_112944.sql:--	order by cab, amps desc;
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_112944.sql:
jk_20121130_113007.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_113007.sql:-- test 20121130_1105
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_113007.sql:--	from kohw
jk_20121130_113007.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_113007.sql:--	order by cab, amps desc;
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_113007.sql:	group by planid, cab
jk_20121130_113007.sql:	order by planid, cab limit 56;
jk_20121130_113007.sql:
jk_20121130_113007.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_113007.sql:--	from kohw
jk_20121130_113007.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_113007.sql:--	order by cab, amps desc;
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_113007.sql:
jk_20121130_114444.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_114444.sql:-- test 20121130_1105
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114444.sql:--	from kohw
jk_20121130_114444.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114444.sql:--	order by cab, amps desc;
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_114444.sql:	group by planid, cab
jk_20121130_114444.sql:	order by planid, cab limit 6;
jk_20121130_114444.sql:
jk_20121130_114444.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114444.sql:--	from kohw
jk_20121130_114444.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_114444.sql:--	order by cab, amps desc;
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114444.sql:
jk_20121130_114535.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_114535.sql:-- test 20121130_1106
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114535.sql:--	from kohw
jk_20121130_114535.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114535.sql:--	order by cab, amps desc;
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_114535.sql:	group by planid, cab
jk_20121130_114535.sql:	order by planid, cab limit 7;
jk_20121130_114535.sql:
jk_20121130_114535.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114535.sql:--	from kohw
jk_20121130_114535.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_114535.sql:--	order by cab, amps desc;
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114535.sql:
jk_20121130_114632.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_114632.sql:-- test 20121130_1106
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114632.sql:--	from kohw
jk_20121130_114632.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114632.sql:--	order by cab, amps desc;
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_114632.sql:	group by planid, cab
jk_20121130_114632.sql:	order by planid, cab limit 17;
jk_20121130_114632.sql:
jk_20121130_114632.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114632.sql:--	from kohw
jk_20121130_114632.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_114632.sql:--	order by cab, amps desc;
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114632.sql:
jk_20121130_114654.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_114654.sql:-- test 20121130_1106
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114654.sql:--	from kohw
jk_20121130_114654.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114654.sql:--	order by cab, amps desc;
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_114654.sql:	group by planid, cab
jk_20121130_114654.sql:	order by planid, cab limit 7;
jk_20121130_114654.sql:
jk_20121130_114654.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114654.sql:--	from kohw
jk_20121130_114654.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_114654.sql:--	order by cab, amps desc;
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114654.sql:
jk_20121130_114844.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_114844.sql:-- test 20121130_1106
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114844.sql:--	from kohw
jk_20121130_114844.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114844.sql:--	order by cab, amps desc;
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_114844.sql:	group by planid, cab
jk_20121130_114844.sql:	order by planid, cab limit 17;
jk_20121130_114844.sql:
jk_20121130_114844.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_114844.sql:--	from kohw
jk_20121130_114844.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_114844.sql:--	order by cab, amps desc;
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_114844.sql:
jk_20121130_121210.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_121210.sql:-- test 20121130_1106
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_121210.sql:--	from kohw
jk_20121130_121210.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_121210.sql:--	order by cab, amps desc;
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_121210.sql:	group by planid, cab
jk_20121130_121210.sql:	order by planid, cab limit 7;
jk_20121130_121210.sql:
jk_20121130_121210.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_121210.sql:--	from kohw
jk_20121130_121210.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_121210.sql:--	order by cab, amps desc;
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_121210.sql:
jk_20121130_123022.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk_20121130_123022.sql:-- test 20121130_1106
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_123022.sql:--	from kohw
jk_20121130_123022.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_123022.sql:--	order by cab, amps desc;
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk_20121130_123022.sql:	group by planid, cab
jk_20121130_123022.sql:	order by planid, cab limit 7;
jk_20121130_123022.sql:
jk_20121130_123022.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk_20121130_123022.sql:--	from kohw
jk_20121130_123022.sql:--	where cab in ( select distinct( cab ) from koplans )
jk_20121130_123022.sql:--	order by cab, amps desc;
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk_20121130_123022.sql:
jk2.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk2.sql:
jk2.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk2.sql:--	from kohw
jk2.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk2.sql:--	order by cab, amps desc;
jk2.sql:
jk2.sql:
jk2.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk2.sql:	group by planid, cab
jk2.sql:	order by planid, cab;
jk2.sql:
jk2.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk2.sql:--	from kohw
jk2.sql:--	where cab in ( select distinct( cab ) from koplans )
jk2.sql:--	order by cab, amps desc;
jk2.sql:
jk2.sql:
jk2.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3_20121129_134948.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk3_20121129_134948.sql:
jk3_20121129_134948.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3_20121129_134948.sql:--	from kohw
jk3_20121129_134948.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3_20121129_134948.sql:--	order by cab, amps desc;
jk3_20121129_134948.sql:
jk3_20121129_134948.sql:
jk3_20121129_134948.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk3_20121129_134948.sql:	group by planid, cab
jk3_20121129_134948.sql:	order by planid, cab;
jk3_20121129_134948.sql:
jk3_20121129_134948.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3_20121129_134948.sql:--	from kohw
jk3_20121129_134948.sql:--	where cab in ( select distinct( cab ) from koplans )
jk3_20121129_134948.sql:--	order by cab, amps desc;
jk3_20121129_134948.sql:
jk3_20121129_134948.sql:
jk3_20121129_134948.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3_20121129_135031.sql:
jk3_20121129_135031.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk3_20121129_135031.sql:
jk3_20121129_135031.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3_20121129_135031.sql:--	from kohw
jk3_20121129_135031.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3_20121129_135031.sql:--	order by cab, amps desc;
jk3_20121129_135031.sql:
jk3_20121129_135031.sql:
jk3_20121129_135031.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk3_20121129_135031.sql:	group by planid, cab
jk3_20121129_135031.sql:	order by planid, cab;
jk3_20121129_135031.sql:
jk3_20121129_135031.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3_20121129_135031.sql:--	from kohw
jk3_20121129_135031.sql:--	where cab in ( select distinct( cab ) from koplans )
jk3_20121129_135031.sql:--	order by cab, amps desc;
jk3_20121129_135031.sql:
jk3_20121129_135031.sql:
jk3_20121129_135031.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3_20121129_135031.sql:
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3_20121129_135053.sql:--	from kohw
jk3_20121129_135053.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3_20121129_135053.sql:--	order by cab, amps desc;
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk3_20121129_135053.sql:	group by planid, cab
jk3_20121129_135053.sql:	order by planid, cab;
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3_20121129_135053.sql:--	from kohw
jk3_20121129_135053.sql:--	where cab in ( select distinct( cab ) from koplans )
jk3_20121129_135053.sql:--	order by cab, amps desc;
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3_20121129_135053.sql:
jk3_20121129_135053.sql:
jk3.sql:
jk3.sql:
jk3.sql:
jk3.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk3.sql:
jk3.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3.sql:--	from kohw
jk3.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3.sql:--	order by cab, amps desc;
jk3.sql:
jk3.sql:
jk3.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk3.sql:	group by planid, cab
jk3.sql:	order by planid, cab;
jk3.sql:
jk3.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3.sql:--	from kohw
jk3.sql:--	where cab in ( select distinct( cab ) from koplans )
jk3.sql:--	order by cab, amps desc;
jk3.sql:
jk3.sql:
jk3.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3.sql:
jk3.sql:
jk3.sql:
jk4_20121129_135225.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4_20121129_135225.sql:
jk4_20121129_135225.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_135225.sql:--	from kohw
jk4_20121129_135225.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_135225.sql:--	order by cab, amps desc;
jk4_20121129_135225.sql:
jk4_20121129_135225.sql:
jk4_20121129_135225.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4_20121129_135225.sql:	group by planid, cab
jk4_20121129_135225.sql:	order by planid, cab;
jk4_20121129_135225.sql:
jk4_20121129_135225.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_135225.sql:--	from kohw
jk4_20121129_135225.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4_20121129_135225.sql:--	order by cab, amps desc;
jk4_20121129_135225.sql:
jk4_20121129_135225.sql:
jk4_20121129_135225.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_135531.sql:
jk4_20121129_135531.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4_20121129_135531.sql:
jk4_20121129_135531.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_135531.sql:--	from kohw
jk4_20121129_135531.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_135531.sql:--	order by cab, amps desc;
jk4_20121129_135531.sql:
jk4_20121129_135531.sql:
jk4_20121129_135531.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4_20121129_135531.sql:	group by planid, cab
jk4_20121129_135531.sql:	order by planid, cab;
jk4_20121129_135531.sql:
jk4_20121129_135531.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_135531.sql:--	from kohw
jk4_20121129_135531.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4_20121129_135531.sql:--	order by cab, amps desc;
jk4_20121129_135531.sql:
jk4_20121129_135531.sql:
jk4_20121129_135531.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_135531.sql:
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_135820.sql:--	from kohw
jk4_20121129_135820.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_135820.sql:--	order by cab, amps desc;
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4_20121129_135820.sql:	group by planid, cab
jk4_20121129_135820.sql:	order by planid, cab;
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_135820.sql:--	from kohw
jk4_20121129_135820.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4_20121129_135820.sql:--	order by cab, amps desc;
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_135820.sql:
jk4_20121129_135820.sql:
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140008.sql:--	from kohw
jk4_20121129_140008.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140008.sql:--	order by cab, amps desc;
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4_20121129_140008.sql:	group by planid, cab
jk4_20121129_140008.sql:	order by planid, cab;
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140008.sql:--	from kohw
jk4_20121129_140008.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4_20121129_140008.sql:--	order by cab, amps desc;
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:
jk4_20121129_140008.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140114.sql:--	from kohw
jk4_20121129_140114.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140114.sql:--	order by cab, amps desc;
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4_20121129_140114.sql:	group by planid, cab
jk4_20121129_140114.sql:	order by planid, cab;
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140114.sql:--	from kohw
jk4_20121129_140114.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4_20121129_140114.sql:--	order by cab, amps desc;
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140114.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140249.sql:--	from kohw
jk4_20121129_140249.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140249.sql:--	order by cab, amps desc;
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4_20121129_140249.sql:	group by planid, cab
jk4_20121129_140249.sql:	order by planid, cab;
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140249.sql:--	from kohw
jk4_20121129_140249.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4_20121129_140249.sql:--	order by cab, amps desc;
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140249.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140432.sql:--	from kohw
jk4_20121129_140432.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140432.sql:--	order by cab, amps desc;
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4_20121129_140432.sql:	group by planid, cab
jk4_20121129_140432.sql:	order by planid, cab;
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4_20121129_140432.sql:--	from kohw
jk4_20121129_140432.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4_20121129_140432.sql:--	order by cab, amps desc;
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4_20121129_140432.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4.sql:
jk4.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4.sql:--	from kohw
jk4.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4.sql:--	order by cab, amps desc;
jk4.sql:
jk4.sql:
jk4.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4.sql:	group by planid, cab
jk4.sql:	order by planid, cab;
jk4.sql:
jk4.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4.sql:--	from kohw
jk4.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4.sql:--	order by cab, amps desc;
jk4.sql:
jk4.sql:
jk4.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk4.sql:
jk5.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk5.sql:
jk5.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk5.sql:--	from kohw
jk5.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk5.sql:--	order by cab, amps desc;
jk5.sql:
jk5.sql:
jk5.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk5.sql:	group by planid, cab
jk5.sql:	order by planid, cab;
jk5.sql:
jk5.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk5.sql:--	from kohw
jk5.sql:--	where cab in ( select distinct( cab ) from koplans )
jk5.sql:--	order by cab, amps desc;
jk5.sql:
jk5.sql:
jk5.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk.sql:-- test 20121130_1106
jk.sql:
jk.sql:
jk.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk.sql:--	from kohw
jk.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk.sql:--	order by cab, amps desc;
jk.sql:
jk.sql:
jk.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk.sql:	group by planid, cab
jk.sql:	order by planid, cab limit 5;
jk.sql:
jk.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk.sql:--	from kohw
jk.sql:--	where cab in ( select distinct( cab ) from koplans )
jk.sql:--	order by cab, amps desc;
jk.sql:
jk.sql:
jk.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
jk.sql:
join_plan0-hw1.sql:-- join_plan0-hw1.sql
join_plan0-hw1.sql:
join_plan0-hw1.sql:-- 20121130_1430 jk
join_plan0-hw1.sql:
join_plan0-hw1.sql:	select * 
join_plan0-hw1.sql:	from rpts
join_plan0-hw1.sql:
join_plan0-hw1.sql:	;
join_plan0-hw1.sql:
join_plan0-hw1.sql:
ko_center.sql:-- ko_center.sql
ko_center.sql:
ko_center.sql:-- 20121130_1430 jk
ko_center.sql:
ko_center.sql:	select * 
ko_center.sql:	from rpts
ko_center.sql:
ko_center.sql:	;
ko_center.sql:
ko_center.sql:
ko_defrag.sql:-- ko_defrag.sql
ko_defrag.sql:
ko_defrag.sql:-- 20121130_1430 jk
ko_defrag.sql:
ko_defrag.sql:	select * 
ko_defrag.sql:	from rpts
ko_defrag.sql:
ko_defrag.sql:	;
ko_defrag.sql:
ko_defrag.sql:
kohw.sql:-- kohw.sql
kohw.sql:
kohw.sql:-- 20121130_1430 jk
kohw.sql:
kohw.sql:	select * 
kohw.sql:	from kohw
kohw.sql:
kohw.sql:	;
kohw.sql:
kohw.sql:
koplans.sql:-- koplans.sql
koplans.sql:
koplans.sql:-- 20121130_1430 jk
koplans.sql:
koplans.sql:	select * 
koplans.sql:	from koplans
koplans.sql:
koplans.sql:	;
koplans.sql:
koplans.sql:
leds_blu_defrag.sql:-- leds_blu_defrag.sql
leds_blu_defrag.sql:
leds_blu_defrag.sql:-- 20121130_1430 jk
leds_blu_defrag.sql:
leds_blu_defrag.sql:	update leds set led_color='blu' where led_code in ( 'a01', 'a02', 'a03' ); 
leds_blu_defrag.sql:	update leds set led_speed='90' where led_code in ( 'a01', 'a02', 'a03' ); 
leds_blu_defrag.sql:
leds_blu_defrag.sql:	;
leds_blu_defrag.sql:
leds_blu_defrag.sql:
leds_grn_defrag.sql:-- leds_grn_defrag.sql
leds_grn_defrag.sql:
leds_grn_defrag.sql:-- 20121130_1430 jk
leds_grn_defrag.sql:
leds_grn_defrag.sql:
leds_grn_defrag.sql:
leds_grn_defrag.sql:        update leds set led_color='grn' where led_code in ( 'a01', 'a02', 'a03' );
leds_grn_defrag.sql:        update leds set led_speed='90' where led_code in ( 'a01', 'a02', 'a03' );
leds_grn_defrag.sql:
leds_grn_defrag.sql:
leds_grn_defrag.sql:	;
leds_grn_defrag.sql:
leds_grn_defrag.sql:
leds_red_defrag.sql:-- leds_red_defrag.sql
leds_red_defrag.sql:
leds_red_defrag.sql:-- 20121130_1430 jk
leds_red_defrag.sql:
leds_red_defrag.sql:
leds_red_defrag.sql:
leds_red_defrag.sql:        update leds set led_color='red' where led_code in ( 'a01', 'a02', 'a03' );
leds_red_defrag.sql:        update leds set led_speed='90' where led_code in ( 'a01', 'a02', 'a03' );
leds_red_defrag.sql:
leds_red_defrag.sql:
leds_red_defrag.sql:
leds_red_defrag.sql:	;
leds_red_defrag.sql:
leds_red_defrag.sql:
leds.sql:-- leds.sql
leds.sql:
leds.sql:-- 20121130_1430 jk
leds.sql:
leds.sql:	select * 
leds.sql:	from rpts
leds.sql:
leds.sql:	;
leds.sql:
leds.sql:
nodes.sql:-- nodes.sql
nodes.sql:
nodes.sql:-- 20121130_1430 jk
nodes.sql:
nodes.sql:	select * 
nodes.sql:	from nodes
nodes.sql:
nodes.sql:	;
nodes.sql:
nodes.sql:
plans_ampscab.sql:-- plans_ampscab.sql
plans_ampscab.sql:
plans_ampscab.sql:-- 20121130_1430 jk
plans_ampscab.sql:
plans_ampscab.sql:	select  cab, sum(amps) samps  
plans_ampscab.sql:	from koplans
plans_ampscab.sql:	group by planid, cab, 
plans_ampscab.sql:
plans_ampscab.sql:--	where loadmode == ''
plans_ampscab.sql:--	where loadmode != ''
plans_ampscab.sql:
plans_ampscab.sql:	order by samps, cab
plans_ampscab.sql:	;
plans_ampscab.sql:
plans_ampscab.sql:
plans_cabamps.sql:-- plans_cabamps.sql
plans_cabamps.sql:
plans_cabamps.sql:-- 20121130_1430 jk
plans_cabamps.sql:
plans_cabamps.sql:	select * rpts
plans_cabamps.sql:
plans_cabamps.sql:	;
plans_cabamps.sql:
plans_cabamps.sql:
plans_cab.sql:-- plans_cab.sql
plans_cab.sql:
plans_cab.sql:-- 20121130_1430 jk
plans_cab.sql:
plans_cab.sql:	select planid, cab
plans_cab.sql:	from koplans
plans_cab.sql:	group by planid
plans_cab.sql:
plans_cab.sql:--	where loadmode == ''
plans_cab.sql:--	where loadmode != ''
plans_cab.sql:
plans_cab.sql:	from smb_hosts
plans_cab.sql:
plans_cab.sql:	;
plans_cab.sql:
plans_cab.sql:
plans.sql:-- plans.sql
plans.sql:
plans.sql:-- 20121130_1430 jk
plans.sql:
plans.sql:	select count(*) plantotals 
plans.sql:	from plans
plans.sql:
plans.sql:	;
plans.sql:
plans.sql:
rns_servers.sql:-- rns_servers.sql
rns_servers.sql:
rns_servers.sql:-- 20121130_1430 jk
rns_servers.sql:
rns_servers.sql:	select * 
rns_servers.sql:	from rns_servers
rns_servers.sql:
rns_servers.sql:	;
rns_servers.sql:
rns_servers.sql:
rowcab.sql:-- rowcab.sql
rowcab.sql:
rowcab.sql:-- 20121130_1430 jk
rowcab.sql:
rowcab.sql:	select * 
rowcab.sql:	from rpts
rowcab.sql:
rowcab.sql:	;
rowcab.sql:
rowcab.sql:
sm1_20121130_102200.sql:-- defrag_plans_items_sum
sm1_20121130_102200.sql:
sm1_20121130_102200.sql:	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, sum(amps) samps 
sm1_20121130_102200.sql:	from koplans
sm1_20121130_102200.sql:	where loadmode == ''
sm1_20121130_102200.sql:	group by planid, cabnum, cablim
sm1_20121130_102200.sql:	order by planid, cabnum, cablim
sm1_20121130_102200.sql:	;
sm1_20121130_102200.sql:
sm1_20121130_102200.sql:
sm1_20121130_102200.sql:--	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
sm1_20121130_102200.sql:--	from koplans
sm1_20121130_102200.sql:--	where loadmode==''
sm1_20121130_102200.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
sm1_20121130_102200.sql:--	order by planid, cabnum, cablim, cab, cab1, cab2
sm1_20121130_102200.sql:--	;
sm1.sql:-- defrag_plans_items_sum
sm1.sql:
sm1.sql:	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, sum(amps) samps 
sm1.sql:	from koplans
sm1.sql:	where loadmode == ''
sm1.sql:	group by planid, cabnum, cablim
sm1.sql:	order by planid, cabnum, cablim
sm1.sql:	;
sm1.sql:
sm1.sql:
sm1.sql:--	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
sm1.sql:--	from koplans
sm1.sql:--	where loadmode==''
sm1.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
sm1.sql:--	order by planid, cabnum, cablim, cab, cab1, cab2
sm1.sql:--	;
sm2.sql:-- defrag_plans_items_sum
sm2.sql:
sm2.sql:--	select 'defrag_plans_sum', date('now'), planid, loadmode, cabnum,cablim, sum(amps) samps 
sm2.sql:--	from koplans
sm2.sql:--	where loadmode == ''
sm2.sql:--	group by planid, cabnum, cablim
sm2.sql:--	order by planid, cabnum, cablim
sm2.sql:--	;
sm2.sql:
sm2.sql:
sm2.sql:	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
sm2.sql:	from koplans
sm2.sql:	where loadmode==''
sm2.sql:	group by planid, cabnum, cablim, cab, cab1, cab2
sm2.sql:	order by planid, cabnum, cablim, cab, cab1, cab2
sm2.sql:	;
sm3.sql:-- defrag_plans_items_sum
sm3.sql:
sm3.sql:--	select 'defrag_plans_sum', date('now'), planid, loadmode, cabnum,cablim, sum(amps) samps 
sm3.sql:--	from koplans
sm3.sql:--	where loadmode == ''
sm3.sql:--	group by planid, cabnum, cablim
sm3.sql:--	order by planid, cabnum, cablim
sm3.sql:--	;
sm3.sql:
sm3.sql:
sm3.sql:--	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
sm3.sql:--	from koplans
sm3.sql:--	where loadmode==''
sm3.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
sm3.sql:--	order by planid, cabnum, cablim, cab, cab1, cab2
sm3.sql:--	;
sm3.sql:
sm3.sql:	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, amps, hostname, sn, hrctag, ip 
sm3.sql:	from koplans
sm3.sql:	where loadmode==''
sm3.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
sm3.sql:	order by planid, cabnum, cablim, cab, cab1, cab2, amps, hostname, sn, hrctag, ip
sm3.sql:	;
sm4.sql:-- sm4.sql
sm4.sql:-- ======
sm4.sql:
sm4.sql:--	20121128_1215 jk	
sm4.sql:
sm4.sql:	select planid, loadmode, cabnum, cablim, cab,cab1,cab2, sum(amps) samps
sm4.sql:	from koplans
sm4.sql:	where loadmode == ''
sm4.sql:	group by planid, loadmode, cabnum,cablim, cab, cab1, cab2 
sm4.sql:	order by planid, loadmode, cabnum,cablim, samps, cab, cab1, cab2
sm4.sql:	;
sm4.sql:	
sm5.sql:-- sm5.sql
sm5.sql:-- ======
sm5.sql:
sm5.sql:--	20121128_1215 jk	
sm5.sql:
sm5.sql:	select planid, loadmode, cabnum, cablim, sum(amps) samps
sm5.sql:	from koplans
sm5.sql:	where loadmode != ''
sm5.sql:	group by planid, loadmode, cabnum, cablim
sm5.sql:	order by planid, loadmode, cabnum, cablim, samps 
sm5.sql:	;
sm5.sql:	
smb_apps.sql:-- smb_apps.sql
smb_apps.sql:
smb_apps.sql:-- 20121130_1430 jk
smb_apps.sql:
smb_apps.sql:        select apps , count(*) counts
smb_apps.sql:        from smb_hosts
smb_apps.sql:        group by apps
smb_apps.sql:        order by apps
smb_apps.sql:-       order by counts desc
smb_apps.sql:
smb_apps.sql:	;
smb_apps.sql:
smb_apps.sql:
smb_cpu.sql:-- smb_cpu.sql
smb_cpu.sql:
smb_cpu.sql:-- 20121130_1430 jk
smb_cpu.sql:
smb_cpu.sql:
smb_cpu.sql:        select cpu , count(*) counts
smb_cpu.sql:        from smb_hosts
smb_cpu.sql:        group by cpu
smb_cpu.sql:        order by cpu
smb_cpu.sql:-       order by counts desc
smb_cpu.sql:
smb_cpu.sql:	;
smb_cpu.sql:
smb_cpu.sql:
smb_domain.sql:-- smb_domain.sql
smb_domain.sql:
smb_domain.sql:-- 20121130_1430 jk
smb_domain.sql:
smb_domain.sql:        select domain , count(*) counts
smb_domain.sql:        from smb_hosts
smb_domain.sql:        group by domain
smb_domain.sql:        order by domain
smb_domain.sql:-       order by counts desc
smb_domain.sql:
smb_domain.sql:	;
smb_domain.sql:
smb_domain.sql:
smb_func.sql:-- smb_func.sql
smb_func.sql:
smb_func.sql:-- 20121130_1430 jk
smb_func.sql:
smb_func.sql:
smb_func.sql:        select func , count(*) counts
smb_func.sql:        from smb_hosts
smb_func.sql:        group by func
smb_func.sql:        order by func
smb_func.sql:-       order by counts desc
smb_func.sql:
smb_func.sql:
smb_func.sql:	;
smb_func.sql:
smb_func.sql:
smb_hosts.sql:-- smb_hosts.sql
smb_hosts.sql:
smb_hosts.sql:-- 20121130_1430 jk
smb_hosts.sql:
smb_hosts.sql:	select * 
smb_hosts.sql:	from smb_hosts
smb_hosts.sql:
smb_hosts.sql:	;
smb_hosts.sql:
smb_hosts.sql:
smb_make.sql:-- smb_make.sql
smb_make.sql:
smb_make.sql:-- 20121130_1430 jk
smb_make.sql:
smb_make.sql:
smb_make.sql:        select make , count(*) counts
smb_make.sql:        from smb_hosts
smb_make.sql:        group by make
smb_make.sql:        order by make
smb_make.sql:-       order by counts desc
smb_make.sql:
smb_make.sql:	;
smb_make.sql:
smb_make.sql:
smb_mem.sql:-- smb_mem.sql
smb_mem.sql:
smb_mem.sql:-- 20121130_1430 jk
smb_mem.sql:
smb_mem.sql:	select mem , count(*) counts
smb_mem.sql:        from smb_hosts
smb_mem.sql:        group by mem
smb_mem.sql:        order by mem
smb_mem.sql:-       order by counts desc
smb_mem.sql:
smb_mem.sql:	;
smb_model.sql:-- smb_model.sql
smb_model.sql:
smb_model.sql:-- 20121130_1430 jk
smb_model.sql:
smb_model.sql:
smb_model.sql:        select model , count(*) counts
smb_model.sql:        from smb_hosts
smb_model.sql:        group by model
smb_model.sql:        order by model
smb_model.sql:-       order by counts desc
smb_model.sql:
smb_model.sql:	;
smb_model.sql:
smb_model.sql:
smb_name.sql:-- smb_name.sql
smb_name.sql:
smb_name.sql:-- 20121130_1430 jk
smb_name.sql:
smb_name.sql:	select name , count(*) counts
smb_name.sql:        from smb_hosts
smb_name.sql:        group by name
smb_name.sql:        order by name
smb_name.sql:-       order by counts desc
smb_name.sql:
smb_name.sql:	;
smb_null_apps.sql:-- smb_null_apps.sql
smb_null_apps.sql:
smb_null_apps.sql:-- 20121130_1430 jk
smb_null_apps.sql:
smb_null_apps.sql:        select "smb_null_apps','date('now'), * 
smb_null_apps.sql:        from smb_hosts 
smb_null_apps.sql:        where apps == ''
smb_null_apps.sql:
smb_null_apps.sql:
smb_null_apps.sql:
smb_null_apps.sql:	;
smb_null_apps.sql:
smb_null_apps.sql:
smb_null_domain.sql:-- smb_null_domain.sql
smb_null_domain.sql:
smb_null_domain.sql:-- 20121130_1430 jk
smb_null_domain.sql:
smb_null_domain.sql:
smb_null_domain.sql:        select "smb_null_domain','date('now'), * 
smb_null_domain.sql:        from smb_hosts 
smb_null_domain.sql:        where domain == ''
smb_null_domain.sql:
smb_null_domain.sql:
smb_null_domain.sql:
smb_null_domain.sql:	;
smb_null_domain.sql:
smb_null_domain.sql:
smb_null_hrctag.sql:-- smb_null_hrctag.sql
smb_null_hrctag.sql:
smb_null_hrctag.sql:-- 20121130_1430 jk
smb_null_hrctag.sql:
smb_null_hrctag.sql:        select "smb_null_hrctag','date('now'), * 
smb_null_hrctag.sql:        from smb_hosts 
smb_null_hrctag.sql:        where hrctag == ''
smb_null_hrctag.sql:
smb_null_hrctag.sql:
smb_null_hrctag.sql:	;
smb_null_hrctag.sql:
smb_null_hrctag.sql:
smb_null_make.sql:-- smb_null_make.sql
smb_null_make.sql:
smb_null_make.sql:-- 20121130_1430 jk
smb_null_make.sql:
smb_null_make.sql:
smb_null_make.sql:        select "smb_null_make','date('now'), * 
smb_null_make.sql:        from smb_hosts 
smb_null_make.sql:        where make == ''
smb_null_make.sql:
smb_null_make.sql:
smb_null_make.sql:
smb_null_make.sql:	;
smb_null_make.sql:
smb_null_make.sql:
smb_null_model.sql:-- smb_null_model.sql
smb_null_model.sql:
smb_null_model.sql:-- 20121130_1430 jk
smb_null_model.sql:
smb_null_model.sql:
smb_null_model.sql:        select "smb_null_model','date('now'), * 
smb_null_model.sql:        from smb_hosts 
smb_null_model.sql:        where model == ''
smb_null_model.sql:
smb_null_model.sql:
smb_null_model.sql:
smb_null_model.sql:	;
smb_null_model.sql:
smb_null_model.sql:
smb_null_name.sql:-- smb_null_name.sql
smb_null_name.sql:
smb_null_name.sql:-- 20121130_1430 jk
smb_null_name.sql:
smb_null_name.sql:
smb_null_name.sql:        select "smb_null_name','date('now'), * 
smb_null_name.sql:        from smb_hosts 
smb_null_name.sql:        where name == ''
smb_null_name.sql:
smb_null_name.sql:
smb_null_name.sql:
smb_null_name.sql:	;
smb_null_name.sql:
smb_null_name.sql:
smb_null_service.sql:-- smb_null_service.sql
smb_null_service.sql:
smb_null_service.sql:-- 20121130_1430 jk
smb_null_service.sql:
smb_null_service.sql:	select "smb_null_service','date('now'), * 
smb_null_service.sql:	from smb_hosts 
smb_null_service.sql:	where service == ''
smb_null_service.sql:
smb_null_service.sql:
smb_null_service.sql:
smb_null_service.sql:	;
smb_null_service.sql:
smb_null_service.sql:
smb_null_sn.sql:-- smb_null_sn.sql
smb_null_sn.sql:
smb_null_sn.sql:-- 20121130_1430 jk
smb_null_sn.sql:
smb_null_sn.sql:        select "smb_null_sn','date('now'), * 
smb_null_sn.sql:        from smb_hosts 
smb_null_sn.sql:        where sn == ''
smb_null_sn.sql:
smb_null_sn.sql:
smb_null_sn.sql:	;
smb_null_sn.sql:
smb_null_sn.sql:
smb_os.sql:-- smb_os.sql
smb_os.sql:
smb_os.sql:-- 20121130_1430 jk
smb_os.sql:
smb_os.sql:        select os , count(*) counts
smb_os.sql:        from smb_hosts
smb_os.sql:        group by os
smb_os.sql:        order by os
smb_os.sql:-       order by counts desc
smb_os.sql:
smb_os.sql:	;
smb_os.sql:
smb_os.sql:
smb_poc.sql:-- smb_poc.sql
smb_poc.sql:
smb_poc.sql:-- 20121130_1430 jk
smb_poc.sql:
smb_poc.sql:        select poc , count(*) counts
smb_poc.sql:        from smb_hosts
smb_poc.sql:        group by poc
smb_poc.sql:        order by poc
smb_poc.sql:-       order by counts desc
smb_poc.sql:
smb_poc.sql:	;
smb_poc.sql:
smb_poc.sql:
smb_rpts1.sql:-- smb_rpts1.sql
smb_rpts1.sql:
smb_rpts1.sql:-- 20121130_1430 jk
smb_rpts1.sql:
smb_rpts1.sql:	select * 
smb_rpts1.sql:	from smb_rpts1.sql
smb_rpts1.sql:
smb_rpts1.sql:	;
smb_rpts1.sql:
smb_rpts1.sql:
smb_rpts.sql:-- smb_rpts.sql
smb_rpts.sql:
smb_rpts.sql:-- 20121130_1430 jk
smb_rpts.sql:
smb_rpts.sql:	select * 
smb_rpts.sql:	from smb_rpts
smb_rpts.sql:
smb_rpts.sql:	;
smb_rpts.sql:
smb_rpts.sql:
smb_sdt.sql:-- smb_sdt.sql
smb_sdt.sql:
smb_sdt.sql:-- 20121130_1430 jk
smb_sdt.sql:
smb_sdt.sql:        select sdt , count(*) counts
smb_sdt.sql:        from smb_hosts
smb_sdt.sql:        group by sdt
smb_sdt.sql:        order by sdt
smb_sdt.sql:-       order by counts desc
smb_sdt.sql:
smb_sdt.sql:	;
smb_sdt.sql:
smb_sdt.sql:
smb_servers.sql:-- smb_servers.sql
smb_servers.sql:
smb_servers.sql:-- 20121130_1430 jk
smb_servers.sql:
smb_servers.sql:	select * 
smb_servers.sql:	from smb_servers
smb_servers.sql:
smb_servers.sql:	;
smb_servers.sql:
smb_servers.sql:
smb_service.sql:-- smb_service.sql
smb_service.sql:
smb_service.sql:-- 20121130_1430 jk
smb_service.sql:
smb_service.sql:	select service , count(*) counts
smb_service.sql:	from smb_hosts
smb_service.sql:	group by service
smb_service.sql:	order by service
smb_service.sql:-	order by counts desc
smb_service.sql:
smb_service.sql:
smb_service.sql:	;
smb_service.sql:
smb_service.sql:
smb_team.sql:-- smb_team.sql
smb_team.sql:
smb_team.sql:-- 20121130_1430 jk
smb_team.sql:
smb_team.sql:        select team , count(*) counts
smb_team.sql:        from smb_hosts
smb_team.sql:        group by team
smb_team.sql:        order by team
smb_team.sql:-       order by counts desc
smb_team.sql:
smb_team.sql:
smb_team.sql:	;
smb_team.sql:
smb_team.sql:
sm.sql:-- sm.sql
sm.sql:-- ======
sm.sql:
sm.sql:--	20121128_1215 jk	
sm.sql:
sm.sql:	select planid, loadmode, cabnum, cablim, cab,cab1,cab2, sum(amps) samps
sm.sql:	from koplans
sm.sql:	where loadmode != ''
sm.sql:	group by planid, loadmode, cabnum,cablim, cab, cab1, cab2 
sm.sql:	order by planid, loadmode, cabnum,cablim, cab, cab1, cab2
sm.sql:	;
sm.sql:	
templet.sql:-- templet.sql
templet.sql:
templet.sql:-- 20121130_1430 jk
templet.sql:
templet.sql:	select * 
templet.sql:	from smb_hosts
templet.sql:
templet.sql:	;
templet.sql:
templet.sql:
update_planamps.sql:-- update_planamps.sql
update_planamps.sql:
update_planamps.sql:-- 20121130_1430 jk
update_planamps.sql:
update_planamps.sql:
update_planamps.sql:-- update koplans set amps = ...
update_planamps.sql:
update_planamps.sql:	;
update_planamps.sql:
update_planamps.sql:
us.sql:-- us.sql
us.sql:
us.sql:-- 20121130_1430 jk
us.sql:
us.sql:	select * 
us.sql:	from us
us.sql:
us.sql:
us.sql:	;
us.sql:
us.sql:
wk1.sql:-- wk.sql
wk1.sql:
wk1.sql:	select *
wk1.sql:	from kohw limit 10
wk1.sql:	
wk2.sql:-- wk.sql
wk2.sql:
wk2.sql:	select *
wk2.sql:	from kohw limit 10
wk2.sql:	
wk3.sql:-- wk.sql
wk3.sql:
wk3.sql:	select *
wk3.sql:	from kohw limit 10
wk3.sql:	
wk4.sql:-- wk.sql
wk4.sql:
wk4.sql:	select *
wk4.sql:	from kohw limit 10
wk4.sql:	
wk5.sql:-- wk.sql
wk5.sql:
wk5.sql:	select *
wk5.sql:	from kohw limit 10
wk5.sql:	
wk.sql:-- wk.sql
wk.sql:
wk.sql:	select *
wk.sql:	from kohw limit 10
wk.sql: