1
0
-1
4 answers
- 10-1
Hi Mark,
thanks for your answer. That solved my problem. Maybe for a future version you could add also the possibility to add the additional fields to the XML.
Thanks again mate,
greetings from Austria without kangaroos
Add your comment... - 10-1
Hi Phillip,
Anything in the system table can be an attribute in the sys section of the XML.
One note. Columns in the system table with a preceding man_ name are meant for display by the web interface (and yes, can be populated using the XML audit result).
The system table definition is below.
CREATE TABLE `system` ( `system_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `system_key` varchar(200) NOT NULL DEFAULT '', `uuid` varchar(100) NOT NULL DEFAULT '', `hostname` varchar(100) NOT NULL DEFAULT '', `domain` varchar(100) NOT NULL DEFAULT '', `fqdn` text NOT NULL, `description` text NOT NULL, `type` varchar(50) NOT NULL DEFAULT '', `icon` varchar(50) NOT NULL DEFAULT '', `os_group` varchar(50) NOT NULL DEFAULT '', `os_family` varchar(50) NOT NULL DEFAULT '', `os_name` varchar(100) NOT NULL DEFAULT '', `os_version` varchar(50) NOT NULL DEFAULT '', `linked_sys` int(10) NOT NULL DEFAULT '0', `serial` varchar(200) NOT NULL DEFAULT '', `model` varchar(200) NOT NULL DEFAULT '', `manufacturer` varchar(50) NOT NULL DEFAULT '', `uptime` varchar(50) NOT NULL DEFAULT '', `form_factor` varchar(50) NOT NULL DEFAULT '', `pc_os_bit` varchar(3) NOT NULL DEFAULT '', `pc_memory` int(10) NOT NULL DEFAULT '0', `pc_num_processor` int(10) NOT NULL DEFAULT '0', `pc_date_os_installation` date NOT NULL DEFAULT '0000-00-00', `printer_port_name` varchar(50) NOT NULL DEFAULT '', `printer_shared` varchar(50) NOT NULL DEFAULT '', `printer_shared_name` varchar(50) NOT NULL DEFAULT '', `printer_color` varchar(5) NOT NULL DEFAULT '', `printer_duplex` varchar(5) NOT NULL DEFAULT '', `man_os_group` varchar(50) NOT NULL DEFAULT '', `man_os_family` varchar(50) NOT NULL DEFAULT '', `man_os_name` varchar(100) NOT NULL DEFAULT '', `man_domain` varchar(100) NOT NULL DEFAULT '', `man_status` enum('production','deleted','lost','maintenance','retired','unallocated') NOT NULL DEFAULT 'production', `man_environment` enum('production','dev','dr','eval','pre-prod','test','train','uat') NOT NULL DEFAULT 'production', `man_criticality` enum('critical','normal','low') NOT NULL DEFAULT 'normal', `man_class` enum('desktop','laptop','tablet','workstation','server','virtual server','virtual desktop','','hypervisor') NOT NULL DEFAULT '', `man_description` text NOT NULL, `man_function` varchar(100) NOT NULL DEFAULT '', `man_type` varchar(100) NOT NULL DEFAULT '', `man_ip_address` varchar(30) NOT NULL DEFAULT '', `man_owner` varchar(100) NOT NULL DEFAULT '', `man_org_id` int(10) unsigned NOT NULL DEFAULT '0', `man_location_id` int(10) unsigned NOT NULL DEFAULT '0', `man_location_level` varchar(100) NOT NULL DEFAULT '', `man_location_suite` varchar(100) NOT NULL DEFAULT '', `man_location_room` varchar(100) NOT NULL DEFAULT '', `man_location_rack` varchar(100) NOT NULL DEFAULT '', `man_location_rack_position` varchar(100) NOT NULL DEFAULT '', `man_location_rack_size` int(10) unsigned NOT NULL DEFAULT '0', `man_location_latitude` float(10,6) NOT NULL, `man_location_longitude` float(10,6) NOT NULL, `man_serial` varchar(200) NOT NULL DEFAULT '', `man_asset_number` varchar(50) NOT NULL DEFAULT '', `man_model` varchar(50) NOT NULL DEFAULT '', `man_manufacturer` varchar(50) NOT NULL DEFAULT '', `man_form_factor` varchar(50) NOT NULL DEFAULT '', `man_icon` varchar(50) NOT NULL DEFAULT '', `man_vm_server_name` varchar(150) NOT NULL DEFAULT '', `man_vm_system_id` varchar(150) NOT NULL DEFAULT '', `man_vm_group` varchar(150) NOT NULL DEFAULT '', `man_cluster_name` varchar(150) NOT NULL DEFAULT '', `invoice_id` int(10) unsigned DEFAULT NULL, `man_purchase_invoice` varchar(50) NOT NULL DEFAULT '', `man_purchase_order_number` varchar(50) NOT NULL DEFAULT '', `man_purchase_cost_center` varchar(50) NOT NULL DEFAULT '', `man_purchase_vendor` varchar(100) NOT NULL DEFAULT '', `man_purchase_date` date NOT NULL DEFAULT '0000-00-00', `man_purchase_service_contract_number` varchar(255) NOT NULL DEFAULT '', `man_lease_expiry_date` date NOT NULL DEFAULT '0000-00-00', `man_purchase_amount` varchar(50) NOT NULL DEFAULT '', `man_warranty_duration` int(5) unsigned NOT NULL DEFAULT '0', `man_warranty_expires` date NOT NULL DEFAULT '0000-00-00', `man_warranty_type` enum('','24x7x365','9x5x5','Next Business Day') NOT NULL DEFAULT '', `man_terminal_number` int(10) NOT NULL DEFAULT '0', `man_switch_id` varchar(100) NOT NULL DEFAULT '', `man_switch_port` varchar(100) NOT NULL DEFAULT '', `man_patch_panel` varchar(45) NOT NULL DEFAULT '', `man_patch_panel_port` varchar(45) NOT NULL DEFAULT '', `man_wall_port` varchar(100) NOT NULL DEFAULT '', `man_picture` varchar(100) NOT NULL DEFAULT '', `contact_name` varchar(50) NOT NULL DEFAULT '', `contact_id` int(10) unsigned NOT NULL DEFAULT '0', `man_service_number` varchar(100) NOT NULL DEFAULT '', `man_service_provider` varchar(100) NOT NULL DEFAULT '', `man_service_type` varchar(100) NOT NULL DEFAULT '', `man_service_plan` varchar(100) NOT NULL DEFAULT '', `man_service_network` varchar(100) NOT NULL DEFAULT '', `man_unlock_pin` varchar(100) NOT NULL DEFAULT '', `man_serial_imei` varchar(100) NOT NULL DEFAULT '', `man_serial_sim` varchar(100) NOT NULL DEFAULT '', `nmap_type` varchar(50) NOT NULL DEFAULT '', `last_seen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_seen_by` varchar(150) NOT NULL DEFAULT '', `last_user` varchar(150) NOT NULL DEFAULT '', `access_details` text NOT NULL, `snmp_oid` text NOT NULL, `nmis_group` varchar(50) NOT NULL DEFAULT '', `nmis_name` varchar(50) NOT NULL DEFAULT '', `nmis_role` varchar(50) NOT NULL DEFAULT '', `nmis_export` enum('true','false') NOT NULL DEFAULT 'false', `system_key_type` varchar(4) NOT NULL DEFAULT '', `sysDescr` text NOT NULL, `sysObjectID` varchar(255) NOT NULL DEFAULT '', `sysUpTime` varchar(255) NOT NULL DEFAULT '', `sysContact` varchar(255) NOT NULL DEFAULT '', `sysName` varchar(255) NOT NULL DEFAULT '', `sysLocation` varchar(255) NOT NULL DEFAULT '', `man_oae_manage` enum('y','n') NOT NULL DEFAULT 'y', `timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `first_timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`system_id`), KEY `id` (`timestamp`), KEY `id2` (`system_key`), KEY `id3` (`man_ip_address`), KEY `system_id` (`system_id`), KEY `hostname` (`hostname`), KEY `linked_sys` (`linked_sys`), KEY `system_key` (`system_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;Add your comment... - 10-1
Hi Mark,
thanks for your answer. My current idea is, to have the possibility to add a custom field and fill it via the audit-XML files. So to have a generic possibility to add a custom field and also use it in the XML upload from the computers.
I will look into the code if I am able to come up with a patch.
Add your comment... - 10-1
Hi Phillip,
To use Cisco CDP you will need an agent running on your server (or all your machines). Do you have this installed? We should absolutely be able to produce something to extract this if it's installed.
Our NMIS product already contacts this feature (it can use CDP). It may well be worth your time checking it out
https://opmantek.com/network-management-system-nmis/We have a virtual machine all configured and ready to run which contains both products, you can download it from here - https://opmantek.com/network-tools-download/
Add your comment...
Hi,
Sorry if this is a no-brainer, but I didn't find the answer.
We would like to use the Cisco Discovery Protocol (CDP) on the Clients we run the audit_windows.vbs or audit_linux.sh script to get the switchport the device is connected to.
I added an additional field where I want to store the information. Is there a way to specify the data in the XML we send to the server, so the server will automatically store the data in the custom field?
thanks
Philipp