========================2019-07-08 10:56:07======================== noteurl_start parm_app_code = 039 parm_pc_name = MAIN parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = E0D55EECB004B0C91678 sCDKey = 132056757826 sName = MAIN ========================2019-07-08 10:56: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 = '132056757826' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-08 10:56:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'uniongas' ========================2019-07-08 10:56:07======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55EECB004B0C91678' AND app_code = '039' ========================2019-07-08 10:56:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290251' ========================2019-07-08 10:56:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290251' ========================2019-07-08 10:56:07======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290251', 'E0D55EECB004B0C91678', '039', 'MAIN', '90', '1280', '1024', 'uniongas', '유니온가스상사[김관덕]', '132056757826' ) ========================2019-07-08 11:17:48======================== 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 = 9C5C8EC165F678BA3DA8 sCDKey = 108094650671 sName = USER-PC ========================2019-07-08 11:17:48======================== 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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-08 11:17:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2019-07-08 11:17:48======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8EC165F678BA3DA8' AND app_code = '046' ========================2019-07-08 11:17:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290257' ========================2019-07-08 11:17:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290257' ========================2019-07-08 11:17:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290257', '9C5C8EC165F678BA3DA8', '046', 'USER-PC', '90', '1024', '768', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2019-07-08 11:21:28======================== noteurl_start parm_app_code = 050 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A4914F48463 sCDKey = 851095746023 sName = SEOWL17H15185 ========================2019-07-08 11:21: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 = '851095746023' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-08 11:23:22======================== noteurl_start parm_app_code = 050 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A4914F48463 sCDKey = 851095746023 sName = SEOWL17H15185 ========================2019-07-08 11:23:22======================== 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 = '851095746023' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-08 11:23:50======================== noteurl_start parm_app_code = 050 parm_pc_name = SEOWL17H15185 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4258B944A4914F48463 sCDKey = 851095746023 sName = SEOWL17H15185 ========================2019-07-08 11:23: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 = '851095746023' AND r.app_code = '050' AND r.app_block = 0 ========================2019-07-08 11:33:02======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 7085C233855778BA3DA8 sCDKey = 108094650671 sName = USER-PC ========================2019-07-08 11:33:02======================== 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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-08 11:33:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2019-07-08 11:33:02======================== SELECT idx FROM macs WHERE mac_addr = '7085C233855778BA3DA8' AND app_code = '046' ========================2019-07-08 11:33:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290153' ========================2019-07-08 11:33:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290153' ========================2019-07-08 11:33:02======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290153', '7085C233855778BA3DA8', '046', 'USER-PC', '90', '1280', '1024', 'a09sang', '(주)거상[장동익]', '108094650671' ) ========================2019-07-08 11:50:58======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-EST2OCV parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B42E994CC3DF503D49D0 sCDKey = 872038080551 sName = DESKTOP-EST2OCV ========================2019-07-08 11:50: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 = '872038080551' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-08 11:50:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kyr5228' ========================2019-07-08 11:50:58======================== SELECT idx FROM macs WHERE mac_addr = 'B42E994CC3DF503D49D0' AND app_code = '047' ========================2019-07-08 11:50:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290267' ========================2019-07-08 11:50:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290267' ========================2019-07-08 11:50: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 ( '290267', 'B42E994CC3DF503D49D0', '047', 'DESKTOP-EST2OCV', '�쐢�룄�슦 10', '0', '0', 'kyr5228', '소리종합주방물류[홍성예]', '872038080551' ) ========================2019-07-08 13:11:56======================== noteurl_start parm_app_code = 039 parm_pc_name = XP-201309021136 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00245432F86840E64F2 sCDKey = 563097943389 sName = XP-201309021136 ========================2019-07-08 13:11: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 = '563097943389' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-08 13:13:25======================== noteurl_start parm_app_code = 039 parm_pc_name = XP-201309021136 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00245432F86840E64F2 sCDKey = 563097943389 sName = XP-201309021136 ========================2019-07-08 13:13: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 = '563097943389' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-08 13:13:25======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhfutkdghl' ========================2019-07-08 13:13:25======================== SELECT idx FROM macs WHERE mac_addr = '00245432F86840E64F2' AND app_code = '039' ========================2019-07-08 13:13:25======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '94103' ========================2019-07-08 13:13:25======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '94103' ========================2019-07-08 13:13:25======================== UPDATE mac_detail SET pc_name = 'XP-201309021136', os_type = '64', user_id = 'rhfutkdghl', user_name = '고려상회[류승철]', screen_w = '1024', screen_h = '768', cdkey = '563097943389' WHERE mac_idx = '94103' ========================2019-07-08 13:13:38======================== noteurl_start parm_app_code = 039 parm_pc_name = XP-201309021136 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00245432F86840E64F2 sCDKey = 563097943389 sName = XP-201309021136 ========================2019-07-08 13:13:38======================== 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 = '563097943389' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-08 13:14:53======================== noteurl_start parm_app_code = 039 parm_pc_name = XP-201309021136 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00245432F86840E64F2 sCDKey = 563097943389 sName = 고려상회 ========================2019-07-08 13: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 = '563097943389' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-08 13:14:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhfutkdghl' ========================2019-07-08 13:14:53======================== SELECT idx FROM macs WHERE mac_addr = '00245432F86840E64F2' AND app_code = '039' ========================2019-07-08 13:14:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '94103' ========================2019-07-08 13:14:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '94103' ========================2019-07-08 13:14:53======================== UPDATE mac_detail SET pc_name = '고려상회', os_type = '64', user_id = 'rhfutkdghl', user_name = '고려상회[류승철]', screen_w = '1024', screen_h = '768', cdkey = '563097943389' WHERE mac_idx = '94103' ========================2019-07-08 13:17:50======================== noteurl_start parm_app_code = 039 parm_pc_name = XP-201309021136 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00245432F86840E64F2 sCDKey = 563097943389 sName = XP-201309021136 ========================2019-07-08 13:17: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 = '563097943389' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-08 13:17:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'rhfutkdghl' ========================2019-07-08 13:17:50======================== SELECT idx FROM macs WHERE mac_addr = '00245432F86840E64F2' AND app_code = '039' ========================2019-07-08 13:17:50======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '94103' ========================2019-07-08 13:17:50======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '94103' ========================2019-07-08 13:17:50======================== UPDATE mac_detail SET pc_name = 'XP-201309021136', os_type = '64', user_id = 'rhfutkdghl', user_name = '고려상회[류승철]', screen_w = '1024', screen_h = '768', cdkey = '563097943389' WHERE mac_idx = '94103' ========================2019-07-08 15:36:04======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 1831BF07A24C8C97F21C sCDKey = 315435650547 sName = DESKTOP ========================2019-07-08 15:36: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 = '315435650547' AND r.app_code = '047' AND r.app_block = 0 ========================2019-07-08 15:36:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sewonmusic' ========================2019-07-08 15:36:04======================== SELECT idx FROM macs WHERE mac_addr = '1831BF07A24C8C97F21C' AND app_code = '047' ========================2019-07-08 15:36:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284853' ========================2019-07-08 15:36:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '284853' ========================2019-07-08 15:36:04======================== UPDATE mac_detail SET pc_name = 'DESKTOP', os_type = '�쐢�룄�슦 10', user_id = 'sewonmusic', user_name = '세원뮤직[장세원]', screen_w = '0', screen_h = '0', cdkey = '315435650547' WHERE mac_idx = '284853' ========================2019-07-08 16:05:06======================== noteurl_start parm_app_code = 046 parm_pc_name = 오상목 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 406186CB48649E1B94C9 sCDKey = 573193639572 sName = 오상목 ========================2019-07-08 16:05:06======================== 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 = '573193639572' AND r.app_code = '046' AND r.app_block = 0 ========================2019-07-08 16:05:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2019-07-08 16:05:06======================== SELECT idx FROM macs WHERE mac_addr = '406186CB48649E1B94C9' AND app_code = '046' ========================2019-07-08 16:05:06======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '227599' ========================2019-07-08 16:05:06======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '227599' ========================2019-07-08 16:05:06======================== UPDATE mac_detail SET pc_name = '오상목', os_type = '110', user_id = 'adam5352', user_name = '오상목해피아울렛농업회사법인(주)[해피아울렛농업회사법인(주)]테스트[오상목해피아울렛농업회사법인(주)[해피]', screen_w = '1920', screen_h = '1080', cdkey = '573193639572' WHERE mac_idx = '227599' ========================2019-07-08 16:08:39======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-BSRTP8I parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0D32C68C20DD70B5 sCDKey = 363825187337 sName = DESKTOP-BSRTP8I ========================2019-07-08 16:08:39======================== 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 = '363825187337' AND r.app_code = '039' AND r.app_block = 0 ========================2019-07-08 16:08:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kwonmo53' ========================2019-07-08 16:08:39======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0D32C68C20DD70B5' AND app_code = '039' ========================2019-07-08 16:08:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '290307' ========================2019-07-08 16:08:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '290307' ========================2019-07-08 16:08:39======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '290307', '1C1B0D32C68C20DD70B5', '039', 'DESKTOP-BSRTP8I', '110', '1920', '1080', 'kwonmo53', '대성판금[권만오]', '363825187337' )