...
| Code Block |
|---|
|
select s.Name,
Type = CASE
WHEN s.Type = 1 THEN 'Longview Close'
WHEN s.Type = 2 THEN 'Longview Tax'
ELSE 'Unknown'
END,
sc.Url,
sc.UserName,
sc.Password,
sc.ListenerPort,
sc.Access,
sc.UserGroup,
sc.InstanceId
from Source s
join LVSourceConfiguration sc on sc.SourceId = s.Id |
...
To update the connection fields , run the following query with the correct values and source name:. When certain values do not need to be replaced, remove the particular lines from the query.
| Code Block |
|---|
|
update sc
set sc.Url = '...',
sc.UserName = '...',
sc.Password = '...',
sc.ListenerPort = 0,
sc.Access = '...',
sc.UserGroup = '...',
sc.InstanceId = '...'
from LVSourceConfiguration sc
join Source s on sc.SourceId = s.Id
where s.Name = 'SOURCE NAME HERE' |
An example to replace just the URL and credentials for a source called MyLongviewSource:
| Code Block |
|---|
|
update sc
set sc.Url = 'https://example-url-to-longview-source.com',
sc.UserName = 'Administrator',
sc.Password = 'secret_password'
from LVSourceConfiguration sc
join Source s on sc.SourceId = s.Id
where s.Name = 'MyLongviewSource' |