========================2020-12-08 10:04:21======================== noteurl_start parm_app_code = 039 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1200 parm_user_mac = B42E99253E05CC21DBCC sCDKey = 264133772382 sName = USER-PC ========================2020-12-08 10:04:21======================== 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 = '264133772382' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-08 10:04:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'han5469' ========================2020-12-08 10:04:21======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99253E05CC21DBCC' AND app_code = '039' ========================2020-12-08 10:04:21======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331836' ========================2020-12-08 10:04:21======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331836' ========================2020-12-08 10:04:21======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331836', 'B42E99253E05CC21DBCC', '039', 'USER-PC', '90', '1920', '1200', 'han5469', '한창산업[한기갑]', '264133772382' ) ========================2020-12-08 16:24:44======================== noteurl_start parm_app_code = 039 parm_pc_name = BAEK01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5A5883EBE96618A sCDKey = 035701543380 sName = BAEK01 ========================2020-12-08 16:24:44======================== 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 = '035701543380' AND r.app_code = '039' AND r.app_block = 0 ========================2020-12-08 16:24:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bk4jji' ========================2020-12-08 16:24:44======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5A5883EBE96618A' AND app_code = '039' ========================2020-12-08 16:24:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331888' ========================2020-12-08 16:24:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331888' ========================2020-12-08 16:24:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331888', 'C03FD5A5883EBE96618A', '039', 'BAEK01', '110', '1920', '1080', 'bk4jji', '백경사[조주일]', '035701543380' ) ========================2020-12-08 16:53:51======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-I1KM87K parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 18C04D0EA062F8C262C7 sCDKey = 154489039328 sName = DESKTOP-I1KM87K ========================2020-12-08 16:53:51======================== 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 = '154489039328' AND r.app_code = '050' AND r.app_block = 0 ========================2020-12-08 16:53:51======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'blc2009' ========================2020-12-08 16:53:51======================== SELECT idx FROM macs WHERE mac_addr = '18C04D0EA062F8C262C7' AND app_code = '050' ========================2020-12-08 16:53:51======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '331890' ========================2020-12-08 16:53:51======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '331890' ========================2020-12-08 16:53:51======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '331890', '18C04D0EA062F8C262C7', '050', 'DESKTOP-I1KM87K', '109', '1920', '1080', 'blc2009', '대구검찰어린이집[대구검찰어린이집]', '154489039328' ) ========================2020-12-08 21:17:03======================== noteurl_start parm_app_code = 046 parm_pc_name = LAPTOP-8G5FJBFO parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = 30D16BFC3975FCE8C6F9 sCDKey = 382658505643 sName = LAPTOP-8G5FJBFO ========================2020-12-08 21:17: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 = '382658505643' AND r.app_code = '046' AND r.app_block = 0 ========================2020-12-08 21:17:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kec1211' ========================2020-12-08 21:17:03======================== SELECT idx FROM macs WHERE mac_addr = '30D16BFC3975FCE8C6F9' AND app_code = '046' ========================2020-12-08 21:17:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '330249' ========================2020-12-08 21:17:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '330249' ========================2020-12-08 21:17:03======================== UPDATE mac_detail SET pc_name = 'LAPTOP-8G5FJBFO', os_type = '110', user_id = 'kec1211', user_name = '천지유통(김기호)[김기호]', screen_w = '1536', screen_h = '864', cdkey = '382658505643' WHERE mac_idx = '330249' ========================2020-12-08 23:14:44======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-7DVCNT1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = BC5FF47F93B526F9EE6A sCDKey = 380824684722 sName = DESKTOP-7DVCNT1 ========================2020-12-08 23:14:44======================== 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 = '380824684722' AND r.app_code = '048' AND r.app_block = 0