========================2020-07-28 09:14:40======================== noteurl_start parm_app_code = 039 parm_pc_name = HYUNPC parm_os_type = 110 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 2CD05A714554D02CA63D sCDKey = 774078853154 sName = HYUNPC ========================2020-07-28 09:14: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 = '774078853154' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-28 09:14:40======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ja2126' ========================2020-07-28 09:14:40======================== SELECT idx FROM macs WHERE mac_addr = '2CD05A714554D02CA63D' AND app_code = '039' ========================2020-07-28 09:14:40======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '127459' ========================2020-07-28 09:14:40======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '127459' ========================2020-07-28 09:14:40======================== UPDATE mac_detail SET pc_name = 'HYUNPC', os_type = '110', user_id = 'ja2126', user_name = '형제상사[윤종태]', screen_w = '1366', screen_h = '768', cdkey = '774078853154' WHERE mac_idx = '127459' ========================2020-07-28 10:18:00======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE74846BB25F sCDKey = 217223037343 sName = OFFICE-PC ========================2020-07-28 10:18: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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-28 10:18:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sunjin677' ========================2020-07-28 10:18:00======================== SELECT idx FROM macs WHERE mac_addr = 'C83A35C8BE74846BB25F' AND app_code = '039' ========================2020-07-28 10:18:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '284851' ========================2020-07-28 10:18:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '284851' ========================2020-07-28 10:18:00======================== UPDATE mac_detail SET pc_name = 'OFFICE-PC', os_type = '110', user_id = 'sunjin677', user_name = '선진FS[김형희]', screen_w = '1280', screen_h = '1024', cdkey = '217223037343' WHERE mac_idx = '284851' ========================2020-07-28 10:18:12======================== noteurl_start parm_app_code = 039 parm_pc_name = OFFICE-PC parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = C83A35C8BE74846BB25F sCDKey = 217223037343 sName = OFFICE-PC ========================2020-07-28 10:18: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 = '217223037343' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-28 11:38:32======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3IC7D72 parm_os_type = 110 parm_screen_w = 1280 parm_screen_h = 1024 parm_user_mac = 001966EC71294E2C637E sCDKey = 001695990547 sName = DESKTOP-3IC7D72 ========================2020-07-28 11:38: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 = '001695990547' AND r.app_code = '039' AND r.app_block = 0 ========================2020-07-28 11:38:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimeh5084' ========================2020-07-28 11:38:32======================== SELECT idx FROM macs WHERE mac_addr = '001966EC71294E2C637E' AND app_code = '039' ========================2020-07-28 11:38:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322683' ========================2020-07-28 11:38:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322683' ========================2020-07-28 11:38: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 ( '322683', '001966EC71294E2C637E', '039', 'DESKTOP-3IC7D72', '110', '1280', '1024', 'kimeh5084', '대신전기조명안전[김은하]', '001695990547' ) ========================2020-07-28 12:01:22======================== noteurl_start parm_app_code = 047 parm_pc_name = OKPOS parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975AC5415076634BC0 sCDKey = 698594002049 sName = OKPOS ========================2020-07-28 12:01: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 = '698594002049' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-28 12:01:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'boxpack01' ========================2020-07-28 12:01:22======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AC5415076634BC0' AND app_code = '047' ========================2020-07-28 12:01:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322859' ========================2020-07-28 12:01:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322859' ========================2020-07-28 12:01: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 ( '322859', 'B8975AC5415076634BC0', '047', 'OKPOS', '�쐢�룄�슦 7', '0', '0', 'boxpack01', '주식회사금촌[노승규]', '698594002049' ) ========================2020-07-28 13:49:10======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-G7LP7S1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 00216BFA30936E2D2C38 sCDKey = 397825905796 sName = DESKTOP-G7LP7S1 ========================2020-07-28 13:49: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 = '397825905796' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-28 13:49:10======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mallgoer' ========================2020-07-28 13:49:10======================== SELECT idx FROM macs WHERE mac_addr = '00216BFA30936E2D2C38' AND app_code = '047' ========================2020-07-28 13:49:10======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '249071' ========================2020-07-28 13:49:10======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '249071' ========================2020-07-28 13:49:10======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '249071', '00216BFA30936E2D2C38', '047', 'DESKTOP-G7LP7S1', '�쐢�룄�슦 10', '0', '0', 'mallgoer', '데르나[조성길]', '397825905796' ) ========================2020-07-28 17:13:03======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-DLKSHGA parm_os_type = 110 parm_screen_w = 1707 parm_screen_h = 1067 parm_user_mac = D83BBF4F18CF6ABD5E sCDKey = 279572035868 sName = DESKTOP-DLKSHGA ========================2020-07-28 17:13: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 = '279572035868' AND r.app_code = '045' AND r.app_block = 0 ========================2020-07-28 17:13:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'europe0515' ========================2020-07-28 17:13:03======================== SELECT idx FROM macs WHERE mac_addr = 'D83BBF4F18CF6ABD5E' AND app_code = '045' ========================2020-07-28 17:13:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322877' ========================2020-07-28 17:13:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322877' ========================2020-07-28 17:13: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 ( '322877', 'D83BBF4F18CF6ABD5E', '045', 'DESKTOP-DLKSHGA', '110', '1707', '1067', 'europe0515', '유럽상사1[장희철]', '279572035868' ) ========================2020-07-28 17:19:13======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-8EV4E9L parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E9907747FCA145F73 sCDKey = 279572035868 sName = DESKTOP-8EV4E9L ========================2020-07-28 17:19:13======================== 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 = '279572035868' AND r.app_code = '045' AND r.app_block = 0 ========================2020-07-28 17:19:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'europe0515' ========================2020-07-28 17:19:13======================== SELECT idx FROM macs WHERE mac_addr = 'B42E9907747FCA145F73' AND app_code = '045' ========================2020-07-28 17:19:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '318268' ========================2020-07-28 17:19:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '318268' ========================2020-07-28 17:19:13======================== UPDATE mac_detail SET pc_name = 'DESKTOP-8EV4E9L', os_type = '110', user_id = 'europe0515', user_name = '유럽상사1[장희철]', screen_w = '1920', screen_h = '1080', cdkey = '279572035868' WHERE mac_idx = '318268'