========================2021-01-11 10:31:59======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-3V8Q6K7 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAEA5F5E14F67A53 sCDKey = 610420211078 sName = DESKTOP-3V8Q6K7 ========================2021-01-11 10:31: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 = '610420211078' AND r.app_code = '050' AND r.app_block = 0 ========================2021-01-11 10:31:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bmmh2010' ========================2021-01-11 10:31:59======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAEA5F5E14F67A53' AND app_code = '050' ========================2021-01-11 10:31:59======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334451' ========================2021-01-11 10:31:59======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334451' ========================2021-01-11 10:31:59======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334451', '24F5AAEA5F5E14F67A53', '050', 'DESKTOP-3V8Q6K7', '109', '1920', '1080', 'bmmh2010', '부산시립정신병원[강기룡]', '610420211078' ) ========================2021-01-11 10:32:14======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-3V8Q6K7 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAEA5F5E14F67A53 sCDKey = 610420211078 sName = 부산시립정신병원 ========================2021-01-11 10:32:14======================== 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 = '610420211078' AND r.app_code = '050' AND r.app_block = 0 ========================2021-01-11 11:06:36======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3C4QSDE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B52023012E82DB4EB4 sCDKey = 625904807748 sName = DESKTOP-3C4QSDE ========================2021-01-11 11:06:36======================== 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 = '625904807748' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-11 11:06:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gkswls1212' ========================2021-01-11 11:06:36======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52023012E82DB4EB4' AND app_code = '039' ========================2021-01-11 11:06:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334436' ========================2021-01-11 11:06:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334436' ========================2021-01-11 11:06:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334436', 'F4B52023012E82DB4EB4', '039', 'DESKTOP-3C4QSDE', '110', '1920', '1080', 'gkswls1212', '(주)에스제이로지스틱스[이재민]', '625904807748' ) ========================2021-01-11 11:34:12======================== noteurl_start parm_app_code = 039 parm_pc_name = COM-A402 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99DAFF3F16AE9BEF sCDKey = 625904807748 sName = COM-A402 ========================2021-01-11 11:34:12======================== 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 = '625904807748' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-11 11:34:35======================== noteurl_start parm_app_code = 039 parm_pc_name = COM-A402 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E99DAFF3F16AE9BEF sCDKey = 625904807748 sName = COM-A402 ========================2021-01-11 11:34:35======================== 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 = '625904807748' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-11 11:34:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gkswls1212' ========================2021-01-11 11:34:35======================== SELECT idx FROM macs WHERE mac_addr = 'B42E99DAFF3F16AE9BEF' AND app_code = '039' ========================2021-01-11 11:34:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '323814' ========================2021-01-11 11:34:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '323814' ========================2021-01-11 11:34:35======================== UPDATE mac_detail SET pc_name = 'COM-A402', os_type = '110', user_id = 'gkswls1212', user_name = '(주)에스제이로지스틱스[이재민]', screen_w = '1920', screen_h = '1080', cdkey = '625904807748' WHERE mac_idx = '323814' ========================2021-01-11 11:55:18======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SC5T08N parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = 40B076A27EF24E445F3F sCDKey = 172998658701 sName = DESKTOP-SC5T08N ========================2021-01-11 11:55: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 = '172998658701' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-11 11:57:37======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-SC5T08N parm_os_type = 110 parm_screen_w = 3440 parm_screen_h = 1440 parm_user_mac = 40B076A27EF24E445F3F sCDKey = 172998658701 sName = DESKTOP-SC5T08N ========================2021-01-11 11:57:37======================== 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 = '172998658701' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-11 11:57:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'sekwang0316' ========================2021-01-11 11:57:37======================== SELECT idx FROM macs WHERE mac_addr = '40B076A27EF24E445F3F' AND app_code = '039' ========================2021-01-11 11:57:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334345' ========================2021-01-11 11:57:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334345' ========================2021-01-11 11:57:37======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334345', '40B076A27EF24E445F3F', '039', 'DESKTOP-SC5T08N', '110', '3440', '1440', 'sekwang0316', '세광[문경남]', '172998658701' ) ========================2021-01-11 13:42:21======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-1S7PJU1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18473DC6A2C7CCDCC06A sCDKey = 983342868094 sName = DESKTOP-1S7PJU1 ========================2021-01-11 13:42: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 = '983342868094' AND r.app_code = '047' AND r.app_block = 0 ========================2021-01-11 13:42:21======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'komism' ========================2021-01-11 13:42:21======================== SELECT idx FROM macs WHERE mac_addr = '18473DC6A2C7CCDCC06A' AND app_code = '047' ========================2021-01-11 13:42:21======================== 값이 없을 경우 ========================2021-01-11 13:43:14======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-1S7PJU1 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 18473DC6A2C7CCDCC06A sCDKey = 983342868094 sName = DESKTOP-1S7PJU1 ========================2021-01-11 13:43:14======================== 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 = '983342868094' AND r.app_code = '047' AND r.app_block = 0 ========================2021-01-11 13:43:14======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'komism' ========================2021-01-11 13:43:14======================== SELECT idx FROM macs WHERE mac_addr = '18473DC6A2C7CCDCC06A' AND app_code = '047' ========================2021-01-11 13:43:14======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334489' ========================2021-01-11 13:43:14======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334489' ========================2021-01-11 13:43:14======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334489', '18473DC6A2C7CCDCC06A', '047', 'DESKTOP-1S7PJU1', '�쐢�룄�슦 10', '0', '0', 'komism', '혜인동물약품[조수목]', '983342868094' ) ========================2021-01-11 14:47:56======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-2SHPT5Q parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A8A159315FBC1EF76A9C sCDKey = 808887205511 sName = DESKTOP-2SHPT5Q ========================2021-01-11 14:47:56======================== 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 = '808887205511' AND r.app_code = '048' AND r.app_block = 0 ========================2021-01-11 14:47:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'cjdwjd004918' ========================2021-01-11 14:47:56======================== SELECT idx FROM macs WHERE mac_addr = 'A8A159315FBC1EF76A9C' AND app_code = '048' ========================2021-01-11 14:47:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334479' ========================2021-01-11 14:47:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334479' ========================2021-01-11 14:47:56======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334479', 'A8A159315FBC1EF76A9C', '048', 'DESKTOP-2SHPT5Q', '�쐢�룄�슦 10', '0', '0', 'cjdwjd004918', '(주)청정[최병순]', '808887205511' ) ========================2021-01-11 15:09:08======================== noteurl_start parm_app_code = 048 parm_pc_name = DESKTOP-2SHPT5Q parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = A8A159315FBC1EF76A9C sCDKey = 808887205511 sName = DESKTOP-2SHPT5Q ========================2021-01-11 15:09: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 = '808887205511' AND r.app_code = '048' AND r.app_block = 0 ========================2021-01-11 15:30:03======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-3C4QSDE parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F4B52023012E82DB4EB4 sCDKey = 793826742661 sName = DESKTOP-3C4QSDE ========================2021-01-11 15:30: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 = '793826742661' AND r.app_code = '039' AND r.app_block = 0 ========================2021-01-11 15:30:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ljh820526' ========================2021-01-11 15:30:03======================== SELECT idx FROM macs WHERE mac_addr = 'F4B52023012E82DB4EB4' AND app_code = '039' ========================2021-01-11 15:30:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334436' ========================2021-01-11 15:30:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334436' ========================2021-01-11 15:30:03======================== UPDATE mac_detail SET pc_name = 'DESKTOP-3C4QSDE', os_type = '110', user_id = 'ljh820526', user_name = 'kgb상주지점[이재혁]', screen_w = '1920', screen_h = '1080', cdkey = '793826742661' WHERE mac_idx = '334436' ========================2021-01-11 15:46:26======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-IR4BE71 parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF73364123EE2B1141 sCDKey = 461609832074 sName = DESKTOP-IR4BE71 ========================2021-01-11 15:46:26======================== 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 = '461609832074' AND r.app_code = '047' AND r.app_block = 0 ========================2021-01-11 15:46:26======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'tim2012' ========================2021-01-11 15:46:26======================== SELECT idx FROM macs WHERE mac_addr = '50AF73364123EE2B1141' AND app_code = '047' ========================2021-01-11 15:46:26======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334505' ========================2021-01-11 15:46:26======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334505' ========================2021-01-11 15:46:26======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334505', '50AF73364123EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'tim2012', '(주)팀크리에이티브[홍범영]', '461609832074' ) ========================2021-01-11 17:11:27======================== noteurl_start parm_app_code = 050 parm_pc_name = 박보현 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBBD964280A390B5 sCDKey = 149111290224 sName = 이현덕 ========================2021-01-11 17:11:27======================== 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 = '149111290224' AND r.app_code = '050' AND r.app_block = 0 ========================2021-01-11 17:11:34======================== noteurl_start parm_app_code = 050 parm_pc_name = 박보현 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBBD964280A390B5 sCDKey = 149111290224 sName = 박보현 ========================2021-01-11 17:11: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 = '149111290224' AND r.app_code = '050' AND r.app_block = 0 ========================2021-01-11 17:12:36======================== noteurl_start parm_app_code = 050 parm_pc_name = 박보현 parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 4CEDFBBD964280A390B5 sCDKey = 149111290224 sName = 이현덕 ========================2021-01-11 17:12:36======================== 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 = '149111290224' AND r.app_code = '050' AND r.app_block = 0 ========================2021-01-11 17:12:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'goodwoman' ========================2021-01-11 17:12:36======================== SELECT idx FROM macs WHERE mac_addr = '4CEDFBBD964280A390B5' AND app_code = '050' ========================2021-01-11 17:12:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '334518' ========================2021-01-11 17:12:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '334518' ========================2021-01-11 17:12:36======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '334518', '4CEDFBBD964280A390B5', '050', '이현덕', '109', '1920', '1080', 'goodwoman', '서울시중부여성발전센터[임은정]', '149111290224' )