Re: Query for systems without specific software
From: Gary Shortencarrier (anonymous_at_discussions.microsoft.com)
Date: 06/29/04
- Next message: Sangeetha Visweswaran [MSFT]: "Re: Hardware Inventory of registry SMS 2003 sms_def.mof"
- Previous message: Steve Adams: "Hardware Inventory of registry SMS 2003 sms_def.mof"
- In reply to: Steve Adams: "Re: Query for systems without specific software"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 06:17:36 -0700
Perfect. Thanks!
>-----Original Message-----
>Hi Gary,
>
>I had to use a sub-select to removed all unwanted
workstations.
>I created a query which excludes all machines with
distiller.exe installed.
>I have used the assumption that if they have distiller
then they have full
>adobe installed.
>This was to allow me to update all adobe readers without
updating full
>adobe.
>You could easily flip this round to do what you need.
>
>Notice I am using the file path to determine the version
of adobe installed.
>Notice for adobe reader 6 I use file path and file
version.
>
>Hope this helps,
>
>/Steve
>
>Here is the query for adobe reader 5x:
>
>select
>SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_Sy
stem.Name,SMS_R_Sy
>stem.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWork
group,SMS_R_System
>..Client from SMS_R_System inner join
SMS_G_System_SoftwareFile on
>SMS_G_System_SoftwareFile.ResourceID =
SMS_R_System.ResourceId where
>SMS_R_System.OperatingSystemNameandVersion like "%
Workstation%" and
>SMS_G_System_SoftwareFile.FileName = "acrord32.exe" and
>SMS_G_System_SoftwareFile.FilePath like "%adobe\\acrobat
5.0%" and
>SMS_R_System.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_R_System.OperatingSystemNameandVersion
>like "%Workstation%" and
SMS_G_System_SoftwareFile.FileName =
>"acrodist.exe")
>
>Here is the query for adobe reader 60:
>
>select
>SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_Sy
stem.Name,SMS_R_Sy
>stem.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWork
group,SMS_R_System
>..Client from SMS_R_System inner join
SMS_G_System_SoftwareFile on
>SMS_G_System_SoftwareFile.ResourceID =
SMS_R_System.ResourceId where
>SMS_R_System.OperatingSystemNameandVersion like "%
Workstation%" and
>SMS_G_System_SoftwareFile.FileName = "acrord32.exe" and
>SMS_G_System_SoftwareFile.FilePath like "%adobe\\acrobat
6.0%" and
>SMS_G_System_SoftwareFile.FileVersion like "6.0.0%" and
SMS_R_System.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_R_System.OperatingSystemNameandVersion
>like "%Workstation%" and
SMS_G_System_SoftwareFile.FileName =
>"acrodist.exe")
>
>Here is the query for adobe reader 6.0.1
>
>select
>SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_Sy
stem.Name,SMS_R_Sy
>stem.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWork
group,SMS_R_System
>..Client from SMS_R_System inner join
SMS_G_System_SoftwareFile on
>SMS_G_System_SoftwareFile.ResourceID =
SMS_R_System.ResourceId where
>SMS_R_System.OperatingSystemNameandVersion like "%
Workstation%" and
>SMS_G_System_SoftwareFile.FileName = "acrord32.exe" and
>SMS_G_System_SoftwareFile.FilePath like "%adobe\\acrobat
6.0%" and
>SMS_G_System_SoftwareFile.FileVersion like "6.0.1%" and
SMS_R_System.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_R_System.OperatingSystemNameandVersion
>like "%Workstation%" and
SMS_G_System_SoftwareFile.FileName =
>"acrodist.exe")
>
>
>"Gary Shortencarrier" <shortencarriergf@state.gov> wrote
in message
>news:225df01c45d4d$64894840$a301280a@phx.gbl...
>> I am trying to create a collection of XP workstations
that
>> do not have Adobe Acrobat (Full version, not the reader)
>> installed. I will use this collection to uninstall
Acrobat
>> Reader 5.x, and install Adobe Reader 6.0.
>>
>> I do not want to upgrade the reader on machines with the
>> full version of Acrobat, in order to avoid potential
>> conflicts, etc..
>>
>> File inventoried for adobe acrobat 5.0 (and a few
earlier
>> versions) is acrobat.exe.
>>
>> When I do the Query:
>>
>> select distinct 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 != "Acrobat.exe"
>>
>> The computers with Acrobat installed still show up.
>>
>> If I do the query with = "Acrobat.exe", I get only those
>> that have the file, and they match up to my software
>> report for computers with that file.
>>
>> Am I missing something for how to find what is not there
>> software-wise? Not equal to doesn't seem to work for a
>> single value or a list of values (where acrobat.exe is
the
>> only thing in the list).
>>
>> I can create a collection of files that DO have
>> acrobat.exe; Is there a way to exclude members of one
>> collection from another collection? That would be
another
>> route I can take...
>>
>> Thanks!
>>
>> Gary
>
>
>.
>
- Next message: Sangeetha Visweswaran [MSFT]: "Re: Hardware Inventory of registry SMS 2003 sms_def.mof"
- Previous message: Steve Adams: "Hardware Inventory of registry SMS 2003 sms_def.mof"
- In reply to: Steve Adams: "Re: Query for systems without specific software"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
