========================2020-03-20 08:09:21======================== noteurl_start parm_app_code = 050 parm_pc_name = HD2016053061S parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6002921D3548140AE51B sCDKey = 639449125243 sName = sfasemicon ========================2020-03-20 08:09:21======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '639449125243' AND r.app_code = '050' AND r.app_block = 0 ========================2020-03-20 08:09:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sfasemicon' ========================2020-03-20 08:09:21======================== SELECT idx FROM macs WHERE mac_addr = '6002921D3548140AE51B' AND app_code = '050' ========================2020-03-20 08:09:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313179' ========================2020-03-20 08:09:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313179' ========================2020-03-20 08:09:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313179', '6002921D3548140AE51B', '050', 'sfasemicon', '109', '1920', '1080', 'sfasemicon', '(주)에스에프에이반도체[김성민]', '639449125243' ) ========================2020-03-20 11:56:57======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-UU79AI9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14C913F9AF61C0A78CED sCDKey = 682778728524 sName = DESKTOP-UU79AI9 ========================2020-03-20 11:56:57======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '682778728524' AND r.app_code = '046' AND r.app_block = 0 ========================2020-03-20 11:56:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'n1001x' ========================2020-03-20 11:56:57======================== SELECT idx FROM macs WHERE mac_addr = '14C913F9AF61C0A78CED' AND app_code = '046' ========================2020-03-20 11:56:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '254460' ========================2020-03-20 11:56:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '254460' ========================2020-03-20 11:56:57======================== UPDATE mac_detail SET pc_name = 'DESKTOP-UU79AI9', os_type = '110', user_id = 'n1001x', user_name = '중앙철물건재상사[이용식]', screen_w = '1920', screen_h = '1080', cdkey = '682778728524' WHERE mac_idx = '254460' ========================2020-03-20 14:33:46======================== noteurl_start parm_app_code = 039 parm_pc_name = 사용자 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 002454928B68766684DD sCDKey = 302068335544 sName = 사용자 ========================2020-03-20 14:33:46======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '302068335544' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-20 14:33:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mbinc' ========================2020-03-20 14:33:46======================== SELECT idx FROM macs WHERE mac_addr = '002454928B68766684DD' AND app_code = '039' ========================2020-03-20 14:33:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '312177' ========================2020-03-20 14:33:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '312177' ========================2020-03-20 14:33:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '312177', '002454928B68766684DD', '039', '사용자', '110', '1600', '900', 'mbinc', 'M.B 산업[조미정]', '302068335544' ) ========================2020-03-20 16:05:25======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CCC6A47A170749A6150 sCDKey = 078721735716 sName = USER-PC ========================2020-03-20 16:05:25======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '078721735716' AND r.app_code = '039' AND r.app_block = 0 ========================2020-03-20 16:05:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'pkj790517' ========================2020-03-20 16:05:25======================== SELECT idx FROM macs WHERE mac_addr = '4CCC6A47A170749A6150' AND app_code = '039' ========================2020-03-20 16:05:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '204644' ========================2020-03-20 16:05:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '204644' ========================2020-03-20 16:05:25======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'pkj790517', user_name = '터미널세차장[박광준]', screen_w = '1920', screen_h = '1080', cdkey = '078721735716' WHERE mac_idx = '204644' ========================2020-03-20 17:49:13======================== noteurl_start parm_app_code = 047 parm_pc_name = BERICHE_POS-PC parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D300603F09EFE2E07 sCDKey = 406364078068 sName = BERICHE_POS-PC ========================2020-03-20 17:49:13======================== SELECT r.license_pc, r.user_id, count(d.cdkey) AS cdnum FROM regist_user r LEFT JOIN mac_detail d ON r.cdkey = d.cdkey WHERE r.cdkey = '406364078068' AND r.app_code = '047' AND r.app_block = 0 ========================2020-03-20 17:49:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'beriche' ========================2020-03-20 17:49:13======================== SELECT idx FROM macs WHERE mac_addr = 'F44D300603F09EFE2E07' AND app_code = '047' ========================2020-03-20 17:49:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313481' ========================2020-03-20 17:49:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313481' ========================2020-03-20 17:49:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '313481', 'F44D300603F09EFE2E07', '047', 'BERICHE_POS-PC', '�쐢�룄�슦 10', '0', '0', 'beriche', '제이엠인터네셔널[배광혜]', '406364078068' )