Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Multi customer problem #2 https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6397 |
Page 1 of 1 |
Author: | sista [ Sun Jan 18, 2015 1:07 am ] |
Post subject: | Multi customer problem #2 |
I found other issue with my multi-customer installation. One of my customer has 9 computers: - srv-01 - srv-02 - nb-01 - nb-02 - pc-01 - pc-02 - pc-03 - pc-04 - pc-05 and I've created an Organization entry. If I view the entire organizzation I see: [attachment=0] Capture_1.PNG [ 22.71 KiB | Viewed 7776 times ] Where the computer pc-01 is absent (but exist in the system table), the pc-02 has 2 entry relative to system.system.id = 252 and 270, the nb-01 is absent and the pc-09 is from other Customer!!! mysql> select * from system where system_id=252\G *************************** 1. row *************************** system_id: 252 system_key: 18D6E960-1DD2-11B2-8000-94F0081E0FCA-nb-01 uuid: 18D6E960-1DD2-11B2-8000-94F0081E0FCA hostname: pc-02 domain: domainb.local fqdn: pc-02.domainb.local description: type: computer icon: windows_7 os_group: windows os_family: Windows 7 os_name: Microsoft Windows 7 Ultimate os_version: 6.1.7601 linked_sys: 0 serial: HR4R91GC400077 model: 900X3C/900X4C/900X4D manufacturer: SAMSUNG ELECTRONICS CO., LTD. uptime: 347427 form_factor: Laptop pc_os_bit: 64 pc_memory: 4194304 pc_num_processor: 2 pc_date_os_installation: 2012-10-22 printer_port_name: printer_shared: printer_shared_name: printer_color: printer_duplex: man_os_group: Windows man_os_family: Windows 7 man_os_name: Microsoft Windows 7 Professional man_domain: domaina.local man_status: production man_environment: production man_criticality: normal man_class: man_description: man_function: man_type: computer man_ip_address: 192.168.001.154 man_owner: man_org_id: 7 man_location_id: 0 man_location_level: man_location_suite: man_location_room: man_location_rack: man_location_rack_position: man_location_rack_size: 0 man_serial: HR4R91GC400077 man_asset_number: man_model: 900X3C/900X4C/900X4D man_manufacturer: SAMSUNG ELECTRONICS CO., LTD. man_form_factor: Laptop man_icon: windows_7 man_vm_server_name: man_vm_system_id: man_vm_group: man_cluster_name: invoice_id: NULL man_purchase_invoice: man_purchase_order_number: man_purchase_cost_center: man_purchase_vendor: man_purchase_date: 0000-00-00 man_purchase_amount: man_warranty_duration: 0 man_warranty_expires: 0000-00-00 man_warranty_type: man_terminal_number: 0 man_switch_id: man_switch_port: man_patch_panel: man_patch_panel_port: man_wall_port: man_picture: contact_name: contact_id: 0 man_service_number: man_service_provider: man_service_type: man_service_plan: man_service_network: man_unlock_pin: man_serial_imei: man_serial_sim: nmap_type: last_seen: 2015-01-17 12:04:39 last_seen_by: active directory last_user: access_details: snmp_oid: nmis_group: nmis_name: nmis_role: nmis_export: false system_key_type: uuho sysDescr: sysObjectID: sysUpTime: sysContact: sysName: sysLocation: timestamp: 2015-01-17 12:04:39 first_timestamp: 2015-01-11 12:00:03 mysql> select * from system where system_id=270\G *************************** 1. row *************************** system_id: 270 system_key: DDD37E00-51D9-11DF-82EB-485B39D225C2-pc-02 uuid: DDD37E00-51D9-11DF-82EB-485B39D225C2 hostname: pc-02 domain: domaina.local fqdn: pc-02.domaina.local description: type: computer icon: windows_7 os_group: Windows os_family: Windows 7 os_name: Microsoft Windows 7 Professional os_version: 6.1.7601 linked_sys: 0 serial: System Serial Number model: System Product Name manufacturer: System manufacturer uptime: 197590 form_factor: Desktop pc_os_bit: 64 pc_memory: 4194304 pc_num_processor: 2 pc_date_os_installation: 2011-04-20 printer_port_name: printer_shared: printer_shared_name: printer_color: printer_duplex: man_os_group: Windows man_os_family: Windows 7 man_os_name: Microsoft Windows 7 Professional man_domain: domaina.local man_status: production man_environment: production man_criticality: normal man_class: man_description: man_function: man_type: computer man_ip_address: 192.168.001.155 man_owner: man_org_id: 7 man_location_id: 0 man_location_level: man_location_suite: man_location_room: man_location_rack: man_location_rack_position: man_location_rack_size: 0 man_serial: System Serial Number man_asset_number: man_model: System Product Name man_manufacturer: System manufacturer man_form_factor: Desktop man_icon: windows_7 man_vm_server_name: man_vm_system_id: man_vm_group: man_cluster_name: invoice_id: NULL man_purchase_invoice: man_purchase_order_number: man_purchase_cost_center: man_purchase_vendor: man_purchase_date: 0000-00-00 man_purchase_amount: man_warranty_duration: 0 man_warranty_expires: 0000-00-00 man_warranty_type: man_terminal_number: 0 man_switch_id: man_switch_port: man_patch_panel: man_patch_panel_port: man_wall_port: man_picture: contact_name: contact_id: 0 man_service_number: man_service_provider: man_service_type: man_service_plan: man_service_network: man_unlock_pin: man_serial_imei: man_serial_sim: nmap_type: last_seen: 2015-01-16 16:00:06 last_seen_by: audit last_user: access_details: snmp_oid: nmis_group: nmis_name: nmis_role: nmis_export: false system_key_type: uuho sysDescr: sysObjectID: sysUpTime: sysContact: sysName: sysLocation: timestamp: 2015-01-16 16:00:06 first_timestamp: 2015-01-11 12:00:04 Both the entity has the same man_org_id (wrong), the id 252 ha domain=domainb.local and man_domain=domaina.local (wrong), the id 252 have form_factor=Laptop (right) and the system_key=xxxxx-nb-01 (right) but the hostname=pc-02 (wrong).. It seem that the software have the old problem of updating the wrong system_id. Do you want other information Mark? Besta Regards Andrea |
Page 1 of 1 | All times are UTC + 10 hours |
Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |