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.
- Create a new job: File > New > Job.
- Add a Run Script: Add > Run Script.
- 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
- Click Next.
- Select the Script Run Location: Locally on the Deployment Server.
- Click Finish.
- 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
- Change <My Computer Group Name> text to the name of the destination Computer Group.