Errr, don’t use ProductID in the dbo.SoftwareProduct to create your query.

 

That value (according Microsoft PSS) is not a global value. That value changes from site to site… so your query results will differ from site to site

 

For instance.

 

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_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareProduct.ProductId = 391 or SMS_G_System_SoftwareProduct.ProductId = 250

 

Will give you different results from site to site…

 

 

 

 

Why not using product ID?

 

Thank you

 

Did you create a package and program from definition and try the uninstall program? 

 

Then you could have a query based collection that looks for that software in ARP or something (just don’t use ProductID J) and have that uninstall program advertised to that collection…

 

 

 

Hello list,

I’m interested in removing the Google Toolbar in an automated fashion. It seems that the Google Toolbar is installed as an MSI package, however when removing it using the WMI Win32_Product.Uninstall() method, the files still remain in the %PROGRAMFILES%\Google folder. It does disappear from the Windows Installer database however, so it’s “gone” but not really. Also, the Google Updater service remains behind.

Any ideas on why this is? Anyone ever pursued this before?

Trevor Sullivan | Systems Engineer

End User Technology | IT Operations

 

OfficeMax Corporation

263 Shuman Boulevard, 1W775

Naperville, IL 60563

P: (630) 864-5211

C: (630) 346-4437

E: TrevorSullivan@OfficeMax.com

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

==============================================================================CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy Policy and Henry Ford My Health at www.henryford.com for more detailed information. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us. ==============================================================================

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

==============================================================================CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy Policy and Henry Ford My Health at www.henryford.com for more detailed information. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us. ==============================================================================

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/