propecia kaufen

 10 Sep 2013 @ 8:17 AM 

Today I was asked to create a report in SCCM / ConfigMgr that shows all installed products in Add & Remove Programs.
My customer wanted to know all applications installed on all computers…
Instead of writing the whole thing myself, I searched on the internet and found the following query here.

Declare @CollID char(8)
Set @CollID = 'SMS00001'
SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as CollectionID
FROM v_Add_Remove_Programs arp
JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID 
WHERE fcm.CollectionID = @CollID
GROUP BY DisplayName0, Publisher0, Version0 
ORDER BY Publisher0, Version0

Hope you find it as useful as I have :-)

Posted By: Jeff Wouters
Last Edit: 09 Sep 2013 @ 08:22 AM

Categories: SCCM, Windows, Windows Server

  • David – SCCM-newbie

    Isn´t that built-in? Report in “Software – Companies” named “Count all inventoried products and Versions” …

  • Rishi Pandit

    Msg 208, Level 16, State 1, Line 3

    Invalid object name ‘v_Add_Remove_Programs’.

    I am having SCCM 2012 R2

 Last 50 Posts
Change Theme...
  • Users » 1
  • Posts/Pages » 365
  • Comments » 561
Change Theme...
  • VoidVoid « Default
  • LifeLife
  • EarthEarth
  • WindWind
  • WaterWater
  • FireFire
  • LightLight


    No Child Pages.


    No Child Pages.


    No Child Pages.

Health Check

    No Child Pages.