Export a filter from DS query

eben80 · 05-28-2008, 09:43 AM

Hi guys.

I have a question about how I would run a query on the express db that would give me the results of all the machines on the DS without the "AltirisAgent" in the App description field. I want to use this query so that I can get the IP's of the mahines (DNS issue), and then push the Altiris agent to them but I'm not SQL savvy enough to compile the query.

Could anyone help please?

Thanks

Eben

jenifer.arnold · 06-02-2008, 03:52 PM

Try this one...

Code:

 
use express
SELECT DISTINCT dbo.computer.name
FROM         dbo.application INNER JOIN
                      dbo.computer ON dbo.application.computer_id = dbo.computer.computer_id INNER JOIN
                      dbo.computer_group ON dbo.computer.group_id = dbo.computer_group.group_id
where dbo.computer.name not in(
SELECT DISTINCT dbo.computer.name
FROM         dbo.application INNER JOIN
                      dbo.computer ON dbo.application.computer_id = dbo.computer.computer_id INNER JOIN
                      dbo.computer_group ON dbo.computer.group_id = dbo.computer_group.group_id
WHERE     (dbo.application.description like '%Altiris Agent%')
)

There no IP address in that list, but maybe someone can chime in on adding that column...