Attached to this message is an Excel spreadsheet I use to create queries based on a list of computers. To use it, you will need to enable macros in the security section of options in Excel.
Using it is easy. Just paste a list of computers, one on each line, under the "Assets" label then click the Make Query button.
It will create a SQL query (and automatically place it in the Windows clipboard) that can be pasted into an ITCM (DSM) Query.
To do this, In DSM Explorer, right click on Queries, select New... and then select Computers.
From there, click General Information, then Computer, then Host Name. Click OK.
Now, right click on the (Host name = '') line in the Query Designer and click Edit SQL... Highlight everything that is there and paste your SQL statement from the spreadsheet to replace it.
Save your query and you're done. Now you can create your group based on this query and deploy software to those computers easily.
I hope this helps everyone simplify the task of building list-based queries as much as it has for me.
-Jack
... Also, the "Make Comma" button is useful for making a comma separated list of computers for use in the "Infrastructure Deployment" section of the DSM Explorer.
Feel free to post here with any comments or questions.