========================2018-03-23 10:01:04======================== noteurl_start parm_app_code = 039 parm_pc_name = DESKTOP-S1ACD8T parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 00089FF4E3D052A35DDE sCDKey = 362398282645 sName = DESKTOP-S1ACD8T ========================2018-03-23 10:01: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 = '362398282645' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-23 10:01:04======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'k970919' ========================2018-03-23 10:01:04======================== SELECT idx FROM macs WHERE mac_addr = '00089FF4E3D052A35DDE' AND app_code = '039' ========================2018-03-23 10:01:04======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245258' ========================2018-03-23 10:01:04======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245258' ========================2018-03-23 10:01:04======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245258', '00089FF4E3D052A35DDE', '039', 'DESKTOP-S1ACD8T', '110', '1600', '900', 'k970919', '신도[김병철]', '362398282645' ) ========================2018-03-23 13:28:50======================== noteurl_start parm_app_code = 046 parm_pc_name = A02-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAD594743AF6C411 sCDKey = 369853832250 sName = A02-PC ========================2018-03-23 13:28: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 = '369853832250' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-23 13:29:09======================== noteurl_start parm_app_code = 046 parm_pc_name = A02-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 24F5AAD594743AF6C411 sCDKey = 369853832250 sName = A02-PC ========================2018-03-23 13:29: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 = '369853832250' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-23 13:29:09======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gijang09' ========================2018-03-23 13:29:09======================== SELECT idx FROM macs WHERE mac_addr = '24F5AAD594743AF6C411' AND app_code = '046' ========================2018-03-23 13:29:09======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245279' ========================2018-03-23 13:29:09======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245279' ========================2018-03-23 13:29: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 ( '245279', '24F5AAD594743AF6C411', '046', 'A02-PC', '90', '1920', '1080', 'gijang09', '기장종합공구[신성진]', '369853832250' ) ========================2018-03-23 14:41:00======================== noteurl_start parm_app_code = 050 parm_pc_name = DESKTOP-7OJHSON parm_os_type = 109 parm_screen_w = 1366 parm_screen_h = 768 parm_user_mac = 74C63B33C4F5BE63066E sCDKey = 126502428795 sName = DESKTOP-7OJHSON ========================2018-03-23 14:41: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 = '126502428795' AND r.app_code = '050' AND r.app_block = 0 ========================2018-03-23 14:41:00======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dansung' ========================2018-03-23 14:41:00======================== SELECT idx FROM macs WHERE mac_addr = '74C63B33C4F5BE63066E' AND app_code = '050' ========================2018-03-23 14:41:00======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245296' ========================2018-03-23 14:41:00======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245296' ========================2018-03-23 14:41:00======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245296', '74C63B33C4F5BE63066E', '050', 'DESKTOP-7OJHSON', '109', '1366', '768', 'dansung', '(주)단성[김연규]', '126502428795' ) ========================2018-03-23 15:38:13======================== noteurl_start parm_app_code = 048 parm_pc_name = IMHG parm_os_type = �쐢�룄�슦 10 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = F44D30B9AF0E96D60F97 sCDKey = 493095055925 sName = IMHG ========================2018-03-23 15:38:13======================== 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 = '493095055925' AND r.app_code = '048' AND r.app_block = 0 ========================2018-03-23 15:38:13======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'novasix' ========================2018-03-23 15:38:13======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9AF0E96D60F97' AND app_code = '048' ========================2018-03-23 15:38:13======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '239172' ========================2018-03-23 15:38:13======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '239172' ========================2018-03-23 15:38:13======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '239172', 'F44D30B9AF0E96D60F97', '048', 'IMHG', '�쐢�룄�슦 10', '0', '0', 'novasix', 'MJ소프트[여욱동]', '493095055925' ) ========================2018-03-23 16:09:08======================== noteurl_start parm_app_code = 046 parm_pc_name = 송영훈-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B7BFA6AF825E sCDKey = 069675455873 sName = 송영훈-PC ========================2018-03-23 16: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 = '069675455873' AND r.app_code = '046' AND r.app_block = 0 ========================2018-03-23 16:09:08======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'mailo7' ========================2018-03-23 16:09:08======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7BFA6AF825E' AND app_code = '046' ========================2018-03-23 16:09:08======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '222430' ========================2018-03-23 16:09:08======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '222430' ========================2018-03-23 16:09:08======================== UPDATE mac_detail SET pc_name = '송영훈-PC', os_type = '110', user_id = 'mailo7', user_name = '송영훈[송영훈]', screen_w = '1920', screen_h = '1080', cdkey = '069675455873' WHERE mac_idx = '222430' ========================2018-03-23 17:31:27======================== noteurl_start parm_app_code = 039 parm_pc_name = MINSUN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDF7FDD020D1DA36 sCDKey = 602903636174 sName = MINSUN ========================2018-03-23 17:31: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 = '602903636174' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-23 17:31:27======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'minsunmall' ========================2018-03-23 17:31:27======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDF7FDD020D1DA36' AND app_code = '039' ========================2018-03-23 17:31:27======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245316' ========================2018-03-23 17:31:27======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245316' ========================2018-03-23 17:31:27======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '245316', 'B8AEEDF7FDD020D1DA36', '039', 'MINSUN', '110', '1920', '1080', 'minsunmall', '민선종합상사[박종성]', '602903636174' ) ========================2018-03-23 17:50:11======================== noteurl_start parm_app_code = 039 parm_pc_name = MINSUN parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B8AEEDF7FDD020D1DA36 sCDKey = 474740641298 sName = MINSUN ========================2018-03-23 17:50:11======================== 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 = '474740641298' AND r.app_code = '039' AND r.app_block = 0 ========================2018-03-23 17:50:11======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'minsunjs' ========================2018-03-23 17:50:11======================== SELECT idx FROM macs WHERE mac_addr = 'B8AEEDF7FDD020D1DA36' AND app_code = '039' ========================2018-03-23 17:50:11======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '245316' ========================2018-03-23 17:50:11======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '245316' ========================2018-03-23 17:50:11======================== UPDATE mac_detail SET pc_name = 'MINSUN', os_type = '110', user_id = 'minsunjs', user_name = '해피랜드[박종성]', screen_w = '1920', screen_h = '1080', cdkey = '474740641298' WHERE mac_idx = '245316'