Solved

SCCm 2007 Inventory what users have software installed

Posted on 2013-06-11
4
688 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
  • 2
4 Comments
 
LVL 29

Accepted Solution

by:
Randy Downs earned 500 total points
Comment Utility
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
Comment Utility
Im not an SCCM admin where do I add this text you have above?
0
 
LVL 29

Expert Comment

by:Randy Downs
Comment Utility
0
 
LVL 35

Expert Comment

by:Joseph Daly
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found listed in my profile here: http:…
This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
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…

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now