========================2018-10-16 11:41:10======================== noteurl_start parm_app_code = 046 parm_pc_name = KCG-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D304C7862A6138453 sCDKey = 348936551094 sName = KCG-PC ========================2018-10-16 11:41:10======================== 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 = '348936551094' AND r.app_code = '046' AND r.app_block = 0 ========================2018-10-16 11:41:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gyu1001' ========================2018-10-16 11:41:10======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304C7862A6138453' AND app_code = '046' ========================2018-10-16 11:41:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '209902' ========================2018-10-16 11:41:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '209902' ========================2018-10-16 11:41:10======================== UPDATE mac_detail SET pc_name = 'KCG-PC', os_type = '110', user_id = 'gyu1001', user_name = '창규식품[권창규]', screen_w = '1920', screen_h = '1080', cdkey = '348936551094' WHERE mac_idx = '209902' ========================2018-10-16 13:08:57======================== noteurl_start parm_app_code = 039 parm_pc_name = WIN7-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 1078D286A69EAA6068F2 sCDKey = 509636225935 sName = WIN7-PC ========================2018-10-16 13:08: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 = '509636225935' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-16 13:08:57======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mare0930' ========================2018-10-16 13:08:57======================== SELECT idx FROM macs WHERE mac_addr = '1078D286A69EAA6068F2' AND app_code = '039' ========================2018-10-16 13:08:57======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262472' ========================2018-10-16 13:08:57======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262472' ========================2018-10-16 13:08:57======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262472', '1078D286A69EAA6068F2', '039', 'WIN7-PC', '90', '1280', '1024', 'mare0930', '에드빅[조현석]', '509636225935' ) ========================2018-10-16 14:02:28======================== noteurl_start parm_app_code = 050 parm_pc_name = T2585 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001372A90E2F869F05E8 sCDKey = 171343494665 sName = T2585 ========================2018-10-16 14:02: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 = '171343494665' AND r.app_code = '050' AND r.app_block = 0 ========================2018-10-16 14:02:49======================== noteurl_start parm_app_code = 050 parm_pc_name = T2585 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001372A90E2F869F05E8 sCDKey = 171343494665 sName = T2585 ========================2018-10-16 14:02:49======================== 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 = '171343494665' AND r.app_code = '050' AND r.app_block = 0 ========================2018-10-16 14:03:14======================== noteurl_start parm_app_code = 050 parm_pc_name = T2585 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001372A90E2F869F05E8 sCDKey = 171343494665 sName = SUNINFRA ========================2018-10-16 14:03:14======================== 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 = '171343494665' AND r.app_code = '050' AND r.app_block = 0 ========================2018-10-16 14:05:37======================== noteurl_start parm_app_code = 050 parm_pc_name = T2585 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001372A90E2F869F05E8 sCDKey = 171343494665 sName = SUNINFRA ========================2018-10-16 14:05:37======================== 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 = '171343494665' AND r.app_code = '050' AND r.app_block = 0 ========================2018-10-16 14:05:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'suninfra' ========================2018-10-16 14:05:37======================== SELECT idx FROM macs WHERE mac_addr = '001372A90E2F869F05E8' AND app_code = '050' ========================2018-10-16 14:05:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262439' ========================2018-10-16 14:05:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262439' ========================2018-10-16 14:05:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262439', '001372A90E2F869F05E8', '050', 'SUNINFRA', '109', '1920', '1080', 'suninfra', '(주)선인프라[김의한]', '171343494665' ) ========================2018-10-16 14:05:44======================== noteurl_start parm_app_code = 050 parm_pc_name = T2585 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 001372A90E2F869F05E8 sCDKey = 171343494665 sName = SUNINFRA ========================2018-10-16 14:05:44======================== 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 = '171343494665' AND r.app_code = '050' AND r.app_block = 0 ========================2018-10-16 15:19:31======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = D0509966928BDE903C2C sCDKey = 827950362379 sName = USER-PC ========================2018-10-16 15:19:31======================== 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 = '827950362379' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-16 15:19:31======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dadada83' ========================2018-10-16 15:19:31======================== SELECT idx FROM macs WHERE mac_addr = 'D0509966928BDE903C2C' AND app_code = '039' ========================2018-10-16 15:19:31======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262488' ========================2018-10-16 15:19:31======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262488' ========================2018-10-16 15:19:31======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262488', 'D0509966928BDE903C2C', '039', 'USER-PC', '90', '1680', '1050', 'dadada83', '지우정밀[박근돈]', '827950362379' ) ========================2018-10-16 15:35:58======================== noteurl_start parm_app_code = 039 parm_pc_name = TBM parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55EC09322BA51431C sCDKey = 708322585128 sName = TBM ========================2018-10-16 15:35:58======================== 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 = '708322585128' AND r.app_code = '039' AND r.app_block = 0 ========================2018-10-16 15:35:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ramades77' ========================2018-10-16 15:35:58======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EC09322BA51431C' AND app_code = '039' ========================2018-10-16 15:35:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262494' ========================2018-10-16 15:35:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262494' ========================2018-10-16 15:35:58======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262494', 'E0D55EC09322BA51431C', '039', 'TBM', '90', '1920', '1080', 'ramades77', '(주)비엠아이[이동훈]', '708322585128' ) ========================2018-10-16 17:48:32======================== noteurl_start parm_app_code = 047 parm_pc_name = J-SERIES parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F4B5200246F0025E127F sCDKey = 265867566400 sName = J-SERIES ========================2018-10-16 17:48: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 = '265867566400' AND r.app_code = '047' AND r.app_block = 0 ========================2018-10-16 17:48:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'imggakjung' ========================2018-10-16 17:48:32======================== SELECT idx FROM macs WHERE mac_addr = 'F4B5200246F0025E127F' AND app_code = '047' ========================2018-10-16 17:48:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '262519' ========================2018-10-16 17:48:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '262519' ========================2018-10-16 17:48:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '262519', 'F4B5200246F0025E127F', '047', 'J-SERIES', '�쐢�룄�슦 7', '0', '0', 'imggakjung', '대한종합자재[김순자]', '265867566400' )