========================2018-11-23 10:16:16======================== noteurl_start parm_app_code = 039 parm_pc_name = HP-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 701A0412BC2CB020BE40 sCDKey = 494147666219 sName = HP-PC ========================2018-11-23 10:16:16======================== 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 = '494147666219' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-23 10:16:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'alsruddl81' ========================2018-11-23 10:16:16======================== SELECT idx FROM macs WHERE mac_addr = '701A0412BC2CB020BE40' AND app_code = '039' ========================2018-11-23 10:16:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268667' ========================2018-11-23 10:16:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268667' ========================2018-11-23 10:16:16======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268667', '701A0412BC2CB020BE40', '039', 'HP-PC', '90', '1600', '900', 'alsruddl81', '케이텍[김민경]', '494147666219' ) ========================2018-11-23 11:25:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DAVIS19 parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = BC5FF4413FDFE2F07406 sCDKey = 850893808247 sName = DAVIS19 ========================2018-11-23 11:25:18======================== 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 = '850893808247' AND r.app_code = '039' AND r.app_block = 0 ========================2018-11-23 11:25:18======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'davis747' ========================2018-11-23 11:25:18======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4413FDFE2F07406' AND app_code = '039' ========================2018-11-23 11:25:18======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268689' ========================2018-11-23 11:25:18======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268689' ========================2018-11-23 11:25:18======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '268689', 'BC5FF4413FDFE2F07406', '039', 'DAVIS19', '90', '1600', '900', 'davis747', '(주)다비스다이아몬드[홍연호]', '850893808247' ) ========================2018-11-23 14:31:11======================== noteurl_start parm_app_code = 046 parm_pc_name = POS1 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 202564847D6BC0A59A4B sCDKey = 169591860148 sName = POS7-181123 ========================2018-11-23 14:31: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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-23 14:32:45======================== noteurl_start parm_app_code = 046 parm_pc_name = POS1 parm_os_type = 64 parm_screen_w = 1024 parm_screen_h = 768 parm_user_mac = 202564847D6BC0A59A4B sCDKey = 169591860148 sName = POS7new ========================2018-11-23 14:32:45======================== 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 = '169591860148' AND r.app_code = '046' AND r.app_block = 0 ========================2018-11-23 14:32:45======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hjss064' ========================2018-11-23 14:32:45======================== SELECT idx FROM macs WHERE mac_addr = '202564847D6BC0A59A4B' AND app_code = '046' ========================2018-11-23 14:32:45======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '131204' ========================2018-11-23 14:32:45======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '131204' ========================2018-11-23 14:32:45======================== UPDATE mac_detail SET pc_name = 'POS7new', os_type = '64', user_id = 'hjss064', user_name = '형제상사주식회사[양진규]', screen_w = '1024', screen_h = '768', cdkey = '169591860148' WHERE mac_idx = '131204' ========================2018-11-23 16:10:00======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-47O1IAB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E9CAF358E538D2E sCDKey = 426621923236 sName = DESKTOP-47O1IAB ========================2018-11-23 16:10: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 = '426621923236' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-23 16:10:32======================== noteurl_start parm_app_code = 045 parm_pc_name = DESKTOP-47O1IAB parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E0D55E9CAF358E538D2E sCDKey = 426621923236 sName = DESKTOP-47O1IAB ========================2018-11-23 16:10: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 = '426621923236' AND r.app_code = '045' AND r.app_block = 0 ========================2018-11-23 16:10:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'heavenof' ========================2018-11-23 16:10:32======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E9CAF358E538D2E' AND app_code = '045' ========================2018-11-23 16:10:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '268732' ========================2018-11-23 16:10:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '268732' ========================2018-11-23 16:10: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 ( '268732', 'E0D55E9CAF358E538D2E', '045', 'DESKTOP-47O1IAB', '110', '1920', '1080', 'heavenof', '(주)서광테라[김정호]', '426621923236' )