Check out the following SQL query that will give you a quick and easy way to report software installed on your machines:
INNER JOIN v_GS_SYSTEM S ON INSO.ResourceID = S.ResourceID
ARPDisplayName0 like '%SQL%'
It will return something like this: This was provided by Garth Jones here : http://smsug.ca/blogs/garth_jones/archive/2011/03/06/sql-using-installed-software.aspx
Greetings All, Another month, another Configuration Manager (Current Branch) release. 1611’s features are outlined below.
Greetings Guys, Take a look at this query I stumbled upon which may prove useful. You can create a device collection by a KB number that is installed on the PC. See attached:
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_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%KB3114409%"
With the latest vulnerability being patched I was in need to deploy a windows update to a subset of computers running a certain windows “feature”. IIS. I was able to find out which servers were running IIS (with powershell, duh) and then exported this list to a .txt – From there I needed to get […]