========================2018-02-07 09:15:24======================== 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 = D050990547C8C6B26CA3 sCDKey = 339466362279 sName = USER-PC ========================2018-02-07 09:15:24======================== 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 = '339466362279' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 09:15:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jn3124' ========================2018-02-07 09:15:24======================== SELECT idx FROM macs WHERE mac_addr = 'D050990547C8C6B26CA3' AND app_code = '039' ========================2018-02-07 09:15:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241574' ========================2018-02-07 09:15:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241574' ========================2018-02-07 09:15: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 ( '241574', 'D050990547C8C6B26CA3', '039', 'USER-PC', '90', '1920', '1080', 'jn3124', '영진수출포장[엄장영]', '339466362279' ) ========================2018-02-07 09:28:25======================== noteurl_start parm_app_code = 039 parm_pc_name = SYMETAL2 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002454FC93EABF214CF sCDKey = 964469015505 sName = SYMETAL2 ========================2018-02-07 09:28: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 = '964469015505' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 09:28:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'symetal' ========================2018-02-07 09:28:25======================== SELECT idx FROM macs WHERE mac_addr = '002454FC93EABF214CF' AND app_code = '039' ========================2018-02-07 09:28:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241581' ========================2018-02-07 09:28:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241581' ========================2018-02-07 09:28: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 ( '241581', '002454FC93EABF214CF', '039', 'SYMETAL2', '90', '1920', '1080', 'symetal', '서양금속[권용선]', '964469015505' ) ========================2018-02-07 10:02:35======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = EF ========================2018-02-07 10:02:35======================== 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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 10:02:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-07 10:02:35======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-07 10:02:35======================== 값이 없을 경우 ========================2018-02-07 10:02:46======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = 가온 ========================2018-02-07 10:02: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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 10:02:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-07 10:02:46======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-07 10:02:46======================== 값이 없을 경우 ========================2018-02-07 10:26:50======================== noteurl_start parm_app_code = 045 parm_pc_name = PRO-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 54BEF72687DB66FFB1CF sCDKey = 932847330830 sName = PRO-PC ========================2018-02-07 10:26:50======================== 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 = '932847330830' AND r.app_code = '045' AND r.app_block = 0 ========================2018-02-07 10:26:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chamnara' ========================2018-02-07 10:26:50======================== SELECT idx FROM macs WHERE mac_addr = '54BEF72687DB66FFB1CF' AND app_code = '045' ========================2018-02-07 10:26:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241592' ========================2018-02-07 10:26:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241592' ========================2018-02-07 10:26:50======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241592', '54BEF72687DB66FFB1CF', '045', 'PRO-PC', '90', '1920', '1080', 'chamnara', '(주)참나라 농업회사법인[임준상]', '932847330830' ) ========================2018-02-07 10:33:28======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-V8HEQLM parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 48BA4E61092E1E6A96EF sCDKey = 932847330830 sName = DESKTOP-V8HEQLM ========================2018-02-07 10:33:28======================== 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 = '932847330830' AND r.app_code = '045' AND r.app_block = 0 ========================2018-02-07 10:33:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'chamnara' ========================2018-02-07 10:33:28======================== SELECT idx FROM macs WHERE mac_addr = '48BA4E61092E1E6A96EF' AND app_code = '045' ========================2018-02-07 10:33:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241591' ========================2018-02-07 10:33:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241591' ========================2018-02-07 10:33:28======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241591', '48BA4E61092E1E6A96EF', '045', 'DESKTOP-V8HEQLM', '110', '1920', '1080', 'chamnara', '(주)참나라 농업회사법인[임준상]', '932847330830' ) ========================2018-02-07 11:13:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QRV28A9 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = B8AEEDA22A869E3A9020 sCDKey = 113495921266 sName = DESKTOP-QRV28A9 ========================2018-02-07 11:13:32======================== 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 = '113495921266' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 11:14:51======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-P0UOGK6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 94DE80BBF623542A6E12 sCDKey = 808917551076 sName = DESKTOP-P0UOGK6 ========================2018-02-07 11:14:51======================== 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 = '808917551076' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 11:15:26======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-P0UOGK6 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = 94DE80BBF623542A6E12 sCDKey = 808917551076 sName = DESKTOP-P0UOGK6 ========================2018-02-07 11:15:26======================== 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 = '808917551076' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 11:15:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'psh4788' ========================2018-02-07 11:15:26======================== SELECT idx FROM macs WHERE mac_addr = '94DE80BBF623542A6E12' AND app_code = '039' ========================2018-02-07 11:15:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241599' ========================2018-02-07 11:15:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241599' ========================2018-02-07 11:15:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241599', '94DE80BBF623542A6E12', '039', 'DESKTOP-P0UOGK6', '110', '1920', '1200', 'psh4788', '디자인휀스산업[박수희]', '808917551076' ) ========================2018-02-07 11:46:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-QRV28A9 parm_os_type = 110 parm_screen_w = 1200 parm_screen_h = 1200 parm_user_mac = B8AEEDA22A869E3A9020 sCDKey = 113495921266 sName = DESKTOP-QRV28A9 ========================2018-02-07 11:46:17======================== 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 = '113495921266' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 11:46:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daejinbt' ========================2018-02-07 11:46:17======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDA22A869E3A9020' AND app_code = '039' ========================2018-02-07 11:46:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241558' ========================2018-02-07 11:46:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241558' ========================2018-02-07 11:46:17======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241558', 'B8AEEDA22A869E3A9020', '039', 'DESKTOP-QRV28A9', '110', '1200', '1200', 'daejinbt', '대진상사[정순석]', '113495921266' ) ========================2018-02-07 11:50:16======================== noteurl_start parm_app_code = 046 parm_pc_name = SERVER parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = E0D55E5185F4102C15C2 sCDKey = 270789054722 sName = SERVER ========================2018-02-07 11:50:16======================== 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 = '270789054722' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 11:50:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'smh8910' ========================2018-02-07 11:50:16======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E5185F4102C15C2' AND app_code = '046' ========================2018-02-07 11:50:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '241612' ========================2018-02-07 11:50:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '241612' ========================2018-02-07 11:50:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '241612', 'E0D55E5185F4102C15C2', '046', 'SERVER', '90', '1680', '1050', 'smh8910', '덕성종합건재[송문호]', '270789054722' ) ========================2018-02-07 13:29:03======================== noteurl_start parm_app_code = 046 parm_pc_name = CEO parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = FCAA14AC4197ACE01D42 sCDKey = 270789054722 sName = CEO ========================2018-02-07 13:29:03======================== 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 = '270789054722' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 13:29:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'smh8910' ========================2018-02-07 13:29:03======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA14AC4197ACE01D42' AND app_code = '046' ========================2018-02-07 13:29:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '171448' ========================2018-02-07 13:29:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '171448' ========================2018-02-07 13:29:03======================== UPDATE mac_detail SET pc_name = 'CEO', os_type = '90', user_id = 'smh8910', user_name = '덕성종합건재[송문호]', screen_w = '1920', screen_h = '1080', cdkey = '270789054722' WHERE mac_idx = '171448' ========================2018-02-07 13:41:12======================== noteurl_start parm_app_code = 046 parm_pc_name = MSDN-Q6PQIGMIS0 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = B8AEEDAF696D102C15C2 sCDKey = 270789054722 sName = MSDN-Q6PQIGMIS0 ========================2018-02-07 13:41:12======================== 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 = '270789054722' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 13:41:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'smh8910' ========================2018-02-07 13:41:12======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDAF696D102C15C2' AND app_code = '046' ========================2018-02-07 13:41:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '237892' ========================2018-02-07 13:41:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '237892' ========================2018-02-07 13:41:12======================== UPDATE mac_detail SET pc_name = 'MSDN-Q6PQIGMIS0', os_type = '90', user_id = 'smh8910', user_name = '덕성종합건재[송문호]', screen_w = '1600', screen_h = '900', cdkey = '270789054722' WHERE mac_idx = '237892' ========================2018-02-07 14:23:57======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = 가온페인트 ========================2018-02-07 14:23: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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 14:23:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-07 14:23:57======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-07 14:23:57======================== 값이 없을 경우 ========================2018-02-07 14:24:05======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = 가온페인트 ========================2018-02-07 14:24:05======================== 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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 14:24:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-07 14:24:05======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-07 14:24:05======================== 값이 없을 경우 ========================2018-02-07 14:33:55======================== noteurl_start parm_app_code = 046 parm_pc_name = EF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 309C238018CB46208190 sCDKey = 826623775319 sName = 가온페인트 ========================2018-02-07 14:33:55======================== 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 = '826623775319' AND r.app_code = '046' AND r.app_block = 0 ========================2018-02-07 14:33:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gaonpaint' ========================2018-02-07 14:33:55======================== SELECT idx FROM macs WHERE mac_addr = '309C238018CB46208190' AND app_code = '046' ========================2018-02-07 14:33:55======================== 값이 없을 경우 ========================2018-02-07 19:29:09======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-24J4LKK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23674C180766F2 sCDKey = 602057279640 sName = DESKTOP-24J4LKK ========================2018-02-07 19:29: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 = '602057279640' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 19:31:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-24J4LKK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23674C180766F2 sCDKey = 602057279640 sName = 90FBA6218262 ========================2018-02-07 19:31: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 = '602057279640' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 19:33:42======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-24J4LKK parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23674C180766F2 sCDKey = 602057279640 sName = DESKTOP-24J4LKK ========================2018-02-07 19:33:42======================== 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 = '602057279640' AND r.app_code = '039' AND r.app_block = 0 ========================2018-02-07 19:33:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rlaekfn' ========================2018-02-07 19:33:42======================== SELECT idx FROM macs WHERE mac_addr = '7085C23674C180766F2' AND app_code = '039' ========================2018-02-07 19:33:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '228386' ========================2018-02-07 19:33:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '228386' ========================2018-02-07 19:33:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '228386', '7085C23674C180766F2', '039', 'DESKTOP-24J4LKK', '110', '1920', '1080', 'rlaekfn', '다루식품[김다루]', '602057279640' )