Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 2:54 am

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
PostPosted: Sun Jan 18, 2015 1:07 am 
Offline
Newbie

Joined: Wed Jul 31, 2013 6:50 am
Posts: 9
Location: Italy
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
Capture_1.PNG [ 22.71 KiB | Viewed 7745 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

Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group