========================2019-05-13 09:02:03======================== noteurl_start parm_app_code = 039 parm_pc_name = JN23672-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002454FCDCB2D814EF2D sCDKey = 888849377565 sName = JN23672-PC ========================2019-05-13 09:02: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 = '888849377565' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-13 09:02:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jn23672' ========================2019-05-13 09:02:03======================== SELECT idx FROM macs WHERE mac_addr = '002454FCDCB2D814EF2D' AND app_code = '039' ========================2019-05-13 09:02:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285650' ========================2019-05-13 09:02:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285650' ========================2019-05-13 09:02:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '285650', '002454FCDCB2D814EF2D', '039', 'JN23672-PC', '110', '1920', '1080', 'jn23672', '전남사무기[박성일]', '888849377565' ) ========================2019-05-13 09:06:00======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VO5UABL parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 98838917548CEA99FC33 sCDKey = 827754547202 sName = DESKTOP-VO5UABL ========================2019-05-13 09:06: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 = '827754547202' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-13 09:06:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jhw600' ========================2019-05-13 09:06:00======================== SELECT idx FROM macs WHERE mac_addr = '98838917548CEA99FC33' AND app_code = '039' ========================2019-05-13 09:06:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '227081' ========================2019-05-13 09:06:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '227081' ========================2019-05-13 09:06:00======================== UPDATE mac_detail SET pc_name = 'DESKTOP-VO5UABL', os_type = '110', user_id = 'jhw600', user_name = '서진안전[장호원]', screen_w = '1366', screen_h = '768', cdkey = '827754547202' WHERE mac_idx = '227081' ========================2019-05-13 11:33:22======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-0KJP1D4 parm_os_type = 110 parm_screen_w = 1680 parm_screen_h = 1050 parm_user_mac = 00D86155575088DD22B2 sCDKey = 982834938334 sName = DESKTOP-0KJP1D4 ========================2019-05-13 11:33: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 = '982834938334' AND r.app_code = '039' AND r.app_block = 0 ========================2019-05-13 11:33:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jurapower11' ========================2019-05-13 11:33:22======================== SELECT idx FROM macs WHERE mac_addr = '00D86155575088DD22B2' AND app_code = '039' ========================2019-05-13 11:33:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '285750' ========================2019-05-13 11:33:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '285750' ========================2019-05-13 11:33:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '285750', '00D86155575088DD22B2', '039', 'DESKTOP-0KJP1D4', '110', '1680', '1050', 'jurapower11', '멋지다오피스텔[장승목]', '982834938334' ) ========================2019-05-13 12:49:17======================== 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 = 50AF73276DB9A41C65F sCDKey = 834962125925 sName = 김대중 테스트 ========================2019-05-13 12:49: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 = '834962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-05-13 12:49:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-05-13 12:49:17======================== SELECT idx FROM macs WHERE mac_addr = '50AF73276DB9A41C65F' AND app_code = '046' ========================2019-05-13 12:49:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280226' ========================2019-05-13 12:49:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280226' ========================2019-05-13 12:49:17======================== UPDATE mac_detail SET pc_name = '김대중 테스트', os_type = '90', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '280226' ========================2019-05-13 14:37:30======================== 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 = 50AF73276DB9A41C65F sCDKey = 034962125925 sName = 김대중 ========================2019-05-13 14:37:30======================== 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 = '034962125925' AND r.app_code = '046' AND r.app_block = 0 ========================2019-05-13 14:37:43======================== 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 = 50AF73276DB9A41C65F sCDKey = 834962125925 sName = 김대중 ========================2019-05-13 14:37:43======================== 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 ========================2019-05-13 14:37:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ericaan' ========================2019-05-13 14:37:43======================== SELECT idx FROM macs WHERE mac_addr = '50AF73276DB9A41C65F' AND app_code = '046' ========================2019-05-13 14:37:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '280226' ========================2019-05-13 14:37:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '280226' ========================2019-05-13 14:37:43======================== UPDATE mac_detail SET pc_name = '김대중', os_type = '90', user_id = 'ericaan', user_name = '주식회사 메종드파리[안진현]', screen_w = '1024', screen_h = '768', cdkey = '834962125925' WHERE mac_idx = '280226'