You import the ZENworks Device Details to ZENworks Service Desk by using database mapping:
In ZENworks Service Desk user interface, click Setup > AMIE > New.
In the Server section of the AMIE page, select the type of the inventory management product.
Fill in the fields in the Database section:
Type: Select the database type.
Host: Specify the hostname or IP address of the database.
Port: Specify the port number for the database server.
Name: Specify the database name.
Username: Specify the username.
Password: Specify the password.
For the internal Sybase database or internal PostgreSQL database, you can obtain the password by running the following command:.
zman dgc
For other databases, use the password that you configured during the ZENworks Primary Server installation.
Schema: Specify the schema type. Depending on the database type, you must specify one of the following schema types:
For PostgreSQL: zenadmin
For Sybase: zenadmin
For MS_SQL: dbo
For Oracle: ZENWORKS
Catalog: Specify the catalog name. Typically this would be the name of the database. Depending on the database type, you must specify one of the following catalog types:
For PostgreSQL: zenworks
For Sybase: zenworks
For MS_SQL: zenworks_zonename
Replace zonename with the name of the management zone in which the Primary Server is installed.
For Oracle: ZENWORKS
In the Notification section, select whether you want notify technicians for generated change requests. You can do this only if Control CMS via RFC is also enabled.
Fill in the fields in the Ownership section:
Unassigned (Import Items as Global): Select this option if the items are to be globally owned.
System User: Select this option to assign imported items to the System User.
Selected Customer: Select this option to assign imported items to a specific customer.
Fill in the fields in the Synchronization section:
Auto Create New Items: This option is visible only when a single AMIE source is defined within AMIE. Click Yes to automatically create items upon synchronization, relative to the "Control CMS via RFC" setting in the Setup > Privileges > Requests tab. If the setting is disabled, a snapshot of imported asset information is listed within the Super > Configuration > AMIE Snapshots tab.
Frequency: Choose a synchronization interval. You can leave this set to Never if the database will be synchronized manually.The synchronization time can vary, depending on the connection speed with the external service and the database size.
Click Test to initiate a connection and test the setup.
Click Save.
In the AMIE page, click the server whose device details you want to import
Click the Import button.