Re: SMS Collection question

Thanks for the effort. I figured it would be a "not in" collection, but I
was having a hard time getting it to work right. I started off creating the
collection, looking for the file, and everything seemed to work, and then I
tried to reverse it by adding the "not," but for some reason ended up
returning the same results. I'll try it tomorrow in the office and let you
know how it works.

Thanks,

AAROn
"Dale" <Dale@xxxxxxxxxxxxx> wrote in message
news:5816E648-E097-4FEA-9E78-DD2D16842864@xxxxxxxxxxxxxxxx
> You would create a not in collection. Basing your collection, first with
> pcs
> that have the file.
> ?????
> That's too confusing, even for me and I wrote it...
>
> Here try this cut and paste this into a New collection, you have to change
> FILENAME to the filename you are missing:
> ------------------Start-------------------
>
> 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 Name not in (select SMS_R_System.Name
> from SMS_R_System
> inner join SMS_G_System_SoftwareFile on
> SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId
> where SMS_G_System_SoftwareFile.FileName = "FILENAME" )
> and
> OperatingSystemNameandVersion like "% Workstation%"
> order by Name
>
> --------end ----------------------
>
> Remove the Start and end stuff
> Dale
> --
> (if you like the post please rate it)
>
>
> "Aaron Guilmette" wrote:
>
>> How do I create a collection based on the existence (or non-existence) of
>> an
>> inventoried file?
>>
>> Problem: Application reports as being successfully installed on a
>> machines,
>> yet one of the executables is missing.
>>
>> Thanks,
>>
>> Aaron
>>
>>
>>


.

Relevant Pages

  • Re: Replaces files
    ... I'm afraid you're missing the entire point of the exercise. ... The "ask for a name" part corresponds to the InputBox statement. ... > Dim fileName As String ... >>> prompt appears asking if I want to replace. ...
    (microsoft.public.word.vba.general)
  • Re: script advice
    ... Basically I'm inputting a filename, ... of files with the sander program to generate an rst file used to ... Semicolon seems to be missing at t.pl line 1. ...
    (comp.lang.perl.misc)
  • RE: SMS Collection question
    ... That's too confusing, even for me and I wrote it... ... FILENAME to the filename you are missing: ... "Aaron Guilmette" wrote: ...
    (microsoft.public.sms.admin)
  • Re: Copy filename
    ... KiwiBrian did some thinking and came up with these ... > Maybe I am missing something obvious, but can anyone tell me how I ... > select in the right pane of a Windows Explorer display, ... > subsequently paste that filename into a document? ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: sudo sorrows
    ... Aaron became daring and sent these 0.4K bytes, ... > I am returning to the list after beta testing Xandros, ... > Am I missing something? ...
    (Fedora)