CA IT Asset Manager installation is leveraging the Data Export functionality and the URL in the received email for the Data Export is inaccessible by the end users.
For example, end users need to use a web site alias or apply a FQDN instead of just the ITAM Server name. Port number also needs to be updated as well.
This article discusses how to manage the necessary changes to allow this.
IT Asset Manager 17.x and higher
The following changes require DBA access to the backend database server. A backup of the MDB database should be taken before any changes are made. Please test the changes on a non-prod environment before attempting in production.
update al_cdb_configurationparameters set configvalue = 'ITAM-WEBSERVER1.DOMAIN.COM' where configkey = 'LoadBalancerName' and componentkey = 'Web_Server'The above changes will modify the host name and port number of the Web Server that the Data Exporter is using to define the URL to provide to a given end user running an export.
update al_cdb_configurationparameters set configvalue = '100' where configkey = 'ServerPort' and componentkey = 'Web_Server'
update mdbadmin.al_cdb_configurationparameters set configvalue = 'HTTP' where configkey = 'Protocol' and componentkey = 'Web_Server'
The Data Export mail should present with a new URL based on the changes made above:
This will only affect new exports generated after the above change is applied. Previous mails generated prior to the above change will retain their old server/port values.
It is the customer's responsibility to determine the correct web server host name and port that should be used for their environment. The above values are provided as an illustrative example only.
One can view all ITAM Web Server configuration settings by running the following query against the MDB database:
SELECT * FROM al_cdb_configurationparameters where componentkey = 'Web_Server'