This article applies to: Cireson Portal, versions 3.5 and above.
Depreciated Article - version of Cireson Portal no longer in support
History & Overview
As of version 3.5 many of the web.config and cachebuilder app.config settings have been moved into the ServiceManagement database into the SettingsItem table.
In version 3.7+ you can set these values via the Settings Items UI, go to Admin Settings from the top right user menu, then scroll to the bottom of the page and click the settings items button.
Before version 3.7 you will need to set these values, via the SettingsItem Table in the ServiceManagement Database.
Note: The Service Manager and Service Management services must be installed on the same server, otherwise they will not function correctly.
Overwrite Settings Item via Web.config
As of version 3.7 you can overwrite any value from the SettingsItem table via the web.config. This allows you to have unique values for each web server in a multi-server environment that uses a single database.
Edit Existing Setting Via The Database
If you need to update a setting you can do so by editing the table using SQL Server Management Studio or a similar editor using the following SQL:
This will update the ApplicationTitle key to “ABC Company”:
UPDATE [dbo].[SettingsItem]
SET [Value] = 'ABC Company',
[ModifiedDate] = GETUTCDATE()
WHERE [Key] = 'ApplicationTitle'
*Most settings will be exposed via the UI very shortly.
Add New Setting Via The Database
If you need to add a setting for example “ConfigItemClasses” you may use the following SQL:
INSERT INTO [dbo].[SettingsItem]
([Key]
,[TenantId]
,[Value]
,[ModifiedDate])
VALUES
('ConfigItemClasses'
,0
,'Microsoft.Windows.Client.Computer,Microsoft.Windows.Server.Computer'
, GETUTCDATE())
NOTE:
From the example above, the ConfigItemClasses setting, takes a comma separated list of Configuration Item class names to include in the cache. Use SMLets to query a list of Configuration Item class names:
Get-SCSMClass -Name System.ConfigItem$ | %{$_.GetDerivedTypes(1)} | Sort-Object Name
Leaving the setting value blank will include ALL configuration item classes