This section describes how to configure a ServiceNow server to allow the Aspire ServiceNow connector to retrieve security ACLs.
In order to follow the steps in this guide, a user with enough permissions to create custom tables and scheduled jobs in the ServiceNow server is required.
Custom tables creation
Two tables are required for the configuration of the server: An “ACL Tables” table and a “ACL Table Users” table:
- Log in to your ServiceNow server instance.
- In the “Filter Navigator” write the word “Tables”.
Image Added
- Under “System Definition”, select the option “Tables”.
- In the “Tables” page, click on “New”.
Image Added
- In the “Tables – New Record” page, specify “ACL Tables” as the label of the table. The system will automatically assign the name of the table to “u_acl_tables”. It is very important that the name of this table be exactly that name so please double check it.
Image Added
- At the bottom of “Tables – New Record”, insert a new column with the name “Table”. Set “Type” to “String” and the “Display” value to “true”, then click the “Submit” button.
Image Added
- Back to the “Tables” page, browse to the newly created “ACL Tables” table and set its “Extensible” attribute to “true”.
Image Added
- In the “Tables” page, click on “New” again.
- In the “Tables – New Record” page, specify “ACL Table Users” as the label of the table. The system will automatically assign the name of the table to “u_acl_table_users”. It is very important that the name of this table be exactly that name so please double check this one as well.
- In the “Extends Table” option browse and select the table we created previously (“ACL Tables”).
Image Added
- At the bottom of “Tables – New Record”, insert a new column with the name “User”. Set “Type” to “String” and the “Display” value to “true”, then click the “Submit” button.
Image Added