Bulk add computers to DS job

JSF · 05-19-2005, 11:30 AM

Is there a way to bulk add computers to a deployment job in DS? Maybe in the form of a delimited file or something like that?

Jezz · 05-19-2005, 11:45 AM

Create a batch file with the following text;

for /f %%f in (Computerlist.txt) do "\\DSServer\eXpress\axSched.exe" %%f "DS Job Name" /t "2005-09-12 14:15" /d DSServer /u sa /p "password"

the time can be set for the job to run. If in the past the job runs immediately.

create a computerlist.txt file with computernames on seperate lines.

name1
name2
etc

Run the batch to schedule the job.

JSF · 05-19-2005, 11:50 AM

Very cool! Thanks so much!

Nick · 06-16-2005, 06:07 PM

Jezz,

Where does the computerlist.txt need to be located for this?

Jezz · 06-16-2005, 06:33 PM

In the same folder as the batch file with the script in it.

JSF · 06-16-2005, 06:53 PM

Smeg head!! ;-)

dominique · 11-27-2006, 06:14 PM

Quote:

Originally Posted by Jezz

Create a batch file with the following text;

for /f %%f in (Computerlist.txt) do "\\DSServer\eXpress\axSched.exe" %%f "DS Job Name" /t "2005-09-12 14:15" /d DSServer /u sa /p "password"

the time can be set for the job to run. If in the past the job runs immediately.

create a computerlist.txt file with computernames on seperate lines.

name1
name2
etc

Run the batch to schedule the job.

Hello Jezz,

Does the computer and jobs appear on the Deployment Console? as a usual job ready to run?

I am getting the following error:
C:\Documents and Settings\svcaltiris\Desktop>for /F %f in (testDSList.txt) do "\
\Altiris2\eXpress\axSched.exe" %f "DIR Command (DOS)" /t "2006-11-27 16:15" /d "
Altiris2" /u "ad\svcaltiris" /p "a2706sccmppo"
C:\Documents and Settings\svcaltiris\Desktop>"\\Altiris2\eXpress\axSched.exe" op
pmccs6013 "DIR Command (DOS)" /t "2006-11-27 16:15" /d "Altiris2" /u "ad\svcalti
ris" /p "***********"
Altiris Deployment Server Scheduling Utility version 6.5
Copyright 2005. Altiris, Inc. All rights reserved.
Connecting to database...
Error opening database connection:
Login failed for user 'ad\svcaltiris'. Reason: Not associated with a trusted SQL
Server connection.
Connecting to database...
Error opening database connection:
Cannot open database requested in login 'eXpress'. Login fails.

C:\Documents and Settings\svcaltiris\Desktop>pause
Press any key to continue . . .

What did I do wrong?

Thanks,
DOm

Jezz · 11-28-2006, 03:03 AM

Dom

The job will appear the same as any job setup in the DS console. If the date in the script is in the past the job will run staright away. If you don't want the job to run put the date in the future.

The username and password for the database need to be a SQL username and password rather than a domain username & password (Could be wrong but have found it works)

Switches are on page 377 of the deployment.pdf in Expressshare\Docs

dominique · 11-28-2006, 12:30 PM

Hello,

Thanks Jezz... let me try this.

I used the user test whici is a SQL username.

should I run it on the DS server? or on any workstation?

C:\Documents and Settings\dduchemin\My Documents>for /F %f in (testDSList.txt) d
o "\\Altiris2\eXpress\axSched.exe" %f "DIR Command (DOS)" /t "2006-11-27 16:15"
/d "Altiris2" /u "test" /p "olga1966"
C:\Documents and Settings\dduchemin\My Documents>"\\Altiris2\eXpress\axSched.exe
" oppmccs6013 "DIR Command (DOS)" /t "2006-11-27 16:15" /d "Altiris2" /u "test"
/p "olga1966"
Altiris Deployment Server Scheduling Utility version 6.5
Copyright 2005. Altiris, Inc. All rights reserved.
Connecting to database...
Error opening database connection:
Login failed for user 'test'. Reason: Not associated with a trusted SQL Server c
onnection.
Connecting to database...
Error opening database connection:
Login failed for user 'AD\DDuchemin'.

