?
Solved

SCCm 2007 Inventory what users have software installed

Posted on 2013-06-11
4
Medium Priority
?
735 Views
Last Modified: 2013-06-18
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
Comment
Question by:Twhite0909
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 30

Accepted Solution

by:
Randy Downs earned 2000 total points
ID: 39237699
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
 

Author Comment

by:Twhite0909
ID: 39237723
Im not an SCCM admin where do I add this text you have above?
0
 
LVL 30

Expert Comment

by:Randy Downs
ID: 39237798
0
 
LVL 35

Expert Comment

by:Joseph Daly
ID: 39245730
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
Know what services you can and cannot, should and should not combine on your server.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question