========================2018-05-21 09:09:09======================== noteurl_start parm_app_code = 039 parm_pc_name = 락성골재 parm_os_type = 110 parm_screen_w = 1024 parm_screen_h = 819 parm_user_mac = 18CF5E2E24FFA6EF7DCA sCDKey = 794354550552 sName = 락성골재 ========================2018-05-21 09:09:09======================== 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 = '794354550552' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-21 09:09:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'nskim2002' ========================2018-05-21 09:09:09======================== SELECT idx FROM macs WHERE mac_addr = '18CF5E2E24FFA6EF7DCA' AND app_code = '039' ========================2018-05-21 09:09:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250142' ========================2018-05-21 09:09:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250142' ========================2018-05-21 09:09:09======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250142', '18CF5E2E24FFA6EF7DCA', '039', '락성골재', '110', '1024', '819', 'nskim2002', '충남상회[김낙성]', '794354550552' ) ========================2018-05-21 09:36:48======================== noteurl_start parm_app_code = 039 parm_pc_name = PCD-PC parm_os_type = 90 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = E0D55E95D9582E2E010C sCDKey = 244930003601 sName = PCD-PC ========================2018-05-21 09:36: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 = '244930003601' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-21 09:36:49======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdm4437' ========================2018-05-21 09:36:49======================== SELECT idx FROM macs WHERE mac_addr = 'E0D55E95D9582E2E010C' AND app_code = '039' ========================2018-05-21 09:36:49======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250064' ========================2018-05-21 09:36:49======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250064' ========================2018-05-21 09:36: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 ( '250064', 'E0D55E95D9582E2E010C', '039', 'PCD-PC', '90', '1600', '900', 'kdm4437', '(주)경동모터스[이동휘]', '244930003601' ) ========================2018-05-21 09:52:38======================== noteurl_start parm_app_code = 039 parm_pc_name = CCTV-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 1078D2D61E59C3598CF sCDKey = 395991747427 sName = CCTV-PC ========================2018-05-21 09:52: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 = '395991747427' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-21 09:52:38======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'haidal8871' ========================2018-05-21 09:52:38======================== SELECT idx FROM macs WHERE mac_addr = '1078D2D61E59C3598CF' AND app_code = '039' ========================2018-05-21 09:52:38======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250154' ========================2018-05-21 09:52:38======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250154' ========================2018-05-21 09:52:38======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '250154', '1078D2D61E59C3598CF', '039', 'CCTV-PC', '90', '1920', '1080', 'haidal8871', '해 달[윤정태]', '395991747427' ) ========================2018-05-21 15:09:37======================== noteurl_start parm_app_code = 039 parm_pc_name = STJ-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 003067BAEBDFB2760122 sCDKey = 679618733788 sName = STJ-PC ========================2018-05-21 15:09: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 = '679618733788' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-21 15:09:37======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'kdod123' ========================2018-05-21 15:09:37======================== SELECT idx FROM macs WHERE mac_addr = '003067BAEBDFB2760122' AND app_code = '039' ========================2018-05-21 15:09:37======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248781' ========================2018-05-21 15:09:37======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248781' ========================2018-05-21 15:09: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 ( '248781', '003067BAEBDFB2760122', '039', 'STJ-PC', '110', '1920', '1080', 'kdod123', '엠제이소프트[송태진]', '679618733788' ) ========================2018-05-21 16:57:04======================== noteurl_start parm_app_code = 039 parm_pc_name = HOME-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = C03FD5F77BC6CE6E2A59 sCDKey = 910769964287 sName = HOME-PC ========================2018-05-21 16:57:04======================== 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 = '910769964287' AND r.app_code = '039' AND r.app_block = 0 ========================2018-05-21 16:57:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'khg6238' ========================2018-05-21 16:57:04======================== SELECT idx FROM macs WHERE mac_addr = 'C03FD5F77BC6CE6E2A59' AND app_code = '039' ========================2018-05-21 16:57:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '166696' ========================2018-05-21 16:57:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '166696' ========================2018-05-21 16:57:04======================== UPDATE mac_detail SET pc_name = 'HOME-PC', os_type = '90', user_id = 'khg6238', user_name = '신양건설기계[김희곤]', screen_w = '1920', screen_h = '1080', cdkey = '910769964287' WHERE mac_idx = '166696' ========================2018-05-21 17:48:48======================== noteurl_start parm_app_code = 047 parm_pc_name = USER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732A22BE0A41C65F sCDKey = 245284890362 sName = USER-PC ========================2018-05-21 17:48: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 = '245284890362' AND r.app_code = '047' AND r.app_block = 0 ========================2018-05-21 17:48:48======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hskitchen' ========================2018-05-21 17:48:48======================== SELECT idx FROM macs WHERE mac_addr = '50AF732A22BE0A41C65F' AND app_code = '047' ========================2018-05-21 17:48:48======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '250224' ========================2018-05-21 17:48:48======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '250224' ========================2018-05-21 17:48: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 ( '250224', '50AF732A22BE0A41C65F', '047', 'USER-PC', '�쐢�룄�슦 7', '0', '0', 'hskitchen', '서광스텐[조한기]', '245284890362' ) ========================2018-05-21 17:49:01======================== noteurl_start parm_app_code = 047 parm_pc_name = USER-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 50AF732A22BE0A41C65F sCDKey = 245284890362 sName = USER-PC ========================2018-05-21 17:49: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 = '245284890362' AND r.app_code = '047' AND r.app_block = 0