C:\Documents and Settings\dduchemin\My Documents>pause
Press any key to continue . . .

Thanks,

Jezz · 11-29-2006, 02:57 AM

Dom

Do you have security set on your DS console?

Try setting up a ODBC dsn connection to your database and use that.

******
Altiris Deployment Server Scheduling Utility version 6.5
Copyright 2005. Altiris, Inc. All rights reserved.

Usage:
axSched <computer/group> <job-name> (options)
OR
axSched /q <filename> (options)

Options:
/t <yyyy-mm-dd hh:mm> Time to schedule
/n Don't notify servers of the changes
/f <folder-name> schedule the job-name found in this folder
/q <filename> File used for exporting jobs
/y Suppress confirmation prompts
/dsn <odbc-dsn-name> ODBC data source name
/d <db-server> Database server name
/u <db-user> Database user name
/db <db-databaseName> Database name
/p <db-password> Database user password
/lu <login-user> Deployment Server login user name
/lp <login-password> Deployment Server login password

**************
for /F %f in (testDSList.txt) do "\\Altiris2\eXpress\axSched.exe" %f "DIR Command (DOS)" /t "2006-11-27 16:15"
/dsn "XXX"

You can run this from a workstation or the server.

dominique · 11-29-2006, 12:23 PM

Quote:

Originally Posted by Jezz

Dom

Do you have security set on your DS console?

Try setting up a ODBC dsn connection to your database and use that.

******
Altiris Deployment Server Scheduling Utility version 6.5
Copyright 2005. Altiris, Inc. All rights reserved.

Usage:
axSched <computer/group> <job-name> (options)
OR
axSched /q <filename> (options)

Options:
/t <yyyy-mm-dd hh:mm> Time to schedule
/n Don't notify servers of the changes
/f <folder-name> schedule the job-name found in this folder
/q <filename> File used for exporting jobs
/y Suppress confirmation prompts
/dsn <odbc-dsn-name> ODBC data source name
/d <db-server> Database server name
/u <db-user> Database user name
/db <db-databaseName> Database name
/p <db-password> Database user password
/lu <login-user> Deployment Server login user name
/lp <login-password> Deployment Server login password

**************
for /F %f in (testDSList.txt) do "\\Altiris2\eXpress\axSched.exe" %f "DIR Command (DOS)" /t "2006-11-27 16:15"
/dsn "XXX"

You can run this from a workstation or the server.

Hello Jezz,

No security on the DS Console Tools Security unchecked.
I have my DS console working properly I will setup an ODBC connection to find out,
the only thing I am worried is SQL eXpress is on server A and Deployment Server is on Server B, may be something tricking crossing the two servers....

Thanks,
Dom

Brandon · 11-29-2006, 03:22 PM

Ours is just a spreadsheet. you only fill in the fields you want but you include them all. So it will look like Name,,,,,,,1.2.3.4, etc..... ( ; is a comment) Save this as a csv in excel then just do File import from DS.

example:

;Name,,,,;Comp Name,,,,;DHCP Flag,;IP,;Subnet,;Gateway,;DNS1,;DNS2,;DNS3,;WINS1 ,;WINS2,,,,,,,,,,,,,,,,,,,,,,,,,,,
DSNAme,,,,Comp-Name,,,,0,1.1.1.1,255.255.255.0,2.2.2.1,2.2.2.2,2. 2.2.3,3.3.3.1,3.3.3.2,,,,,,,,,,,,,,,,,,,,,,,,,,NAm e of Folder to save PC in,Job for PC to run,12/31/2000 10:00

don't import too many at once because you have to scroll around in the managed PC list in DOS with your arrow keys when you go to image it. (assuming it is and image job)