========================2019-08-01 10:42:44======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-L77HKCES parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C06320524153DAABD761 sCDKey = 917325696225 sName = LAPTOP-L77HKCES ========================2019-08-01 10:42: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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 10:42:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bovitex' ========================2019-08-01 10:42:44======================== SELECT idx FROM macs WHERE mac_addr = 'C06320524153DAABD761' AND app_code = '039' ========================2019-08-01 10:42:44======================== 값이 없을 경우 ========================2019-08-01 10:42:54======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-L77HKCES parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C06320524153DAABD761 sCDKey = 917325696225 sName = LAPTOP-L77HKCES ========================2019-08-01 10:42:54======================== 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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 10:42:54======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bovitex' ========================2019-08-01 10:42:54======================== SELECT idx FROM macs WHERE mac_addr = 'C06320524153DAABD761' AND app_code = '039' ========================2019-08-01 10:42:54======================== 값이 없을 경우 ========================2019-08-01 10:43:41======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-L77HKCES parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C06320524153DAABD761 sCDKey = 917325696225 sName = LAPTOP-L77HKCES ========================2019-08-01 10:43:41======================== 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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 10:43:41======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bovitex' ========================2019-08-01 10:43:41======================== SELECT idx FROM macs WHERE mac_addr = 'C06320524153DAABD761' AND app_code = '039' ========================2019-08-01 10:43:41======================== 값이 없을 경우 ========================2019-08-01 10:44:00======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-L77HKCES parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C06320524153DAABD761 sCDKey = 917325696225 sName = LAPTOP-L77HKCES ========================2019-08-01 10:44:00======================== 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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 10:44:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bovitex' ========================2019-08-01 10:44:00======================== SELECT idx FROM macs WHERE mac_addr = 'C06320524153DAABD761' AND app_code = '039' ========================2019-08-01 10:44:00======================== 값이 없을 경우 ========================2019-08-01 10:45:58======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-L77HKCES parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C06320524153DAABD761 sCDKey = 917325696225 sName = LAPTOP-L77HKCES ========================2019-08-01 10:45:58======================== 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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 10:45:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bovitex' ========================2019-08-01 10:45:58======================== SELECT idx FROM macs WHERE mac_addr = 'C06320524153DAABD761' AND app_code = '039' ========================2019-08-01 10:45:58======================== 값이 없을 경우 ========================2019-08-01 10:48:05======================== noteurl_start parm_app_code = 039 parm_pc_name = LAPTOP-L77HKCES parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C06320524153DAABD761 sCDKey = 917325696225 sName = LAPTOP-L77HKCES ========================2019-08-01 10:48:05======================== 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 = '917325696225' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 10:48:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bovitex' ========================2019-08-01 10:48:05======================== SELECT idx FROM macs WHERE mac_addr = 'C06320524153DAABD761' AND app_code = '039' ========================2019-08-01 10:48:05======================== 값이 없을 경우 ========================2019-08-01 10:57:24======================== noteurl_start parm_app_code = 047 parm_pc_name = ADMINISTRATOR parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = B8975AFA9055942362F3 sCDKey = 749447224532 sName = ADMINISTRATOR ========================2019-08-01 10:57: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 = '749447224532' AND r.app_code = '047' AND r.app_block = 0 ========================2019-08-01 10:57:24======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nexus' ========================2019-08-01 10:57:24======================== SELECT idx FROM macs WHERE mac_addr = 'B8975AFA9055942362F3' AND app_code = '047' ========================2019-08-01 10:57:24======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292185' ========================2019-08-01 10:57:24======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292185' ========================2019-08-01 10:57:24======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292185', 'B8975AFA9055942362F3', '047', 'ADMINISTRATOR', '�쐢�룄�슦 7', '0', '0', 'nexus', '넥서스메디케어[박종국]', '749447224532' ) ========================2019-08-01 14:47:48======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-GUNRGNU parm_os_type = 109 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = A08CFDDC85DC1E60F3C4 sCDKey = 362230354924 sName = DESKTOP-GUNRGNU ========================2019-08-01 14:47:48======================== 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 = '362230354924' AND r.app_code = '050' AND r.app_block = 0 ========================2019-08-01 14:47:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'emforce2287' ========================2019-08-01 14:47:48======================== SELECT idx FROM macs WHERE mac_addr = 'A08CFDDC85DC1E60F3C4' AND app_code = '050' ========================2019-08-01 14:47:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292206' ========================2019-08-01 14:47:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292206' ========================2019-08-01 14:47:48======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292206', 'A08CFDDC85DC1E60F3C4', '050', 'DESKTOP-GUNRGNU', '109', '1920', '1080', 'emforce2287', '(주)엠포스[김재영]', '362230354924' ) ========================2019-08-01 15:10:49======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G3MGT57 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28A8471FA120397 sCDKey = 980807696313 sName = DESKTOP-G3MGT57 ========================2019-08-01 15:10: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 = '980807696313' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 15:11:48======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G3MGT57 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28A8471FA120397 sCDKey = 980807696313 sName = DESKTOP-G3MGT57 ========================2019-08-01 15:11:48======================== 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 = '980807696313' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 15:12:21======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G3MGT57 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28A8471FA120397 sCDKey = 980807696313 sName = 바디야건강 ========================2019-08-01 15:12: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 = '980807696313' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 15:13:46======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G3MGT57 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28A8471FA120397 sCDKey = 980807696313 sName = 바디야건강 ========================2019-08-01 15:13: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 = '980807696313' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 15:15:33======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-G3MGT57 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 7085C28A8471FA120397 sCDKey = 980807696313 sName = 바디야건강 ========================2019-08-01 15:15:33======================== 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 = '980807696313' AND r.app_code = '039' AND r.app_block = 0 ========================2019-08-01 15:15:33======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bodyya' ========================2019-08-01 15:15:33======================== SELECT idx FROM macs WHERE mac_addr = '7085C28A8471FA120397' AND app_code = '039' ========================2019-08-01 15:15:33======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '292215' ========================2019-08-01 15:15:33======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '292215' ========================2019-08-01 15:15:33======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '292215', '7085C28A8471FA120397', '039', '바디야건강', '110', '1920', '1080', 'bodyya', '바디야건강[이혁]', '980807696313' )