Registered member login:
Register Now
Altirigos » Homepage2

» Current Poll
Do you leave the Aclient enabled?
YES - 82.17%
106 Votes
NO - 17.83%
23 Votes
Total Votes: 129
You may not vote on this poll.
» Stats
Members: 9,489
Threads: 11,748
Posts: 55,279
Top Poster: Nick (4,981)
Welcome our newest member, jbwex
» Online Users: 37
2 members and 35 guests
caspere, sachu_uthra
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 06-29-2009, 07:51 AM   #2 (permalink)
artusod
 
Status: Altiris Admin
Join Date: 09-17-2005
Location: ottawa
Posts: 42


Hi,
In general, you get the Guids of the computers that do have the software, then exclude them from the main query. Something like this:

Select _ResourceGuid
From Inv_Aex_AC_NT_Services
Where _ResourceGuid Not In (
Select _ResourceGuid
From Inv_Aex_AC_NT_Services
Where [Name] = 'your service'
)

Dan
artusod is offline   Reply With Quote
 
Powered by vBadvanced CMPS v3.0 RC2

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


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