========================2018-01-11 09:09:49======================== noteurl_start parm_app_code = 039 parm_pc_name = User -501141934 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 902B341D97FEEE1BAE66 sCDKey = 035793154481 sName = User -501141934 ========================2018-01-11 09:09: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 = '035793154481' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 09:09:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sungwoo' ========================2018-01-11 09:09:49======================== SELECT idx FROM macs WHERE mac_addr = '902B341D97FEEE1BAE66' AND app_code = '039' ========================2018-01-11 09:09:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238948' ========================2018-01-11 09:09:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238948' ========================2018-01-11 09:09:49======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238948', '902B341D97FEEE1BAE66', '039', 'User -501141934', '90', '1920', '1080', 'sungwoo', '성우인력개발[성우인력]', '035793154481' ) ========================2018-01-11 09:13:20======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 54880E7FF19C2C42D083 sCDKey = 291728851301 sName = USER-PC ========================2018-01-11 09:13:20======================== 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 = '291728851301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 09:13:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anayamy0418' ========================2018-01-11 09:13:20======================== SELECT idx FROM macs WHERE mac_addr = '54880E7FF19C2C42D083' AND app_code = '039' ========================2018-01-11 09:13:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '202597' ========================2018-01-11 09:13:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '202597' ========================2018-01-11 09:13:20======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'anayamy0418', user_name = '주식회사 에센스[황명하]', screen_w = '1366', screen_h = '768', cdkey = '291728851301' WHERE mac_idx = '202597' ========================2018-01-11 09:13:26======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 54880E7FF19C2C42D083 sCDKey = 291728851301 sName = USER-PC ========================2018-01-11 09:13: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 = '291728851301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 09:13:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anayamy0418' ========================2018-01-11 09:13:26======================== SELECT idx FROM macs WHERE mac_addr = '54880E7FF19C2C42D083' AND app_code = '039' ========================2018-01-11 09:13:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '202597' ========================2018-01-11 09:13:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '202597' ========================2018-01-11 09:13:26======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'anayamy0418', user_name = '주식회사 에센스[황명하]', screen_w = '1366', screen_h = '768', cdkey = '291728851301' WHERE mac_idx = '202597' ========================2018-01-11 09:13:54======================== noteurl_start parm_app_code = 039 parm_pc_name = REI-PC parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = ACB57D2B58AFC1049DB sCDKey = 291728851301 sName = REI-PC ========================2018-01-11 09:13:54======================== 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 = '291728851301' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 09:13:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'anayamy0418' ========================2018-01-11 09:13:54======================== SELECT idx FROM macs WHERE mac_addr = 'ACB57D2B58AFC1049DB' AND app_code = '039' ========================2018-01-11 09:13:54======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '177972' ========================2018-01-11 09:13:54======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '177972' ========================2018-01-11 09:13:54======================== UPDATE mac_detail SET pc_name = 'REI-PC', os_type = '90', user_id = 'anayamy0418', user_name = '주식회사 에센스[황명하]', screen_w = '1366', screen_h = '768', cdkey = '291728851301' WHERE mac_idx = '177972' ========================2018-01-11 09:35:39======================== noteurl_start parm_app_code = 039 parm_pc_name = HOME-20171023EJ parm_os_type = 90 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = E0CA941B49A680D185E5 sCDKey = 397077679605 sName = HOME-20171023EJ ========================2018-01-11 09:35: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 = '397077679605' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 09:35:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dog7003' ========================2018-01-11 09:35:39======================== SELECT idx FROM macs WHERE mac_addr = 'E0CA941B49A680D185E5' AND app_code = '039' ========================2018-01-11 09:35:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238647' ========================2018-01-11 09:35:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238647' ========================2018-01-11 09:35: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 ( '238647', 'E0CA941B49A680D185E5', '039', 'HOME-20171023EJ', '90', '1366', '768', 'dog7003', '성경농자재[남자경]', '397077679605' ) ========================2018-01-11 10:20:30======================== noteurl_start parm_app_code = 050 parm_pc_name = OHS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A6202402BC1A66 sCDKey = 922590601683 sName = OHS-PC ========================2018-01-11 10:20: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-11 10:24:04======================== noteurl_start parm_app_code = 050 parm_pc_name = OHS-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A6202402BC1A66 sCDKey = 922590601683 sName = OHS-PC ========================2018-01-11 10:24: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-11 10:24:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'iicooii' ========================2018-01-11 10:24:04======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A6202402BC1A66' AND app_code = '050' ========================2018-01-11 10:24:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '209067' ========================2018-01-11 10:24:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '209067' ========================2018-01-11 10:24:04======================== UPDATE mac_detail SET pc_name = 'OHS-PC', os_type = '90', user_id = 'iicooii', user_name = '경상북도환경연수원[이진숙]', screen_w = '1920', screen_h = '1080', cdkey = '922590601683' WHERE mac_idx = '209067' ========================2018-01-11 10:39:27======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = ========================2018-01-11 10:39:27======================== 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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-11 10:39:37======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-11 10: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-11 10:41:24======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-11 10:41: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-11 10:41:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'iicooii' ========================2018-01-11 10:41:24======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A64E5C2CF7C7D7' AND app_code = '050' ========================2018-01-11 10:41:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '159882' ========================2018-01-11 10:41:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '159882' ========================2018-01-11 10:41:24======================== UPDATE mac_detail SET pc_name = '경상북도환경연수원', os_type = '90', user_id = 'iicooii', user_name = '경상북도환경연수원[이진숙]', screen_w = '1920', screen_h = '1080', cdkey = '922590601683' WHERE mac_idx = '159882' ========================2018-01-11 10:41:31======================== noteurl_start parm_app_code = 050 parm_pc_name = parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A64E5C2CF7C7D7 sCDKey = 922590601683 sName = 경상북도환경연수원 ========================2018-01-11 10:41: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 = '922590601683' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-11 11:05:37======================== noteurl_start parm_app_code = 039 parm_pc_name = PC-MAIN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838982C321DAB017AA sCDKey = 853846793831 sName = PC-MAIN ========================2018-01-11 11: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:05:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-01-11 11:05:37======================== SELECT idx FROM macs WHERE mac_addr = '98838982C321DAB017AA' AND app_code = '039' ========================2018-01-11 11:05:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238790' ========================2018-01-11 11:05:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238790' ========================2018-01-11 11: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 ( '238790', '98838982C321DAB017AA', '039', 'PC-MAIN', '110', '1920', '1080', 'ijs7740', '(주)고려양행[김기범]', '853846793831' ) ========================2018-01-11 11:07:02======================== noteurl_start parm_app_code = 039 parm_pc_name = PC07 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3AAFA68EE08A38C sCDKey = 853846793831 sName = PC07 ========================2018-01-11 11:07: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:07:02======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-01-11 11:07:02======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AAFA68EE08A38C' AND app_code = '039' ========================2018-01-11 11:07:02======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '218955' ========================2018-01-11 11:07:02======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '218955' ========================2018-01-11 11:07:02======================== UPDATE mac_detail SET pc_name = 'PC07', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '218955' ========================2018-01-11 11:08:42======================== noteurl_start parm_app_code = 039 parm_pc_name = ACE-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 6C626DB120CBEE1999FD sCDKey = 853846793831 sName = ACE-PC ========================2018-01-11 11:08: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:08:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-01-11 11:08:42======================== SELECT idx FROM macs WHERE mac_addr = '6C626DB120CBEE1999FD' AND app_code = '039' ========================2018-01-11 11:08:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '182355' ========================2018-01-11 11:08:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '182355' ========================2018-01-11 11:08:42======================== UPDATE mac_detail SET pc_name = 'ACE-PC', os_type = '90', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '182355' ========================2018-01-11 11:16:39======================== noteurl_start parm_app_code = 039 parm_pc_name = PC공유06 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18CF5E2E273636902760 sCDKey = 853846793831 sName = PC공유06 ========================2018-01-11 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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:16:39======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-01-11 11:16:39======================== SELECT idx FROM macs WHERE mac_addr = '18CF5E2E273636902760' AND app_code = '039' ========================2018-01-11 11:16:39======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '228099' ========================2018-01-11 11:16:39======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '228099' ========================2018-01-11 11:16:39======================== UPDATE mac_detail SET pc_name = 'PC공유06', os_type = '110', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '228099' ========================2018-01-11 11:21:59======================== noteurl_start parm_app_code = 039 parm_pc_name = PC04-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 64E599F50F84EE1999FD sCDKey = 853846793831 sName = PC04-PC ========================2018-01-11 11:21: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 = '853846793831' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:21:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ijs7740' ========================2018-01-11 11:21:59======================== SELECT idx FROM macs WHERE mac_addr = '64E599F50F84EE1999FD' AND app_code = '039' ========================2018-01-11 11:21:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '182605' ========================2018-01-11 11:21:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '182605' ========================2018-01-11 11:21:59======================== UPDATE mac_detail SET pc_name = 'PC04-PC', os_type = '90', user_id = 'ijs7740', user_name = '(주)고려양행[김기범]', screen_w = '1920', screen_h = '1080', cdkey = '853846793831' WHERE mac_idx = '182605' ========================2018-01-11 11:50:46======================== noteurl_start parm_app_code = 039 parm_pc_name = RQYB9LW19GBL1YI parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = F44D304B388DB8073CC1 sCDKey = 272834265921 sName = RQYB9LW19GBL1YI ========================2018-01-11 11:50: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 = '272834265921' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:50:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kjw67729' ========================2018-01-11 11:50:46======================== SELECT idx FROM macs WHERE mac_addr = 'F44D304B388DB8073CC1' AND app_code = '039' ========================2018-01-11 11:50:46======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238970' ========================2018-01-11 11:50:46======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238970' ========================2018-01-11 11:50:46======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '238970', 'F44D304B388DB8073CC1', '039', 'RQYB9LW19GBL1YI', '90', '1440', '900', 'kjw67729', '성화GS[김종욱]', '272834265921' ) ========================2018-01-11 11:50:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PSAGLFB parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A0D37A28812444C7F731 sCDKey = 397077679605 sName = DESKTOP-PSAGLFB ========================2018-01-11 11:50:52======================== 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 = '397077679605' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:50:56======================== noteurl_start parm_app_code = 039 parm_pc_name = RQYB9LW19GBL1YI parm_os_type = 90 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = F44D304B388DB8073CC1 sCDKey = 272834265921 sName = RQYB9LW19GBL1YI ========================2018-01-11 11:50: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 = '272834265921' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:56:07======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-PSAGLFB parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = A0D37A28812444C7F731 sCDKey = 397077679605 sName = DESKTOP-PSAGLFB ========================2018-01-11 11: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 = '397077679605' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 11:56:07======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dog7003' ========================2018-01-11 11:56:07======================== SELECT idx FROM macs WHERE mac_addr = 'A0D37A28812444C7F731' AND app_code = '039' ========================2018-01-11 11:56:07======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '238973' ========================2018-01-11 11:56:07======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '238973' ========================2018-01-11 11: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 ( '238973', 'A0D37A28812444C7F731', '039', 'DESKTOP-PSAGLFB', '110', '1366', '768', 'dog7003', '성경농자재[남자경]', '397077679605' ) ========================2018-01-11 13:34:26======================== noteurl_start parm_app_code = 039 parm_pc_name = SEWON-PC parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 960 parm_user_mac = E0D55E13E2B7DCDF0643 sCDKey = 810094411283 sName = SEWON-PC ========================2018-01-11 13:34: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 = '810094411283' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 13:34:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yks4677' ========================2018-01-11 13:34:26======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E13E2B7DCDF0643' AND app_code = '039' ========================2018-01-11 13:34:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '234436' ========================2018-01-11 13:34:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '234436' ========================2018-01-11 13:34:26======================== UPDATE mac_detail SET pc_name = 'SEWON-PC', os_type = '90', user_id = 'yks4677', user_name = '세원치과재료[여규수]', screen_w = '1280', screen_h = '960', cdkey = '810094411283' WHERE mac_idx = '234436' ========================2018-01-11 14:35:00======================== noteurl_start parm_app_code = 039 parm_pc_name = HANUL-WOOKYUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 702C1F1BBBB7F418804D sCDKey = 412794676239 sName = HANUL-WOOKYUNG ========================2018-01-11 14:35: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 = '412794676239' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 14:35:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'industry2' ========================2018-01-11 14:35:00======================== SELECT idx FROM macs WHERE mac_addr = '702C1F1BBBB7F418804D' AND app_code = '039' ========================2018-01-11 14:35:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '197678' ========================2018-01-11 14:35:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '197678' ========================2018-01-11 14:35:00======================== UPDATE mac_detail SET pc_name = 'HANUL-WOOKYUNG', os_type = '110', user_id = 'industry2', user_name = '(주)한울[이공엽]', screen_w = '1920', screen_h = '1080', cdkey = '412794676239' WHERE mac_idx = '197678' ========================2018-01-11 15:05:05======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2CFDA1BF686CEEB62061 sCDKey = 686598783963 sName = ========================2018-01-11 15:05: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 = '686598783963' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 15:05:19======================== noteurl_start parm_app_code = 039 parm_pc_name = parm_os_type = 90 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 2CFDA1BF686CEEB62061 sCDKey = 686598783963 sName = 호남-pc ========================2018-01-11 15:05: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 = '686598783963' AND r.app_code = '039' AND r.app_block = 0 ========================2018-01-11 15:05:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'honam6878' ========================2018-01-11 15:05:19======================== SELECT idx FROM macs WHERE mac_addr = '2CFDA1BF686CEEB62061' AND app_code = '039' ========================2018-01-11 15:05:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239008' ========================2018-01-11 15:05:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239008' ========================2018-01-11 15:05:19======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239008', '2CFDA1BF686CEEB62061', '039', '호남-pc', '90', '1280', '1024', 'honam6878', '호남의수족[나용석]', '686598783963' ) ========================2018-01-11 16:03:36======================== noteurl_start parm_app_code = 050 parm_pc_name = SEO-W12-001 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D4AE52C00D6B55458620 sCDKey = 473735708251 sName = SEO-W12-001 ========================2018-01-11 16:03:36======================== 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 = '473735708251' AND r.app_code = '050' AND r.app_block = 0 ========================2018-01-11 17:32:40======================== 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 = 50AF73275E08A41C65F sCDKey = 981323002872 sName = USER-PC ========================2018-01-11 17:32:40======================== 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 = '981323002872' AND r.app_code = '046' AND r.app_block = 0 ========================2018-01-11 17:32:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'plusmart' ========================2018-01-11 17:32:40======================== SELECT idx FROM macs WHERE mac_addr = '50AF73275E08A41C65F' AND app_code = '046' ========================2018-01-11 17:32:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239041' ========================2018-01-11 17:32:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239041' ========================2018-01-11 17:32:40======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239041', '50AF73275E08A41C65F', '046', 'USER-PC', '90', '1024', '768', 'plusmart', '플러스마트[김동진]', '981323002872' )