heynt

Does anyone know how a machine can move from the New Computer container in DS into a more suitable Computer Container (custom group) either through a DOS or Windows script while it's being "deployed"?

I already have a script that will modify the aclient.inp file for a machine that already has an Windows OS and has never been discovered by the DS server and of coarse will put itself into the right Computer Container; however, what about new computers purchased and bootup via PXE. Once they bootup, DS will put it in the New Computers container and that's where it will remain unless an admin moved the object into what container it should finally reside in.

Any ideas? Thanks.

Nick

There are a couple of ideas that come to mind.

The easiest is to create virtual computers for the workstations that are coming in new, dependant on you knowing some basic information about them to do this. You can then stage them into the groups of your choice.

The second and one would be to run a query against the express database and move the workstations to a group based on something like the naming convention or the IP address. This method could be run on a schedule and would be the best approach for an automated solution.

__________________
Scire potentia est (knowledge is power)

JeremyDallas

Here's a thread that talks about scripting it.

http://www.altiris.com/support/forum...mode=&s=#60967

Hope it helps...

__________________
JEREMY SMITH

Nick

Posted the code here for reference.

Note that it is a script that would be server side (in the advanced options of a run script)

OSQL -E -deXpress -Q"Update computer where computer_id='%ID%' set group_id =NULL"

Change the group_id value from NULL to whatever the group_id of the group you want to move them to. NULL will put them in the root of the tree and -7 is the new computers group.


If you dont know the group name then it gets a little bit tricky. You can try this script and let me know if it works. Note that you have to have the group name set in the batch file and that if there is multiple groups with the same name the computers will go in to the last one with that name that returns from the query.

This is also a server side script. Be aware of wordwrap as it could cause you problems here.

------------------------------------------------------------------------
SET COMPUTERGROUPNAME=GROUP1

for /f "delims=" %%i in ('osql -E -dexpress -h-1 -Q "SET NOCOUNT ON;SELECT group_id from computer_group where name = '%COMPUTERGROUPNAME%'"') do CALL :QUERY "%%i"

GOTO:EOF

:QUERY
set temp1=%~1
REM This statement has to be put in since OSQL passes in blank lines, but is simple
REM to deal with because the value we are looking for is numeric
if %temp1% GEQ -7 OSQL -E -deXpress -Q"Update computer set group_id ='%temp1%' where computer_id='%ID%'"
GOTO:EOF

*Note: Code created by NKeith

__________________
Scire potentia est (knowledge is power)

heynt

Thanks dudes, I'll give this a shot on Monday.

Nick

I just tested the scripts and they work as described.

__________________
Scire potentia est (knowledge is power)