Defines a installed system for iCanView, only machine which are registered in icsysteminstall can host iCanView.
icinstalledcomponentinfo is removed, instead should use link_systeminstall_installcomp table
| Column Name | Column Datatype | Column Null Option | Column Comment |
| system_install_id | varchar(64) | not null | The unique id for the system install, this is the machine name on which the view is installed |
| comment | nvarchar(64) | with null | Comment on the system install, if any |
| domain_name | varchar(64) | with null | Not used |
| host_name | varchar(64) | with null | Name of the host for this system install |
| logon_reqd | varchar(20) | with null | 1 - logon reqd, 0 - not required Flag indicating if authentication need to be done on this system, if false then the authentication in not done, but just the userid is validated |
| name | varchar(64) | with null | Name of the system install |
| timeout | integer | with null | Default session timeout in seconds for the system install |
| use_cache | integer | with null | 1- cache enabled, 0 - disabled, specifies if caching is enabled/disabled |
| web_root | varchar(256) | with null | This is the installation path for the web application files |
| document_root | varchar(256) | with null | This is the path where the documents will be uploaded |
| port_no | integer | with null | This is the default port where view will be running |
| log_messages | integer | with null | Not used |
| servlet_name | varchar(64) | with null | The name of the servlet context |
| news_to_domains | varchar(20) | with null | Configuration on weather one can send to multiple domains; Values SELF, defualt is all domains |
| client_side_processing | integer | with null | Flag to specify if the transformation is to be done, if 0 no transformation will be done and xml will be sent back to browser to do client transformation |
| concurrent_logon | integer | with null | Indicates if a user can login from multiple machines, 1 - concurrent login allowed, 0 - not allowed |
| super_tenant_enabled | integer | with null | Flag to indicate if Super tenant mode is available or not ; 1 - available, 0 - not available |
| login_property | varchar(64) | with null | This is the default property in the tenant table that will be used for login purposes, say tenant_name if you want login to be based on tenant name and not on tenantid |
| super_tenant_levels | integer | with null | Indicates how many levels of super tenant is allowed, -1 for infinite levels |
| secret_question | varchar(64) | with null | This is the system level secret question if someone forgets a password etc, Eg: What is your mother maiden name? etc |
| pwd_policy_id | varchar(50) | with null | The unique identifier for the password policy |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| system_install_id | usm_link_sysinstall_installcom | system_install_id |
| system_install_id | usm_link_server_systeminstall | system_install_id |