RE: Will package install if software already exists? HELP!
- From: net1994 <net1994@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 5 Apr 2007 17:46:01 -0700
Thanks Matt. But what I'm trying to target is those users in AD Security
Group Z who does not have Visio. The collection you wrote below (I think)
will return all machines in the company that do not have Visio. This is a
good start, but I need to install Visio for the members of the AD Group. The
query below returns over a thousand pcs in the company; I just need to
install on 50.
On a side note. I think maybe 20 of the machines already have it. But most
not installed recently via SMS or manually.
Is there another query I could run? Or specify MSI command line switch?
Not sure if a switch exists to skip if already present.
"Matthew Hudson" wrote:
Yes and no. If you deployed it with SMS and the record is not old/deleted.
then when you tell it to install the client will post back with "already
sucessfull on x date, not applying adv" But if you didn't install it with
SMS or that data is old/deleted then it will re-install it. You need to
create a new collection to this collection for visio. You have a collection
with computers in it. In a subcollection keyed off your orginal one put this
in there...
-----------------
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 inner join SMS_G_System_COMPUTER_SYSTEM on
SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct
SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join
SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID =
SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on
SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "Microsoft Office Visio
Professional 2003")
--------------------------------
This will find computers that don't have visio and now do the adv for visio
to this new collection
"net1994" wrote:
Need to deploy Visio 2003 to about 50 people in our company. Have the
package ready to go. Learned quickly that doing this by collection would be
a nightmare for several reasons. Will use their AD Security group to push
out.
Anyway..... Some of the people already have Visio in the dept. I don't want
them to have it install on top of itself and kick the user out, or bog them
down.
Will SMS check to see if it is installed on the target pc, and if so skip
the pc from installing Visio 2003?? Is this automatic, or a MSI command line
setting?
If so, this will save me excruciating time setting up very specific
collections. and deploying to the machines.
HELP!
- Follow-Ups:
- RE: Will package install if software already exists? HELP!
- From: Matthew Hudson
- RE: Will package install if software already exists? HELP!
- Prev by Date: Re: SMS Server
- Next by Date: RE: Will package install if software already exists? HELP!
- Previous by thread: Re: Where are clients running the package from?
- Next by thread: RE: Will package install if software already exists? HELP!
- Index(es):
Relevant Pages
|
Loading