========================2019-03-19 09:07:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-J1M27DN parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 00D8612DAA1E86BFB39C sCDKey = 762938924530 sName = DESKTOP-J1M27DN ========================2019-03-19 09:07:08======================== 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 = '762938924530' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 09:07:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'youngam' ========================2019-03-19 09:07:08======================== SELECT idx FROM macs WHERE mac_addr = '00D8612DAA1E86BFB39C' AND app_code = '039' ========================2019-03-19 09:07:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280773' ========================2019-03-19 09:07:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280773' ========================2019-03-19 09:07:08======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '280773', '00D8612DAA1E86BFB39C', '039', 'DESKTOP-J1M27DN', '110', '1536', '864', 'youngam', '영암상회[황미경]', '762938924530' ) ========================2019-03-19 11:14:53======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-T9VJOTGC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 988389357558C2935A58 sCDKey = 903583545456 sName = LAPTOP-T9VJOTGC ========================2019-03-19 11:14:53======================== 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 = '903583545456' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 11:14:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyj418' ========================2019-03-19 11:14:53======================== SELECT idx FROM macs WHERE mac_addr = '988389357558C2935A58' AND app_code = '039' ========================2019-03-19 11:14:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '210519' ========================2019-03-19 11:14:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '210519' ========================2019-03-19 11:14:53======================== UPDATE mac_detail SET pc_name = 'LAPTOP-T9VJOTGC', os_type = '110', user_id = 'kyj418', user_name = '미양수산[김영진]', screen_w = '1366', screen_h = '768', cdkey = '903583545456' WHERE mac_idx = '210519' ========================2019-03-19 11:15:09======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-T9VJOTGC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 988389357558C2935A58 sCDKey = 903583545456 sName = LAPTOP-T9VJOTGC ========================2019-03-19 11:15:09======================== 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 = '903583545456' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 12:26:00======================== noteurl_start parm_app_code = 048 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미1 ========================2019-03-19 12:26:00======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-19 12:26:07======================== noteurl_start parm_app_code = 048 parm_pc_name = 강정미1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 24F5AAEB832C5262F991 sCDKey = 434133617514 sName = 강정미1 ========================2019-03-19 12:26:07======================== 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 = '434133617514' AND r.app_code = '048' AND r.app_block = 0 ========================2019-03-19 15:12:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:12:18======================== 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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:12:25======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:12: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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:12:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gstworld' ========================2019-03-19 15:12:25======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5AF68C96CFBFF1D' AND app_code = '039' ========================2019-03-19 15:12:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280827' ========================2019-03-19 15:12:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280827' ========================2019-03-19 15:12:25======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '280827', 'C03FD5AF68C96CFBFF1D', '039', 'DESKTOP-CTRR4SI', '110', '1920', '1080', 'gstworld', '(유)한미비철금속[조병권]', '420544131609' ) ========================2019-03-19 15:12:29======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:12:29======================== 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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:12:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:12: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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:12:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:12:52======================== 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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:12:54======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:12:54======================== 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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:12:56======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:12:56======================== 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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:13:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-CTRR4SI parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5AF68C96CFBFF1D sCDKey = 420544131609 sName = DESKTOP-CTRR4SI ========================2019-03-19 15:13:04======================== 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 = '420544131609' AND r.app_code = '039' AND r.app_block = 0 ========================2019-03-19 15:22:53======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = DCFE07541BA7A41C65F sCDKey = 545468317343 sName = USER-PC ========================2019-03-19 15:22:53======================== 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 = '545468317343' AND r.app_code = '046' AND r.app_block = 0 ========================2019-03-19 15:22:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bch6332' ========================2019-03-19 15:22:53======================== SELECT idx FROM macs WHERE mac_addr = 'DCFE07541BA7A41C65F' AND app_code = '046' ========================2019-03-19 15:22:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280830' ========================2019-03-19 15:22:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280830' ========================2019-03-19 15:22:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '280830', 'DCFE07541BA7A41C65F', '046', 'USER-PC', '90', '1024', '768', 'bch6332', '(주)오피스하모니정촌점[배철환]', '545468317343' )