========================2021-09-24 09:48:49======================== noteurl_start parm_app_code = 039 parm_pc_name = SURI-2109231620 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 002522A3F62D98E50522 sCDKey = 789105512965 sName = SURI-2109231620 ========================2021-09-24 09:48: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 = '789105512965' AND r.app_code = '039' AND r.app_block = 0 ========================2021-09-24 09:48:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jeep2014' ========================2021-09-24 09:48:49======================== SELECT idx FROM macs WHERE mac_addr = '002522A3F62D98E50522' AND app_code = '039' ========================2021-09-24 09:48:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '351474' ========================2021-09-24 09:48:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '351474' ========================2021-09-24 09:48: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 ( '351474', '002522A3F62D98E50522', '039', 'SURI-2109231620', '90', '1920', '1080', 'jeep2014', '태성코아[박종길]', '789105512965' ) ========================2021-09-24 15:45:20======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-A3565RF parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 704D7B8AB511466AFD1 sCDKey = 781008131999 sName = DESKTOP-A3565RF ========================2021-09-24 15:45: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 = '781008131999' AND r.app_code = '039' AND r.app_block = 0 ========================2021-09-24 15:45:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'changmoo' ========================2021-09-24 15:45:20======================== SELECT idx FROM macs WHERE mac_addr = '704D7B8AB511466AFD1' AND app_code = '039' ========================2021-09-24 15:45:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '351496' ========================2021-09-24 15:45:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '351496' ========================2021-09-24 15:45:20======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '351496', '704D7B8AB511466AFD1', '039', 'DESKTOP-A3565RF', '110', '1920', '1080', 'changmoo', '일미식품[이창무]', '781008131999' ) ========================2021-09-24 15:47:43======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RTPEE2R parm_os_type = 110 parm_screen_w = 1360 parm_screen_h = 768 parm_user_mac = 18C04D98AC9EE6264379 sCDKey = 768252437481 sName = DESKTOP-RTPEE2R ========================2021-09-24 15:47: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 = '768252437481' AND r.app_code = '039' AND r.app_block = 0 ========================2021-09-24 15:47:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'askig750' ========================2021-09-24 15:47:43======================== SELECT idx FROM macs WHERE mac_addr = '18C04D98AC9EE6264379' AND app_code = '039' ========================2021-09-24 15:47:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '344162' ========================2021-09-24 15:47:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '344162' ========================2021-09-24 15:47:43======================== UPDATE mac_detail SET pc_name = 'DESKTOP-RTPEE2R', os_type = '110', user_id = 'askig750', user_name = '혜일정공[정나영]', screen_w = '1360', screen_h = '768', cdkey = '768252437481' WHERE mac_idx = '344162' ========================2021-09-24 18:47:28======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-5JR2145 parm_os_type = 110 parm_screen_w = 1707 parm_screen_h = 1067 parm_user_mac = BC17B882C8FA66842391 sCDKey = 431746237956 sName = DESKTOP-5JR2145 ========================2021-09-24 18:47:28======================== 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 = '431746237956' AND r.app_code = '046' AND r.app_block = 0 ========================2021-09-24 18:47:47======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-5JR2145 parm_os_type = 110 parm_screen_w = 1707 parm_screen_h = 1067 parm_user_mac = BC17B882C8FA66842391 sCDKey = 431746237956 sName = DESKTOP-5JR2145 ========================2021-09-24 18:47:47======================== 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 = '431746237956' AND r.app_code = '046' AND r.app_block = 0 ========================2021-09-24 18:47:59======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-5JR2145 parm_os_type = 110 parm_screen_w = 1707 parm_screen_h = 1067 parm_user_mac = BC17B882C8FA66842391 sCDKey = 431746237956 sName = 경성방앗간 ========================2021-09-24 18:47: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 = '431746237956' AND r.app_code = '046' AND r.app_block = 0