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

/home/kozerus/public_html/ko_center/sql

-- defrag_tocabs.sql

--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
--	from kohw
--	where cab in ( select cab from koplans where planid == 'plan1' )
--	order by cab, amps desc;


	select 'defrag_tocabs', date('now'), planid, cab2, item, amps, hostname, sn, hrctag, bluetag, ip from koplans
	order by planid, cab2;


--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
--	from kohw
--	where cab in ( select distinct( cab ) from koplans )
--	order by cab, amps desc;


--	where cab in ( select cab from koplans where planid == 'plan1' )