Data Dump Help

[needabitofhelp]

We have recently moved away from ServiceNow to another ITSM provider.

I have a team of SQL dba's asking "how do we access the data"?

1. we cannot connect to the database, please see the below error:

I’m getting an error with companyname_sftpmig_lhr_CHGxxxxxx_key.sql:

CREATE TABLE `cmdb` ( `sys_class_name` varchar(80) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `asset_tag` varchar(40) DEFAULT NULL, `serial_number` varchar(255) DEFAULT NULL, `assigned_to` varchar(32) DEFAULT NULL, `company` varchar(32) DEFAULT NULL, `assigned` datetime DEFAULT NULL, `assignment_group` varchar(32) DEFAULT NULL, `install_status` int(11) DEFAULT NULL, `purchase_date` date DEFAULT NULL, `order_date` datetime DEFAULT NULL, `delivery_date` datetime DEFAULT NULL, `install_date` datetime DEFAULT NULL, `manufacturer` varchar(32) DEFAULT NULL, `vendor` varchar(32) DEFAULT NULL, `model_id` varchar(32) DEFAULT NULL, `justification` varchar(80) DEFAULT NULL, `location` varchar(32) DEFAULT NULL, `department` varchar(32) DEFAULT NULL, `lease_id` varchar(40) DEFAULT NULL, `warranty_expiration` date DEFAULT NULL, `po_number` varchar(40) DEFAULT NULL, `invoice_number` varchar(40) DEFAULT NULL, `gl_account` varchar(40) DEFAULT NULL, `cost` double(18,7) DEFAULT NULL, `cost_cc` varchar(3) DEFAULT NULL, `checked_in` datetime DEFAULT NULL, `checked_out` datetime DEFAULT NULL, `due` datetime DEFAULT NULL, `due_in` varchar(40) DEFAULT NULL, `support_group` varchar(32) DEFAULT NULL, `supported_by` varchar(32) DEFAULT NULL, `owned_by` varchar(32) DEFAULT NULL, `managed_by` varchar(32) DEFAULT NULL, `sys_domain` varchar(32) DEFAULT NULL, `sys_domain_path` varchar(255) DEFAULT NULL, `cost_center` varchar(32) DEFAULT NULL, `asset` varchar(32) DEFAULT NULL, `skip_sync` tinyint(1) DEFAULT NULL, `unverified` tinyint(1) DEFAULT NULL, `sys_id` char(32) NOT NULL, `sys_class_path` varchar(255) DEFAULT NULL, `sys_updated_by` varchar(40) DEFAULT NULL, `sys_updated_on` datetime DEFAULT NULL, `sys_created_by` varchar(40) DEFAULT NULL, `sys_created_on` datetime DEFAULT NULL, `sys_mod_count` int(11) DEFAULT NULL, `category` varchar(40) DEFAULT NULL, `subcategory` varchar(40) DEFAULT NULL, `operational_status` int(11) DEFAULT NULL, `fault_count` int(11) DEFAULT NULL, `model_number` varchar(255) DEFAULT NULL, `short_description` mediumtext DEFAULT NULL, `comments` mediumtext DEFAULT NULL, `discovery_source` varchar(40) DEFAULT NULL, `first_discovered` datetime DEFAULT NULL, `last_discovered` datetime DEFAULT NULL, `start_date` datetime DEFAULT NULL, `change_control` varchar(32) DEFAULT NULL, `monitor` tinyint(1) DEFAULT NULL, `attributes` mediumtext DEFAULT NULL, `ip_address` varchar(255) DEFAULT NULL, `mac_address` varchar(24) DEFAULT NULL, `can_print` tinyint(1) DEFAULT NULL, `correlation_id` mediumtext DEFAULT NULL, `dns_domain` varchar(255) DEFAULT NULL, `fqdn` varchar(255) DEFAULT NULL, `a_ref_1` varchar(32) DEFAULT NULL, `a_int_1` int(11) DEFAULT NULL, `a_str_1` varchar(255) DEFAULT NULL, `a_str_2` varchar(255) DEFAULT NULL, `a_str_3` varchar(255) DEFAULT NULL, `a_str_4` varchar(255) DEFAULT NULL, `a_str_5` varchar(255) DEFAULT NULL, `a_str_6` varchar(255) DEFAULT NULL, `a_str_7` mediumtext DEFAULT NULL, `a_str_8` mediumtext DEFAULT NULL, `a_str_9` varchar(255) DEFAULT NULL, `a_str_10` varchar(255) DEFAULT NULL, `a_str_11` varchar(100) DEFAULT NULL, `a_bln_1` tinyint(1) DEFAULT NULL, `a_str_12` varchar(255) DEFAULT NULL, `a_str_13` varchar(255) DEFAULT NULL, `a_str_14` varchar(255) DEFAULT NULL, `a_str_15` varchar(40) DEFAULT NULL, `a_int_2` int(11) DEFAULT NULL, `a_str_16` varchar(40) DEFAULT NULL, `a_ref_2` varchar(32) DEFAULT NULL, `a_int_3` bigint(20) DEFAULT NULL, `a_int_4` bigint(20) DEFAULT NULL, `a_ref_3` varchar(32) DEFAULT NULL, `dest_ip_network` varchar(32) DEFAULT NULL, `a_num_1` decimal(15,2) DEFAULT NULL, `a_num_2` decimal(15,2) DEFAULT NULL, `a_bln_2` tinyint(1) DEFAULT NULL, `a_bln_3` tinyint(1) DEFAULT NULL, `a_num_3` decimal(15,2) DEFAULT NULL, `a_bln_4` tinyint(1) DEFAULT NULL, `a_str_17` varchar(255) DEFAULT NULL, `a_str_18` varchar(255) DEFAULT NULL, `a_str_19` varchar(255) DEFAULT NULL, `a_str_20` varchar(255) DEFA... Error Code: 1069. Too many keys specified; max 64 keys allowed 0.000 sec

Any help would be appreciated.

Once we get access, how do we access all the incidents, requests, changes, problem data tickets etc?

[jorgefortes]

hello, have you managed to solve this issue?

[Bert_c1]

Good luck, the database dump does not include the proprietary database schema. Only the records.  Can be loaded in a new database using: 

mysql -u username -p database_name < file.sql

See:

https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/table-administ...

and

https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/table-administ...

To understand the proprietary database schema.  And the error above is for exceeded you database limit on indexes: 64.