• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 764
  • Last Modified:

SCCm 2007 Inventory what users have software installed

I need to create a report on which users on my domain are using MS Project and MS Visio.  We have SCCM 2007 deployed in our environment.  Can I do this from sccm 2007
0
Twhite0909
Asked:
Twhite0909
  • 2
1 Solution
 
Randy DownsOWNERCommented:
Try this. It's just for Project so you would need an or
ARP.DisplayName0 like '%Project%' or '%Visio%'


http://smsug.ca/blogs/garth_jones/archive/2012/05/03/list-of-pc-with-project-and-subnet.aspx

select Distinct
      CS.Name0
from
      dbo.v_GS_COMPUTER_SYSTEM CS
      join dbo.v_Add_Remove_Programs ARP on CS.ResourceID = ARP.ResourceID
      join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceID = NAC.ResourceID
Where
      ARP.DisplayName0 like '%Project%'
      and (IPAddress0 like '10.1.%'
      or IPAddress0 like '10.4.%')
0
 
Twhite0909Author Commented:
Im not an SCCM admin where do I add this text you have above?
0
 
Randy DownsOWNERCommented:
0
 
Joseph DalyCommented:
Yes you can do this from SCCM and actually there is already a report built in for it.

To do this open SCCM and navigate to the reporting section. From here you can select report number 65 titled "Computers with a specific product"

right click that and select run on the page the appears you can enter the product name using % as a wildcard.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now