cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

This product reached the end of support date on March 31, 2021.

CAS/ADS Server Configuration Automation

Hello,

We are in the process of modifying some of our automation for DCRUM Installations and have hit a roadblock. Currently after installation is completed when a user navigates to the CAS through the web browser they are greeted with the Server Configuration screen:

serverconfig.png

We know what settings we want to implement and if we knew what configuration file these settings are made at, we could modify directly with our scripts to avoid this extra step. Please advise in what file we can make these changes and which properties/fields/parameters we would need to modify.

8 REPLIES 8

adam_piotrowicz
Dynatrace Pro
Dynatrace Pro

So are you OK just with knowledge which options from this screen map to which properties in the DB?

If they are DB properties and not a configuration file, I'm not sure how well it will work, but yes I would like to know those properties.

Hi Adam, could you let us know what DB properties these are?

Working on this and will let you know.

Thank you very much.

Hello,

I've prepared SQL queries which can be executed to set up automatically Configuration screen (restart is required):

1. Site options (AS - AS)

if exists (select * from RtmProps where propertyName = 'RtmJob.Step')
update RtmProps set propertyValue = '0'
where propertyName = 'RtmJob.Step'
go


if exists (select * from RtmProps where propertyName = 'PCS_USE_AS')
update RtmProps set propertyValue = '1'
where propertyName = 'PCS_USE_AS'
go

if exists (select * from RtmProps where propertyName = 'PCS_USE_BGP')
update RtmProps set propertyValue = '1'
where propertyName = 'PCS_USE_BGP'
go

2. User IP address ranges (example):

if exists (select * from RtmProps where propertyName = 'RtmJob.clientToName.0')
update RtmProps set propertyValue = '167.207.1.1-167.207.1.9'
where propertyName = 'RtmJob.clientToName.0'
else
insert into RtmProps (propertyName, propertyValue,BuildWhenUserChanged,DefValueForCurVer)
values ('RtmJob.clientToName.0', '167.207.1.1-167.207.1.9', 2020114, '')
go

if exists (select * from RtmProps where propertyName = 'RtmJob.clientToName.1')
update RtmProps set propertyValue = '167.207.1.11-167.207.1.255'
where propertyName = 'RtmJob.clientToName.1'
else
insert into RtmProps (propertyName, propertyValue,BuildWhenUserChanged,DefValueForCurVer)
values ('RtmJob.clientToName.1', '167.207.1.11-167.207.1.255', 2020114, '')
go

3. PVU mode (with check box selected):

if exists (select * from RtmProps where propertyName = 'PCS_IGNORE_NAMES')
update RtmProps set propertyValue = '1'
where propertyName = 'PCS_IGNORE_NAMES'
go

if exists (select * from RtmProps where propertyName = 'PCS_IS_USER')
update RtmProps set propertyValue = '1'
where propertyName = 'PCS_IS_USER'
go

4. ISP Extended:

if exists (select * from RtmProps where propertyName = 'IS_EXTENDED_ISP')
update RtmProps set propertyValue = '1'
where propertyName = 'IS_EXTENDED_ISP'
go

If any other settings are needed, please answer to this post.

This is good, but what would be the properties, for the selections based on the screenshot below?

config.png

1. Site options (CIDR - CIDR)

if exists (select * from RtmProps where propertyName = 'RtmJob.Step')

update RtmProps set propertyValue = '0' where propertyName =
'RtmJob.Step' go

if exists (select * from RtmProps where propertyName = 'PCS_USE_AS')

update RtmProps set propertyValue = '0' where propertyName =
'PCS_USE_AS' go

if exists (select * from RtmProps where propertyName =
'PCS_USE_BGP')

update RtmProps set propertyValue = '1' where
propertyName = 'PCS_USE_BGP' go

if exists (select * from RtmProps where propertyName =
'PCS_AGGREGATE_CIDR_AS')

update RtmProps set propertyValue = '1' where
propertyName = 'PCS_AGGREGATE_CIDR_AS' go

2. User IP address ranges:

if exists (select * from RtmProps where propertyName =
'RtmJob.clientToName.0')

update RtmProps set propertyValue =
'0.0.0.0-255.255.255.254' where propertyName = 'RtmJob.clientToName.0'

else

insert into RtmProps (propertyName,
propertyValue,BuildWhenUserChanged,DefValueForCurVer) values
('RtmJob.clientToName.0', '0.0.0.0-255.255.255.254', 2020114, '')

go

3. Enable on-demand access

if exists (select * from RtmProps where propertyName = 'STORE_ON_DEMAND_STATS')

update RtmProps set propertyValue = '0' where propertyName =
'STORE_ON_DEMAND_STATS' go