Open-AudIT
http://www.open-audit.org/phpBB3/

Multi customer problem #2
http://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:
Capture_1.PNG
Capture_1.PNG [ 22.71 KiB | Viewed 4876 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/