========================2023-03-15 09:00:47======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:00: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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:00:47======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:00:47======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:00:47======================== 값이 없을 경우 ========================2023-03-15 09:01:24======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:01:24======================== 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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:01:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:01:24======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:01:24======================== 값이 없을 경우 ========================2023-03-15 09:01:46======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:01:46======================== 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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:01:46======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:01:46======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:01:46======================== 값이 없을 경우 ========================2023-03-15 09:01:49======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:01: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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:01:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:01:49======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:01:49======================== 값이 없을 경우 ========================2023-03-15 09:02:50======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:02:50======================== 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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:02:50======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:02:50======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:02:50======================== 값이 없을 경우 ========================2023-03-15 09:02:53======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:02: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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:02:53======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:02:53======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:02:53======================== 값이 없을 경우 ========================2023-03-15 09:03:49======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:03: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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:03:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:03:49======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:03:49======================== 값이 없을 경우 ========================2023-03-15 09:08:42======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-ENGR55B parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 581122BE0E58081B107A sCDKey = 963942212650 sName = DESKTOP-ENGR55B ========================2023-03-15 09:08:42======================== 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 = '963942212650' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 09:08:42======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gjtjs8762' ========================2023-03-15 09:08:42======================== SELECT idx FROM macs WHERE mac_addr = '581122BE0E58081B107A' AND app_code = '047' ========================2023-03-15 09:08:42======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '384297' ========================2023-03-15 09:08:42======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '384297' ========================2023-03-15 09:08:42======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '384297', '581122BE0E58081B107A', '047', 'DESKTOP-ENGR55B', '�쐢�룄�슦 10', '0', '0', 'gjtjs8762', '한일종합상사[허선희]', '963942212650' ) ========================2023-03-15 14:21:55======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-2Q8B1P0 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 98838981A387CE360DEB sCDKey = 970761748075 sName = DESKTOP-2Q8B1P0 ========================2023-03-15 14:21: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 = '970761748075' AND r.app_code = '039' AND r.app_block = 0 ========================2023-03-15 14:21:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jjmm646600' ========================2023-03-15 14:21:55======================== SELECT idx FROM macs WHERE mac_addr = '98838981A387CE360DEB' AND app_code = '039' ========================2023-03-15 14:21:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '384331' ========================2023-03-15 14:21:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '384331' ========================2023-03-15 14:21: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 ( '384331', '98838981A387CE360DEB', '039', 'DESKTOP-2Q8B1P0', '110', '1920', '1080', 'jjmm646600', '성창산업사[박경희]', '970761748075' ) ========================2023-03-15 16:18:52======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-4JUT61L parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 1024 parm_user_mac = 24F5AAE8792614FFF72A sCDKey = 210690492788 sName = DESKTOP-4JUT61L ========================2023-03-15 16:18:52======================== 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 = '210690492788' AND r.app_code = '039' AND r.app_block = 0 ========================2023-03-15 16:18:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljm1515' ========================2023-03-15 16:18:52======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAE8792614FFF72A' AND app_code = '039' ========================2023-03-15 16:18:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '365540' ========================2023-03-15 16:18:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '365540' ========================2023-03-15 16:18:52======================== UPDATE mac_detail SET pc_name = 'DESKTOP-4JUT61L', os_type = '110', user_id = 'ljm1515', user_name = '개별화물[이정만]', screen_w = '1600', screen_h = '1024', cdkey = '210690492788' WHERE mac_idx = '365540' ========================2023-03-15 16:55:20======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-3T17EOK parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A85E45151BF488A90BDE sCDKey = 958864665488 sName = DESKTOP-3T17EOK ========================2023-03-15 16:55: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 = '958864665488' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 16:55:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'baket' ========================2023-03-15 16:55:20======================== SELECT idx FROM macs WHERE mac_addr = 'A85E45151BF488A90BDE' AND app_code = '047' ========================2023-03-15 16:55:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '311702' ========================2023-03-15 16:55:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '311702' ========================2023-03-15 16:55:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-3T17EOK', os_type = '�쐢�룄�슦 10', user_id = 'baket', user_name = '샤네마네킹[신경학]', screen_w = '0', screen_h = '0', cdkey = '958864665488' WHERE mac_idx = '311702' ========================2023-03-15 16:56:49======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-8CIQFF2 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 64E599FB3E06B4FFE751 sCDKey = 990337893755 sName = 오상목TES ========================2023-03-15 16:56: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 = '990337893755' AND r.app_code = '047' AND r.app_block = 0 ========================2023-03-15 16:56:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'adam5352' ========================2023-03-15 16:56:49======================== SELECT idx FROM macs WHERE mac_addr = '64E599FB3E06B4FFE751' AND app_code = '047' ========================2023-03-15 16:56:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '384345' ========================2023-03-15 16:56:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '384345' ========================2023-03-15 16:56: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 ( '384345', '64E599FB3E06B4FFE751', '047', '오상목TES', '�쐢�룄�슦 10', '0', '0', 'adam5352', '오상목[오상목]', '990337893755' )