========================2018-11-19 09:52:15======================== noteurl_start parm_app_code = 039 parm_pc_name = 대표님 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00012E4991D148A66C77 sCDKey = 236242212658 sName = 대표님 ========================2018-11-19 09:52:15======================== 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 = '236242212658' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-19 09:52:15======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'scw780529' ========================2018-11-19 09:52:15======================== SELECT idx FROM macs WHERE mac_addr = '00012E4991D148A66C77' AND app_code = '039' ========================2018-11-19 09:52:15======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '73248' ========================2018-11-19 09:52:15======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '73248' ========================2018-11-19 09:52:15======================== UPDATE mac_detail SET pc_name = '대표님', os_type = '90', user_id = 'scw780529', user_name = '코라[성창욱]', screen_w = '1920', screen_h = '1080', cdkey = '236242212658' WHERE mac_idx = '73248' ========================2018-11-19 09:52:19======================== noteurl_start parm_app_code = 039 parm_pc_name = 대표님 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 00012E4991D148A66C77 sCDKey = 236242212658 sName = 대표님 ========================2018-11-19 09:52:19======================== 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 = '236242212658' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-19 09:52:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'scw780529' ========================2018-11-19 09:52:19======================== SELECT idx FROM macs WHERE mac_addr = '00012E4991D148A66C77' AND app_code = '039' ========================2018-11-19 09:52:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '73248' ========================2018-11-19 09:52:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '73248' ========================2018-11-19 09:52:19======================== UPDATE mac_detail SET pc_name = '대표님', os_type = '90', user_id = 'scw780529', user_name = '코라[성창욱]', screen_w = '1920', screen_h = '1080', cdkey = '236242212658' WHERE mac_idx = '73248' ========================2018-11-19 10:55:25======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4F1CCDC32EA751E sCDKey = 834962125925 sName = USER-PC ========================2018-11-19 10:55: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-19 10:55:59======================== noteurl_start parm_app_code = 046 parm_pc_name = SJ-20141219NCCE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0AA05640CBE2CA sCDKey = 834962125925 sName = SJ-20141219NCCE ========================2018-11-19 10:55:59======================== 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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-19 11:02:09======================== noteurl_start parm_app_code = 046 parm_pc_name = SJ-20141219NCCE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0AA05640CBE2CA sCDKey = 834962125925 sName = 쇼룸1층 ========================2018-11-19 11:02: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-19 11:02:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2018-11-19 11:02:09======================== SELECT idx FROM macs WHERE mac_addr = '00190F0AA05640CBE2CA' AND app_code = '046' ========================2018-11-19 11:02:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268192' ========================2018-11-19 11:02:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268192' ========================2018-11-19 11:02:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268192', '00190F0AA05640CBE2CA', '046', '쇼룸1층', '64', '1024', '768', 'ericaan', '주식회사 메종드파리[안진현]', '834962125925' ) ========================2018-11-19 11:02:29======================== noteurl_start parm_app_code = 046 parm_pc_name = SJ-20141219NCCE parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 00190F0AA05640CBE2CA sCDKey = 834962125925 sName = 쇼룸1층 ========================2018-11-19 11:02: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-19 11:02:29======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2018-11-19 11:02:29======================== SELECT idx FROM macs WHERE mac_addr = '00190F0AA05640CBE2CA' AND app_code = '046' ========================2018-11-19 11:02:29======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268192' ========================2018-11-19 11:02:29======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268192' ========================2018-11-19 11:02:29======================== UPDATE mac_detail SET pc_name = '쇼룸1층', os_type = '64', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '268192' ========================2018-11-19 11:05:11======================== noteurl_start parm_app_code = 047 parm_pc_name = USERPC05 parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 9C5C8E8731CDA2DBBB95 sCDKey = 435511149259 sName = USERPC05 ========================2018-11-19 11:05:11======================== 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 = '435511149259' AND r.app_code = '047' AND r.app_block = 0 ========================2018-11-19 11:05:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'didtkrl' ========================2018-11-19 11:05:11======================== SELECT idx FROM macs WHERE mac_addr = '9C5C8E8731CDA2DBBB95' AND app_code = '047' ========================2018-11-19 11:05:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '235345' ========================2018-11-19 11:05:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '235345' ========================2018-11-19 11:05:11======================== UPDATE mac_detail SET pc_name = 'USERPC05', os_type = '�쐢�룄�슦 7', user_id = 'didtkrl', user_name = '기룡스포츠[양기룡]', screen_w = '0', screen_h = '0', cdkey = '435511149259' WHERE mac_idx = '235345' ========================2018-11-19 11:10:53======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23111599EA2DEFA sCDKey = 834962125925 sName = USER-PC ========================2018-11-19 11:10: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-19 11:10:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2018-11-19 11:10:53======================== SELECT idx FROM macs WHERE mac_addr = '7085C23111599EA2DEFA' AND app_code = '046' ========================2018-11-19 11:10:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267799' ========================2018-11-19 11:10:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267799' ========================2018-11-19 11:10:53======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1920', screen_h = '1080', cdkey = '834962125925' WHERE mac_idx = '267799' ========================2018-11-19 11:16:39======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C23111599EA2DEFA sCDKey = 834962125925 sName = 김미복(경리) ========================2018-11-19 11:16: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-19 11:16:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2018-11-19 11:16:39======================== SELECT idx FROM macs WHERE mac_addr = '7085C23111599EA2DEFA' AND app_code = '046' ========================2018-11-19 11:16:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '267799' ========================2018-11-19 11:16:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '267799' ========================2018-11-19 11:16:39======================== UPDATE mac_detail SET pc_name = '김미복(경리)', os_type = '90', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1920', screen_h = '1080', cdkey = '834962125925' WHERE mac_idx = '267799' ========================2018-11-19 13:11:12======================== 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 = 24F5AAE569344AADF65F sCDKey = 206990337769 sName = USER-PC ========================2018-11-19 13:11: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 = '206990337769' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-19 13:11:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'idosid' ========================2018-11-19 13:11:12======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE569344AADF65F' AND app_code = '039' ========================2018-11-19 13:11:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '178440' ========================2018-11-19 13:11:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '178440' ========================2018-11-19 13:11:12======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'idosid', user_name = '대경 콘베어[손문의]', screen_w = '1920', screen_h = '1080', cdkey = '206990337769' WHERE mac_idx = '178440' ========================2018-11-19 14:08:17======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-I5N0B85 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFB7487C0144D36FA sCDKey = 427808194172 sName = DESKTOP-I5N0B85 ========================2018-11-19 14:08: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 = '427808194172' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-19 14:08:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'JMJ9885' ========================2018-11-19 14:08:17======================== SELECT idx FROM macs WHERE mac_addr = '4CEDFB7487C0144D36FA' AND app_code = '039' ========================2018-11-19 14:08:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268219' ========================2018-11-19 14:08:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268219' ========================2018-11-19 14:08: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 ( '268219', '4CEDFB7487C0144D36FA', '039', 'DESKTOP-I5N0B85', '110', '1920', '1080', 'JMJ9885', '(주)진접골재산업[현수정]', '427808194172' ) ========================2018-11-19 16:39:37======================== noteurl_start parm_app_code = 039 parm_pc_name = KANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DB931882EBC7890 sCDKey = 720357298336 sName = KANG ========================2018-11-19 16:39: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 = '720357298336' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-19 16:39:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'almoco7844' ========================2018-11-19 16:39:37======================== SELECT idx FROM macs WHERE mac_addr = '1C1B0DB931882EBC7890' AND app_code = '039' ========================2018-11-19 16:39:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '221644' ========================2018-11-19 16:39:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '221644' ========================2018-11-19 16:39:37======================== UPDATE mac_detail SET pc_name = 'KANG', os_type = '110', user_id = 'almoco7844', user_name = '(주)알모코[배한숙]', screen_w = '1920', screen_h = '1080', cdkey = '720357298336' WHERE mac_idx = '221644' ========================2018-11-19 16:39:44======================== noteurl_start parm_app_code = 039 parm_pc_name = KANG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1C1B0DB931882EBC7890 sCDKey = 720357298336 sName = KANG ========================2018-11-19 16:39: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 = '720357298336' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-19 17:36:08======================== noteurl_start parm_app_code = 048 parm_pc_name = IMHG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 210604963618 sName = IMHG ========================2018-11-19 17:36: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 = '210604963618' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-19 17:36:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhg88' ========================2018-11-19 17:36:08======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '048' ========================2018-11-19 17:36:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239172' ========================2018-11-19 17:36:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239172' ========================2018-11-19 17:36:08======================== UPDATE mac_detail SET pc_name = 'IMHG', os_type = '�쐢�룄�슦 10', user_id = 'lhg88', user_name = '엠제이소프트[임현규]', screen_w = '0', screen_h = '0', cdkey = '210604963618' WHERE mac_idx = '239172' ========================2018-11-19 17:36:12======================== noteurl_start parm_app_code = 048 parm_pc_name = IMHG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 210604963618 sName = IMHG ========================2018-11-19 17:36: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 = '210604963618' AND r.app_code = '048' AND r.app_block = 0 ========================2018-11-19 17:36:12======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'lhg88' ========================2018-11-19 17:36:12======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '048' ========================2018-11-19 17:36:12======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239172' ========================2018-11-19 17:36:12======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239172' ========================2018-11-19 17:36:12======================== UPDATE mac_detail SET pc_name = 'IMHG', os_type = '�쐢�룄�슦 10', user_id = 'lhg88', user_name = '엠제이소프트[임현규]', screen_w = '0', screen_h = '0', cdkey = '210604963618' WHERE mac_idx = '239172'