========================2022-03-17 10:21:53======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-RLH7HV0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 14DAE9200AE148E681F2 sCDKey = 109436997008 sName = DESKTOP-RLH7HV0 ========================2022-03-17 10:21:53======================== 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 = '109436997008' AND r.app_code = '039' AND r.app_block = 0 ========================2022-03-17 10:21:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kimlee21' ========================2022-03-17 10:21:53======================== SELECT idx FROM macs WHERE mac_addr = '14DAE9200AE148E681F2' AND app_code = '039' ========================2022-03-17 10:21:53======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363456' ========================2022-03-17 10:21:53======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '363456' ========================2022-03-17 10:21:53======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '363456', '14DAE9200AE148E681F2', '039', 'DESKTOP-RLH7HV0', '110', '1920', '1080', 'kimlee21', '(주)태봉산업개발[김남국]', '109436997008' ) ========================2022-03-17 12:01:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-VA9H7NU parm_os_type = 110 parm_screen_w = 1536 parm_screen_h = 864 parm_user_mac = E884A5EB850CBA0F07A9 sCDKey = 417976035527 sName = DESKTOP-VA9H7NU ========================2022-03-17 12:01:55======================== 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 = '417976035527' AND r.app_code = '039' AND r.app_block = 0 ========================2022-03-17 12:01:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dbsafety' ========================2022-03-17 12:01:55======================== SELECT idx FROM macs WHERE mac_addr = 'E884A5EB850CBA0F07A9' AND app_code = '039' ========================2022-03-17 12:01:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363462' ========================2022-03-17 12:01:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '363462' ========================2022-03-17 12:01:55======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '363462', 'E884A5EB850CBA0F07A9', '039', 'DESKTOP-VA9H7NU', '110', '1536', '864', 'dbsafety', '동방세이프티[이상배]', '417976035527' ) ========================2022-03-17 13:14:08======================== noteurl_start parm_app_code = 039 parm_pc_name = DBSAFETY-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 50B7C3A24B67ACE01D42 sCDKey = 417976035527 sName = DBSAFETY-PC ========================2022-03-17 13:14:08======================== 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 = '417976035527' AND r.app_code = '039' AND r.app_block = 0 ========================2022-03-17 13:14:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dbsafety' ========================2022-03-17 13:14:08======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3A24B67ACE01D42' AND app_code = '039' ========================2022-03-17 13:14:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '204985' ========================2022-03-17 13:14:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '204985' ========================2022-03-17 13:14:08======================== UPDATE mac_detail SET pc_name = 'DBSAFETY-PC', os_type = '90', user_id = 'dbsafety', user_name = '동방세이프티[이상배]', screen_w = '1920', screen_h = '1080', cdkey = '417976035527' WHERE mac_idx = '204985' ========================2022-03-17 13:16:55======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-USIMESP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 049226D8E322E05BB90D sCDKey = 485471512783 sName = DESKTOP-USIMESP ========================2022-03-17 13:16:55======================== 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 = '485471512783' AND r.app_code = '046' AND r.app_block = 0 ========================2022-03-17 13:27:03======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-USIMESP parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 049226D8E322E05BB90D sCDKey = 211133892505 sName = DESKTOP-USIMESP ========================2022-03-17 13:27: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 = '211133892505' AND r.app_code = '046' AND r.app_block = 0 ========================2022-03-17 13:27:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'inje2001' ========================2022-03-17 13:27:03======================== SELECT idx FROM macs WHERE mac_addr = '049226D8E322E05BB90D' AND app_code = '046' ========================2022-03-17 13:27:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '363464' ========================2022-03-17 13:27:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '363464' ========================2022-03-17 13:27: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 ( '363464', '049226D8E322E05BB90D', '046', 'DESKTOP-USIMESP', '110', '1920', '1080', 'inje2001', '대영철물[전현석]', '211133892505' ) ========================2022-03-17 21:14:34======================== noteurl_start parm_app_code = 039 parm_pc_name = SAMSUNG parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = E8039A6F64572456FA2C sCDKey = 320721918057 sName = SAMSUNG ========================2022-03-17 21:14:34======================== 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 = '320721918057' AND r.app_code = '039' AND r.app_block = 0