Re: Systems with no client

why not just query for machines without a client directly?

select * from SMS_R_System where Client = 0

Todd
"Lat" <Lat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:5191A88A-9195-401E-9728-F2A5975AE2F0@xxxxxxxxxxxxxxxx
Morning everyone,

I have a question on something which has been puzzling me. I have this query
setup in Collection to show me which machines do not have the sms client
installed. For some reason I am getting machines which DO have sms client
installed listed in there also. Query as follows:

select
SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client
from SMS_R_System where ResourceId not in (select SMS_R_System.ResourceID
from SMS_R_System inner join SMS_G_System_SMS_ADVANCED_CLIENT_STATE on
SMS_G_System_SMS_ADVANCED_CLIENT_STATE.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_SMS_ADVANCED_CLIENT_STATE.Version is not NULL)

Any ideas why?

Relevant Pages

  • Re: Union Query works on my PCs but not on clients machines
    ... will check all that out next time I visit the client. ... > To check the file versions between the two machines, ... The query contains undeclared parameters, ... >> office machines and updated it in the same way I updated my home PC. ...
    (microsoft.public.access.queries)
  • Re: Question about "Install Flag"
    ... Could you verify whether the re-installed machines get assigned correctly? ... > an advanced client push installation;but it does not work. ... > installation automaticcaly,without any scripts. ... >>> machine on my domain recieved the sms client successfully on the first ...
    (microsoft.public.sms.admin)
  • Re: Record Count Inconsistent
    ... show up when the file was accessed from the client end. ... The same query ("select * from QryReport) is run from all ... machines. ...
    (microsoft.public.access.queries)
  • RE: Collection not showing ALL of the clients correctly
    ... If I'm not getting hardware inventory then the client is not ... through the query to create a new collection and that seemed to work. ... added the other machines that have not been showing up as "Direct" and I now ...
    (microsoft.public.sms.admin)
  • RE: CLIENT PUSH INSTALLATION PROBLEM
    ... wanted to do that was simply install the SMS client in the rest of machines. ...
    (microsoft.public.sms.admin)