12 June 2012

Home » » SMS/SCCM Query for all Adobe CS3 products

SMS/SCCM Query for all Adobe CS3 products

  Tuesday, June 12, 2012    No comments
This query will return a list of all systems with Adobe CS3 products. It omits the useless products such as Stock Photos, Asset Services, and such.

 select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from SMS_R_System 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 like "Adobe Acrobat%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like 
"%CS3%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Creative Suite 3%") and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Anchor Service%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Linguistics%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Bridge%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName 
not like "Adobe Device Central%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe XMP Panels%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Stock Photos%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Asset Services%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Help Viewer%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Version Cue%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Default Language%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Update Manager%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe SING%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName 
not like "Adobe WAS%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Add or Remove Adobe Creative 
Suite 3%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe After Effects%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe Glyphlet%" and 
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Adobe XMP DVA Panels%" order by SMS_R_System.Name

Related Posts:

  • Remove AD Disabled Systems from SCCM Recently, I wanted to clean up SCCM of a bunch of systems that still reside in active directory, but are also disabled. The first thing I did was to try and query SCCM for a list of systems that were populated via AD, but h… Read More
  • Installing the .Net Framework 4.7 MSU file I needed to install .Net Framework 4.7 on all systems. We no longer manage windows updates via SCCM, so we needed to deploy it as an application. I downloaded the two MSU files, 32-bit and 64-bit, from the Microsoft Update… Read More
  • Bitlocker Recovery Password Utility Recently, we encountered an issue where we found out a few systems did not have the BitLocker recovery password backed up to active directory. We have the GPO in place that pushes that key to AD, but for some reason, a… Read More
  • SCCM Hardware Inventory with Verification This script will initiate a hardware inventory. It scans the InventoryAgent.log file for the initiation of the hardware inventory and then for the completion. The script will return an error code 1 if the initiation was ign… Read More
  • Trusted Sites Report Recently, we had to add a new trusted site to the trusted sites GPO. As you may know, if the GPO contains a lot of trusted sites, it can be cumbersome to determine if a site is in there. I wrote this PowerShell script that … Read More

0 comments:

Post a Comment