========================2020-07-23 07:20:01======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5ELBHPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF733240C01076551B sCDKey = 034291734286 sName = DESKTOP-5ELBHPN ========================2020-07-23 07:20:01======================== 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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 07:29:24======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5ELBHPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF733240C01076551B sCDKey = 034191734286 sName = DESKTOP-5ELBHPN ========================2020-07-23 07:29: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 = '034191734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 07:29:38======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5ELBHPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF733240C01076551B sCDKey = 034291734286 sName = DESKTOP-5ELBHPN ========================2020-07-23 07:29:38======================== 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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 07:30:08======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5ELBHPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF733240C01076551B sCDKey = 034291734286 sName = DESKTOP-5ELBHPN ========================2020-07-23 07:30: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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 07:31:56======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5ELBHPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF733240C01076551B sCDKey = 034291734286 sName = DESKTOP-5ELBHPN ========================2020-07-23 07:31: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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 07:31:56======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-07-23 07:31:56======================== SELECT idx FROM macs WHERE mac_addr = '50AF733240C01076551B' AND app_code = '047' ========================2020-07-23 07:31:56======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322441' ========================2020-07-23 07:31:56======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322441' ========================2020-07-23 07:31: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 ( '322441', '50AF733240C01076551B', '047', 'DESKTOP-5ELBHPN', '�쐢�룄�슦 10', '0', '0', 'yuillss', '유일공구철물[김번영]', '034291734286' ) ========================2020-07-23 07:35:57======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5ELBHPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF7332BF5F1076551B sCDKey = 034291734286 sName = DESKTOP-5ELBHPN ========================2020-07-23 07:35:57======================== 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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 07:35:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-07-23 07:35:58======================== SELECT idx FROM macs WHERE mac_addr = '50AF7332BF5F1076551B' AND app_code = '047' ========================2020-07-23 07:35:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313841' ========================2020-07-23 07:35:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313841' ========================2020-07-23 07:35:58======================== UPDATE mac_detail SET pc_name = 'DESKTOP-5ELBHPN', os_type = '�쐢�룄�슦 10', user_id = 'yuillss', user_name = '유일공구철물[김번영]', screen_w = '0', screen_h = '0', cdkey = '034291734286' WHERE mac_idx = '313841' ========================2020-07-23 07:36:28======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-5ELBHPN parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF7332BECE1076551B sCDKey = 034291734286 sName = DESKTOP-5ELBHPN ========================2020-07-23 07:36: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 = '034291734286' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 07:36:28======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'yuillss' ========================2020-07-23 07:36:28======================== SELECT idx FROM macs WHERE mac_addr = '50AF7332BECE1076551B' AND app_code = '047' ========================2020-07-23 07:36:28======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '313853' ========================2020-07-23 07:36:28======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '313853' ========================2020-07-23 07:36:28======================== UPDATE mac_detail SET pc_name = 'DESKTOP-5ELBHPN', os_type = '�쐢�룄�슦 10', user_id = 'yuillss', user_name = '유일공구철물[김번영]', screen_w = '0', screen_h = '0', cdkey = '034291734286' WHERE mac_idx = '313853' ========================2020-07-23 09:26:36======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-ETLHDRE parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 7085C2DC2A1D4E8C7882 sCDKey = 792642878271 sName = DESKTOP-ETLHDRE ========================2020-07-23 09:26: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 = '792642878271' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-23 09:26:36======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nongga2020' ========================2020-07-23 09:26:36======================== SELECT idx FROM macs WHERE mac_addr = '7085C2DC2A1D4E8C7882' AND app_code = '046' ========================2020-07-23 09:26:36======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '316469' ========================2020-07-23 09:26:36======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '316469' ========================2020-07-23 09:26:36======================== UPDATE mac_detail SET pc_name = 'DESKTOP-ETLHDRE', os_type = '110', user_id = 'nongga2020', user_name = '농가에프엔씨[임현규]', screen_w = '1440', screen_h = '900', cdkey = '792642878271' WHERE mac_idx = '316469' ========================2020-07-23 09:26:42======================== noteurl_start parm_app_code = 046 parm_pc_name = DESKTOP-ETLHDRE parm_os_type = 110 parm_screen_w = 1440 parm_screen_h = 900 parm_user_mac = 7085C2DC2A1D4E8C7882 sCDKey = 792642878271 sName = DESKTOP-ETLHDRE ========================2020-07-23 09:26: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 = '792642878271' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-23 11:58:59======================== noteurl_start parm_app_code = 048 parm_pc_name = BOSS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA146D427AD18FA2D0 sCDKey = 780547338320 sName = 강창중 ========================2020-07-23 11:58: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-23 11:58:59======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-07-23 11:58:59======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146D427AD18FA2D0' AND app_code = '048' ========================2020-07-23 11:58:59======================== 값이 없을 경우 ========================2020-07-23 11:59:36======================== noteurl_start parm_app_code = 048 parm_pc_name = BOSS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA146D427AD18FA2D0 sCDKey = 780547338320 sName = BOSS ========================2020-07-23 11:59: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-23 11:59:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-07-23 11:59:37======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146D427AD18FA2D0' AND app_code = '048' ========================2020-07-23 11:59:37======================== 값이 없을 경우 ========================2020-07-23 11:59:43======================== noteurl_start parm_app_code = 048 parm_pc_name = BOSS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA146D427AD18FA2D0 sCDKey = 780547338320 sName = 강창중 ========================2020-07-23 11:59: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-23 11:59:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-07-23 11:59:44======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146D427AD18FA2D0' AND app_code = '048' ========================2020-07-23 11:59:44======================== 값이 없을 경우 ========================2020-07-23 12:01:55======================== noteurl_start parm_app_code = 048 parm_pc_name = BOSS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA146D427AD18FA2D0 sCDKey = 780547338320 sName = 강창중 ========================2020-07-23 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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-23 12:01:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-07-23 12:01:55======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146D427AD18FA2D0' AND app_code = '048' ========================2020-07-23 12:01:55======================== 값이 없을 경우 ========================2020-07-23 12:07:06======================== noteurl_start parm_app_code = 048 parm_pc_name = BOSS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA146D427AD18FA2D0 sCDKey = 780547338320 sName = 강창중 ========================2020-07-23 12:07:06======================== 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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-23 12:07:06======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-07-23 12:07:06======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146D427AD18FA2D0' AND app_code = '048' ========================2020-07-23 12:07:06======================== 값이 없을 경우 ========================2020-07-23 12:08:55======================== noteurl_start parm_app_code = 048 parm_pc_name = BOSS parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = FCAA146D427AD18FA2D0 sCDKey = 780547338320 sName = 강창중 ========================2020-07-23 12:08: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 = '780547338320' AND r.app_code = '048' AND r.app_block = 0 ========================2020-07-23 12:08:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'aone0022' ========================2020-07-23 12:08:55======================== SELECT idx FROM macs WHERE mac_addr = 'FCAA146D427AD18FA2D0' AND app_code = '048' ========================2020-07-23 12:08:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322481' ========================2020-07-23 12:08:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322481' ========================2020-07-23 12:08: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 ( '322481', 'FCAA146D427AD18FA2D0', '048', '강창중', '�쐢�룄�슦 10', '0', '0', 'aone0022', '(주)에이원메디칼[강창중]', '780547338320' ) ========================2020-07-23 13:30:35======================== 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 = 50AF7333D8D2EE2B1141 sCDKey = 218720356775 sName = DESKTOP-IR4BE71 ========================2020-07-23 13:30: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 = '218720356775' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 13:30:35======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'woo5888' ========================2020-07-23 13:30:35======================== SELECT idx FROM macs WHERE mac_addr = '50AF7333D8D2EE2B1141' AND app_code = '047' ========================2020-07-23 13:30:35======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322492' ========================2020-07-23 13:30:35======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322492' ========================2020-07-23 13:30:35======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322492', '50AF7333D8D2EE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'woo5888', '우성기업[심보기]', '218720356775' ) ========================2020-07-23 15:42:16======================== noteurl_start parm_app_code = 046 parm_pc_name = USER-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 408D5CF010EA3203B26A sCDKey = 383211128661 sName = USER-PC ========================2020-07-23 15:42:16======================== 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 = '383211128661' AND r.app_code = '046' AND r.app_block = 0 ========================2020-07-23 15:42:17======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'osh1594' ========================2020-07-23 15:42:17======================== SELECT idx FROM macs WHERE mac_addr = '408D5CF010EA3203B26A' AND app_code = '046' ========================2020-07-23 15:42:17======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '274428' ========================2020-07-23 15:42:17======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '274428' ========================2020-07-23 15:42:17======================== UPDATE mac_detail SET pc_name = 'USER-PC', os_type = '90', user_id = 'osh1594', user_name = '대성철물공구[오승환]', screen_w = '1600', screen_h = '900', cdkey = '383211128661' WHERE mac_idx = '274428' ========================2020-07-23 16:15:22======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-QC6SF8K parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CF05D42E80F7AAEBDEA sCDKey = 186996244943 sName = DESKTOP-QC6SF8K ========================2020-07-23 16:15:22======================== 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 = '186996244943' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 16:15:22======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'manmul1212' ========================2020-07-23 16:15:22======================== SELECT idx FROM macs WHERE mac_addr = '2CF05D42E80F7AAEBDEA' AND app_code = '047' ========================2020-07-23 16:15:22======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322511' ========================2020-07-23 16:15:22======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322511' ========================2020-07-23 16:15:22======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '322511', '2CF05D42E80F7AAEBDEA', '047', 'DESKTOP-QC6SF8K', '�쐢�룄�슦 10', '0', '0', 'manmul1212', '주식회사만물종합상사[조선호]', '186996244943' ) ========================2020-07-23 16:26:20======================== noteurl_start parm_app_code = 047 parm_pc_name = DESKTOP-QC6SF8K parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 2CF05D42E80F7AAEBDEA sCDKey = 186996244943 sName = DESKTOP-QC6SF8K ========================2020-07-23 16:26: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 = '186996244943' AND r.app_code = '047' AND r.app_block = 0 ========================2020-07-23 16:26:20======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'manmul1212' ========================2020-07-23 16:26:20======================== SELECT idx FROM macs WHERE mac_addr = '2CF05D42E80F7AAEBDEA' AND app_code = '047' ========================2020-07-23 16:26:20======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '322511' ========================2020-07-23 16:26:20======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '322511' ========================2020-07-23 16:26:20======================== UPDATE mac_detail SET pc_name = 'DESKTOP-QC6SF8K', os_type = '�쐢�룄�슦 10', user_id = 'manmul1212', user_name = '주식회사만물종합상사[조선호]', screen_w = '0', screen_h = '0', cdkey = '186996244943' WHERE mac_idx = '322511'