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”.
![](/download/attachments/729256948/image2020-1-22_15-53-46.png?version=1&modificationDate=1579730028000&api=v2)
- Under “System Definition”, select the option “Tables”.
- In the “Tables” page, click on “New”.
![](/download/attachments/729256948/image2020-1-22_15-54-26.png?version=1&modificationDate=1579730067000&api=v2)
- 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.
![](/download/attachments/729256948/image2020-1-22_15-54-57.png?version=1&modificationDate=1579730098000&api=v2)
- 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.
![](/download/attachments/729256948/image2020-1-22_15-55-43.png?version=1&modificationDate=1579730147000&api=v2)
- Back to the “Tables” page, browse to the newly created “ACL Tables” table and set its “Extensible” attribute to “true”.
![](/download/attachments/729256948/image2020-1-22_15-56-51.png?version=1&modificationDate=1579730211000&api=v2)
- 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”).
![](/download/attachments/729256948/image2020-1-22_15-57-32.png?version=1&modificationDate=1579730253000&api=v2)
- 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.
![](/download/attachments/729256948/image2020-1-22_15-57-59.png?version=1&modificationDate=1579730281000&api=v2)