Deployment Solution

Hi

I have recently mirgated our DS 6.9 deployment servers to new boxes, The IP Addresses cannot be the same on the new boxes due to recent network infrastructure changes. Our previous altiris admin has allowed our Ds users to hardcode ip addresses into all console Run script jobs.

I want to replace all console Run script jobs where they reference the old DS IP server address and replace with the  %DSSERVER% token, so it can be run on any new server, but am not a sql query expert and am unfarmiliar what express database sql table these would be stored in. Is their any sql expert that could provide asistance with guidence or a sql query to achieve this?.

This kind of query is what you want,

update script_task
set script = REPLACE(script,'aaabbbccc','%DSSERVER%')
where script like '%aaabbbccc%'

Where 'aaabbbcc' is the IP you want to replace in the embedded scripts.

Thank you very much for the quick response  IANATKIN that worked a treat, is their also a way to do the same for the Job Run Script 'Copy file to' tasks that have the same hard coded IP Addresses?

This would do it for source locations (which I'm assuming is the right thing)

update copyfile_task
set local_file=REPLACE(local_file,'aaabbbccc','%DSSERVER%')
where local_file like '%aaabbbccc%'

Yes you are correct, it is for source copy file locations only, that script also worked perfectly, thank you very much, I appreciate you sharing your knowlege.

it's time for me to sit down and refamiliarise myself with SQL queries, not done that since university, and to learn what each of the express database tables store, thank you again.