========================2019-01-09 11:19:43======================== noteurl_start parm_app_code = 039 parm_pc_name = MAGNUT parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = D05349C9C711CC578EC0 sCDKey = 055886452504 sName = MAGNUT ========================2019-01-09 11:19: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 = '055886452504' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-09 11:19:43======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'daddyshi' ========================2019-01-09 11:19:43======================== SELECT idx FROM macs WHERE mac_addr = 'D05349C9C711CC578EC0' AND app_code = '039' ========================2019-01-09 11:19:43======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '173089' ========================2019-01-09 11:19:43======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '173089' ========================2019-01-09 11:19:43======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '173089', 'D05349C9C711CC578EC0', '039', 'MAGNUT', '110', '1920', '1080', 'daddyshi', '삼부치과상사[김영민]', '055886452504' ) ========================2019-01-09 13:19:58======================== noteurl_start parm_app_code = 046 parm_pc_name = HHY-PC parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = F44D30B9B7922E87FB70 sCDKey = 108094650671 sName = HHY-PC ========================2019-01-09 13:19: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 = '108094650671' AND r.app_code = '046' AND r.app_block = 0 ========================2019-01-09 13:19:58======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'a09sang' ========================2019-01-09 13:19:58======================== SELECT idx FROM macs WHERE mac_addr = 'F44D30B9B7922E87FB70' AND app_code = '046' ========================2019-01-09 13:19:58======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '248431' ========================2019-01-09 13:19:58======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '248431' ========================2019-01-09 13:19:58======================== UPDATE mac_detail SET pc_name = 'HHY-PC', os_type = '110', user_id = 'a09sang', user_name = '(주)거상[장동익]', screen_w = '1920', screen_h = '1080', cdkey = '108094650671' WHERE mac_idx = '248431' ========================2019-01-09 14:05:03======================== 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 = 50AF732D71DEEE2B1141 sCDKey = 171473565682 sName = DESKTOP-IR4BE71 ========================2019-01-09 14:05: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 = '171473565682' AND r.app_code = '047' AND r.app_block = 0 ========================2019-01-09 14:05:03======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'dh3656' ========================2019-01-09 14:05:03======================== SELECT idx FROM macs WHERE mac_addr = '50AF732D71DEEE2B1141' AND app_code = '047' ========================2019-01-09 14:05:03======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273549' ========================2019-01-09 14:05:03======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273549' ========================2019-01-09 14:05:03======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273549', '50AF732D71DEEE2B1141', '047', 'DESKTOP-IR4BE71', '�쐢�룄�슦 10', '0', '0', 'dh3656', '대흥종합기계[노정현]', '171473565682' ) ========================2019-01-09 15:31:05======================== noteurl_start parm_app_code = 039 parm_pc_name = USER1 parm_os_type = 110 parm_screen_w = 1600 parm_screen_h = 900 parm_user_mac = 50B7C3AB80D69C3213EB sCDKey = 298285370939 sName = USER1 ========================2019-01-09 15:31: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 = '298285370939' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-09 15:31:05======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'ki4724' ========================2019-01-09 15:31:05======================== SELECT idx FROM macs WHERE mac_addr = '50B7C3AB80D69C3213EB' AND app_code = '039' ========================2019-01-09 15:31:05======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '134669' ========================2019-01-09 15:31:05======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '134669' ========================2019-01-09 15:31:05======================== UPDATE mac_detail SET pc_name = 'USER1', os_type = '110', user_id = 'ki4724', user_name = '경일포장[배재호]', screen_w = '1600', screen_h = '900', cdkey = '298285370939' WHERE mac_idx = '134669' ========================2019-01-09 15:47:44======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-09 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0024D71555D070506F82 sCDKey = 683156263623 sName = HBDS-09 ========================2019-01-09 15:47: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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-09 15:47:44======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2019-01-09 15:47:44======================== SELECT idx FROM macs WHERE mac_addr = '0024D71555D070506F82' AND app_code = '039' ========================2019-01-09 15:47:44======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273564' ========================2019-01-09 15:47:44======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273564' ========================2019-01-09 15:47:44======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273564', '0024D71555D070506F82', '039', 'HBDS-09', '90', '1920', '1080', 'bangchun', '한반도[이진석]', '683156263623' ) ========================2019-01-09 15:47:47======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-09 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 0024D71555D070506F82 sCDKey = 683156263623 sName = HBDS-09 ========================2019-01-09 15:47:47======================== 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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-09 15:50:32======================== noteurl_start parm_app_code = 039 parm_pc_name = MSDN-SPECIAL parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = B42E991F689E20D53ACE sCDKey = 320550890604 sName = 제이원 ========================2019-01-09 15:50:32======================== 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 = '320550890604' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-09 15:50:32======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'jwon' ========================2019-01-09 15:50:32======================== SELECT idx FROM macs WHERE mac_addr = 'B42E991F689E20D53ACE' AND app_code = '039' ========================2019-01-09 15:50:32======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273568' ========================2019-01-09 15:50:32======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273568' ========================2019-01-09 15:50:32======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273568', 'B42E991F689E20D53ACE', '039', '제이원', '90', '1920', '1080', 'jwon', '제이원[태재원]', '320550890604' ) ========================2019-01-09 16:14:19======================== noteurl_start parm_app_code = 039 parm_pc_name = HBDS-01 parm_os_type = 110 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 28E347DBE419AEEC6878 sCDKey = 683156263623 sName = HBDS-01 ========================2019-01-09 16:14:19======================== 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 = '683156263623' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-09 16:14:19======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'bangchun' ========================2019-01-09 16:14:19======================== SELECT idx FROM macs WHERE mac_addr = '28E347DBE419AEEC6878' AND app_code = '039' ========================2019-01-09 16:14:19======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '219051' ========================2019-01-09 16:14:19======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '219051' ========================2019-01-09 16:14:19======================== UPDATE mac_detail SET pc_name = 'HBDS-01', os_type = '110', user_id = 'bangchun', user_name = '한반도[이진석]', screen_w = '1920', screen_h = '1080', cdkey = '683156263623' WHERE mac_idx = '219051' ========================2019-01-09 16:46:23======================== noteurl_start parm_app_code = 048 parm_pc_name = HANSOL2-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 909F33EFB27E9C792E63 sCDKey = 062903590411 sName = HANSOL2-PC ========================2019-01-09 16:46:23======================== 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 = '062903590411' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-09 16:46:23======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hansol22910' ========================2019-01-09 16:46:23======================== SELECT idx FROM macs WHERE mac_addr = '909F33EFB27E9C792E63' AND app_code = '048' ========================2019-01-09 16:46:23======================== 값이 없을 경우 ========================2019-01-09 16:46:55======================== noteurl_start parm_app_code = 048 parm_pc_name = HANSOL2-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 909F33EFB27E9C792E63 sCDKey = 062903590411 sName = HANSOL2-PC ========================2019-01-09 16:46: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 = '062903590411' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-09 16:46:55======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hansol22910' ========================2019-01-09 16:46:55======================== SELECT idx FROM macs WHERE mac_addr = '909F33EFB27E9C792E63' AND app_code = '048' ========================2019-01-09 16:46:55======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273582' ========================2019-01-09 16:46:55======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273582' ========================2019-01-09 16:46: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 ( '273582', '909F33EFB27E9C792E63', '048', 'HANSOL2-PC', '�쐢�룄�슦 7', '0', '0', 'hansol22910', '한솔만물상[김강식]', '062903590411' ) ========================2019-01-09 16:49:16======================== noteurl_start parm_app_code = 048 parm_pc_name = HANSOL2-PC parm_os_type = �쐢�룄�슦 7 parm_screen_w = 0 parm_screen_h = 0 parm_user_mac = 909F33EFB27E9C792E63 sCDKey = 062903590411 sName = HANSOL2-PC ========================2019-01-09 16:49: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 = '062903590411' AND r.app_code = '048' AND r.app_block = 0 ========================2019-01-09 16:49:16======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hansol22910' ========================2019-01-09 16:49:16======================== SELECT idx FROM macs WHERE mac_addr = '909F33EFB27E9C792E63' AND app_code = '048' ========================2019-01-09 16:49:16======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273582' ========================2019-01-09 16:49:16======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273582' ========================2019-01-09 16:49:16======================== UPDATE mac_detail SET pc_name = 'HANSOL2-PC', os_type = '�쐢�룄�슦 7', user_id = 'hansol22910', user_name = '한솔만물상[김강식]', screen_w = '0', screen_h = '0', cdkey = '062903590411' WHERE mac_idx = '273582' ========================2019-01-09 17:00:52======================== noteurl_start parm_app_code = 039 parm_pc_name = PC01 parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = 382C4A5FE91C4BF5AE0 sCDKey = 080572794337 sName = PC01 ========================2019-01-09 17:00:52======================== 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 = '080572794337' AND r.app_code = '039' AND r.app_block = 0 ========================2019-01-09 17:00:52======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'gwangjin' ========================2019-01-09 17:00:52======================== SELECT idx FROM macs WHERE mac_addr = '382C4A5FE91C4BF5AE0' AND app_code = '039' ========================2019-01-09 17:00:52======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '273583' ========================2019-01-09 17:00:52======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '273583' ========================2019-01-09 17:00:52======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '273583', '382C4A5FE91C4BF5AE0', '039', 'PC01', '90', '1920', '1080', 'gwangjin', '광진종합상사[양혜원]', '080572794337' ) ========================2019-01-09 17:51:34======================== noteurl_start parm_app_code = 050 parm_pc_name = AERIPARK-PC parm_os_type = 90 parm_screen_w = 1920 parm_screen_h = 1080 parm_user_mac = BC5FF4D2889502A8FE42 sCDKey = 341338943409 sName = AERIPARK-PC ========================2019-01-09 17:51: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 = '341338943409' AND r.app_code = '050' AND r.app_block = 0 ========================2019-01-09 17:51:34======================== SELECT CONCAT(Mcompany,'[', Mname,']') FROM member WHERE MID = 'hisco' ========================2019-01-09 17:51:34======================== SELECT idx FROM macs WHERE mac_addr = 'BC5FF4D2889502A8FE42' AND app_code = '050' ========================2019-01-09 17:51:34======================== UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '270074' ========================2019-01-09 17:51:34======================== SELECT mac_idx FROM mac_detail WHERE mac_idx = '270074' ========================2019-01-09 17:51:34======================== INSERT INTO mac_detail ( mac_idx, mac_addr, app_code, pc_name, os_type, screen_w, screen_h, user_id, user_name , cdkey ) VALUES ( '270074', 'BC5FF4D2889502A8FE42', '050', 'AERIPARK-PC', '90', '1920', '1080', 'hisco', '(주)혁산정보시스템[전세원]', '341338943409' )