Hi,I just started with Configuaration Manager, I have no previous SMS or SQL experience.I need help working out a few reports, I'm looking to get information on worksation hardware information and versions of software that is running, such as Adobe reader, office, etc.What resources can I use to structure the SQL queries to give me these reports, also I could be wrong but the included templates do not seem to do it.Thanks in advance for your help.

We have plenty of hardware reports, but if you need something different, then you could use ours as samples. For software installation, then you'd have two choices - any report with Add or Remove Programs in the title is what you want. That information comes from hardware inventory. Don't use any software inventory reports, unless you are looking for a specific file. The other option is to enable the Asset Intelligence classes in the sms_def.mof, and then run any of the large number of reports in the Asset Intelligence category. I can't believe they wouldn't have what you want. There is a separate forum to ask Asset Intelligence questions for (or to find the post on how to enable it). If you really feel you need to create your own reports, here's a link to the SQL schema for reporting - but for SMS 2003. For the most part, it will work for Configuration Manager. The docs team is working on a new doc for Configuration Manager, but it will be a little while yet. http://technet.microsoft.com/en-us/sms/bb676794.aspx#EYHAC

I am a newbe to SCCM field. I saw the link you posted, I know this is very old. Do you have the same kind of stuff for SCCM 2007. I am looking for mainly reports, queries, and doing some automation in our current organization. The structure is very complex so I need some help on this. Thanks in Advance

I know the title of the book says it is for SMS 2003; however most of the automation information in the following book still applies: SMS2003 Recipes Also, you'll want to download the ConfigMgr SDK.Standardize. Simplify. Automate.