RE: SMS Collection question

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: SMS Collection question
    ... was having a hard time getting it to work right. ... AAROn ... > FILENAME to the filename you are missing: ... >> yet one of the executables is missing. ...
    (microsoft.public.sms.admin)
  • 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: 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)
Quantcast