Creating Report: All Software Inventory

all, i'm trying to create a report that will find all software installed on the network.
 
yes, crazy request. especially if you look for something like...quicktime. it will put different instances on it due to all the different versions installed on the clients.
 
i have a nice sized environment too. about 1500 active clients.
 
anyone have a nicely organized report they wont mind offering up?
 
:)
 

I have 1 report entitled "Count All Inventoried Products and Versions" but the results are 10000+ so it only shows the first 10000. I may have to run the report on smaller collections until I can account for all the clients.
 
But as you can tell, if the results are 10000+, it is a bit messy. So anything else anyone has out there that they use in their environment, be most appreciative.

Can I suggest that you forward this blog post to the person asking for all ARP data.
http://support.enhansoft.com/Blogs/post/2009/10/26/How-to-Perform-a-Basic-Software-Audit.aspx

Very nice!  Mandatory reading for all managers.  They should put it in the CM help files!

I'm pinning this... because this question comes up more and more frequently by Managers who want "everything", and Garth's blog post is wonderful. As always, if someone disagrees this shouldn't be pinned, just let me know.

lol, nice read.

But still, how would you all recommend me going about this? I still need to come up with something.

Hey AMLM,
 
Do one thing... Make use of DTS (Export) service and run your query..choose an access databse (.mdb) as your destination. You will get the entire data without loss (later this can be filtered easily if your manger needs to check or audit...
 
What you say? ;-)
 
Cheers,
Jaison

Jai, that worked PERFECT. I was able to do an export on the SMS SQL DB into a MDB database, and ran the query as you said and the results came out PERFECT.
 
Showed all items in the add/remove software, and seperated it by computer name, application, version, guid, etc etc. This is exactly what I needed. Now I can just pass this MDB out to the team that needed it.
 
Good looking out !!
 
Now...if I can find a good resource on how I can learn to make those SQL queries... ;)

Enjoy!!

how to use dts???

DTS is used when you have SQL 2000 as your SMS database.

login to your SQL server -> enterprise manager -> right click on your SMS database and go for export -> give your source as 'SQL Server' and your database, and then give destination as Microsoft Access (.mdb), (before this you have to create a black access database from microsoft access), then paste whatever query that you created in the query box..
 
SELECT DisplayName0,ProdID0 as 'Product ID',count(GroupID) AS [Count Installation]
FROM v_GS_ADD_REMOVE_PROGRAMS
WHERE DisplayName0 LIKE '%'
GROUP BY DisplayName0,ProdID0
ORDER BY DisplayName0 DESC
 
then go ahead through the steps and finish the export..
 
Now you will have the result on your .MDB file that you have created...
 
Is it clear now? did you performed SQL IMPORT/EXPORT method before?
 
Let me know...

jjose,

Your post helped me a lot thank you. I ran the DTS export wizard (first time i was running the wizard) and i got my DATA (800 MB), busy siffin through it now.

Thank you again ..

Thanks for sharing information here.
God Bless!

how to deal with depression

this is a very good forum i visit it
 more often i tell to my friends about your forums
i got
 my realated informtion from your forums thank  
you for sharing.

this is a very good forum i visit it
 more often i tell to my friends about your forums
i got
 my realated informtion from your forums thank  
you for sharing.