magnus1¨ºÇb±Ë¬²*²hœ®‹(~×(

I can't get the query to work. Get "Syntax error".

sangeetha visweswaran [msft]

This is a WQL query and not a SQL query. So you have to run in wbemtest to
test the results and not in SQL.

--
Hope this helps!
Sangee

P.S:Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.

"This posting is provided AS IS with no warranties and confers no rights."

magnus1¨ºÇb±Ë¬²*²hœ®‹(~×(

I tried putting it in a query and collection in SMS.

shawn stewart

This shouldn't matter unless there are schema differences, but I am running
SMS 2003 SP1 and was able to make the query work. If you copied the query
from the first post here, you have to remove the > symbols. Here it is
copied and pasted directly from my SMS Admin console.

select
SMS_R_System.ResourceID,SMS_R_System.ResourceType, SMS_R_System.Name,SMS_R_Sy
stem.SMSUniqueIdentifier,SMS_R_System.ResourceDoma inORWorkgroup,SMS_R_System
..Client from SMS_R_System
where ResourceId not in
(select ResourceID
from SMS_R_System
where AgentName in ("MP_INVENTORY_MANAGER","Heartbeat Discovery","NT Logon
Discovery") and DATEDIFF(day,AgentTime,GetDate())<30)
and SMSUniqueIdentifier IS NOT NULL