This Connector can be used to retrieve and update data from ServiceNow
The use of this tool is at users own risk. The user understands that Scope4mation is not responsible nor liable for any damages, unexpected results, costs or any other effect that might occur as a result of using this tool.
Download the software from here
Extract the software from the zip file. Once the extraction is done, you need to configure the config.json file located next to the executable SNIC.exe.
To use the software you need a license. Contact support when you don't have a license.
Place the license file in the same directory as the SNIC.exe is located.
Once everything is configured and saved, run the tool with the parameter: -Meta to retrieve the metadata from sericenow to generate the input tables
- Retrieves all available tables that can be used and generates the input tables for them
This function requires rights to the sys_dictonary table
- -Get <tablename> <filter>
- Retrieves all available data from the table
(All available tables that are found with -Meta)
Example: -Get incident or -Get cmdb_ci
The filter has te beplaced between quotationmarks (")
Example simple fiter :
Example extended filter:
All data that is updated today and is assigned to a group with sys_id = 287ee6fea9fe198100ada7950d0b1b73 for example ICT-Servicedesk. The sys_id depends on your envoirment
Are filter with more than one condition is an extended filter and has to be preceded with 'sysparm=query='
Example: -Get incident "assignment_group=6fc82cf83746aa000858d1b08765"
The server where the database engine is running.
The name of the database where the application will save and retrieve its data from
The name of the database where the application will save and retrieve its data from for the table import api
|userName||The SQL username to use for the SQL connections||dmuser|
The password that corresponds to the SQL User
When True all Output table are truncated before executing the -Get ConnectorName
The url of the servicenow application
The username for servicenow used by the connactor
Password for the serviceNowUsername
The batchsize used bu the connector to write data to servicenow
* After the first run the password are encrypted