Registered member login:
Register Now
Altirigos » Homepage2

» Current Poll
Do you leave the Aclient enabled?
YES - 82.68%
105 Votes
NO - 17.32%
22 Votes
Total Votes: 127
You may not vote on this poll.
» Stats
Members: 9,479
Threads: 11,743
Posts: 55,255
Top Poster: Nick (4,981)
Welcome our newest member, timmaki
» Online Users: 30
0 members and 30 guests
No Members online
Most users online at once 294, 06-30-2007 at 12:24 PM.
» March 2010
S M T W T F S
28 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31 123
View Single Post
Old 05-29-2009, 10:37 AM   #5 (permalink)
Nick
 
Nick's Avatar
 
Status: Altiris Architect (Site Founder)
Join Date: 01-01-2005
Location: RDU, North Carolina, USA
Posts: 4,981


You know you don't need to have access to the SQL Server to run sql queries against it right?

The AppID that the DS uses already gives you that access. You could run a sql query against the express database from a run script job.

For your scenario you might be able to write that sql query to move systems with the product name being blank to a new container within the DS.

Just a thought.

Sample of how to move from one group to another using sql from DS run script job.

  1. Create a new job: File > New > Job.
  2. Add a Run Script: Add > Run Script.
  3. Insert the text:REM Server side script to change a machine’s Computer Group
    REM ReplaceTokens .\samples\scripts\movecomputergroup.sql .\temp\%COMPNAME%.sql
    OSQL.EXE -E -D "Altiris eXpress Database" -t 600 -i .\temp\%COMPNAME%.sql
    DEL /Q .\temp\%COMPNAME%.sql
  4. Click Next.
  5. Select the Script Run Location: Locally on the Deployment Server.
  6. Click Finish.
  7. Create a file .\samples\scripts\movecomputergroup.sql containing the text: declare @gid int
    SET @gid = (SELECT DISTINCT cg.group_id FROM computer_group cg
    WHERE cg.name = ‘<My Computer Group Name>’)
    exec wc_upd_computer_group %ID%, @gid
  8. Change <My Computer Group Name> text to the name of the destination Computer Group.
__________________
Scire potentia est (knowledge is power)
Nick is offline   Reply With Quote
 
Powered by vBadvanced CMPS v3.0 RC2

All times are GMT -4. The time now is 06:37 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
vB.Sponsors
Altirigos