GarthMJ

This report will get you started. http://smsug.ca/blogs/garth_jones/archive/2008/02/04/basic-all-in-one.aspx There are lots of this type of thing on my blog. BTW, I never recommend adding IP address to a report.

The url that you have listed is not correct. What exactly is the url that you are using? Is it Reports or ReportServer?

90 days is the default time before an PC is delete from the database. You can increase this to 370 days . To delete and PC, locate it within the console, right-click and select delete.

Which built-in report are you talking about?

You are not providing enough details.. Have you tried to upgrade them? Where exactly are you looking for this version #? Have you reviewed the logs file to detail why any upgrades have failed?

All version of the CM07 client are supported on XP.

Again Don't use that tables. This may cause problems with your CM environment. EXACT what would you like this report to look like? Post a screenshot example in excel of what you are looking for. As you have it now, it just doesn't make any sense to do what you are asking for.

First off you need to fix this query to NOT use the SQL table. you Need to use the SQL views instead. It is bad practice to use SQL tables. Adding PC, Manufacturer, model to this report will make this report not all that helpful as you will have 1 rows for each PC within the collections. What exactly are you looking to do? The details you are looking for can be found within the v_GS_Computer_System view. I never recommend adding IP address to reports as this will cause duplicate rows.

The AI Reports aren’t prefect but they are fairly good, What is your problem with them?

Without the queries you are use there is no way for anyone to answer this fully without guessing. But anything you find within CM12 console you will be in the CM12 database without exception. As for WebHD , who know you will need to contact Solarwinds to find out.

This information is not collected by CM07/CM12. You will need to find a way to inventory it first then you can report on it.

Have you look at all the report within the Software Distribution - Collections reporting category? I would start there.

What happened when you add the port number to the URL http://SCCM1:80/reports ? What happened when you try the IP address http://<IP address>:80/reports Do you have a proxy server in your environment?

SSRS normal does NOT normally use IIS.. It have it own engine.. Post a screenshot of the SSRS website working on your CM12 site server. This will tell us if the issue is on your Server or with SSRS.

So the 404 Error, means that you can't find the website and therefore you are NOT getting to the native SSRS site. You need to fix that first before working on CM12

What happens when you run the report via the native web interface? BTW I NEVER recommend running the reports via the console. http://be.enhansoft.com/post/2013/09/10/Should-Configuration-Manager-SSRS-or-ASP-Reports-be-Accessed-from-the-Browser-or-the-Console.aspx

BTW you can also get the free month report from here. http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx

First off have you look at the built-in reports like Compliance 1 - Overall Compliance? What don't you like about it? Second, You can create or hire someone to create custom reports or purchase 3rd party reports to give you what you need.

Running a Batch file like this is generally NOT recommend as it requires you to open up security on the share to al computers and it also defeats the purpose of CM07/CM12.

So I should move this post to CM12 forum or the Reporting forum? BTW you will find a ton of queries on www.smsug.ca ;-)

There are many reasons why this happens, I just delete the obsolete PCs from CM12.

Total of what? Other than removing Processor.DeviceID0 column, what exactly are you looking for?

Based on your statement above, I'm going to assume that you are CM07 and the table / views will NOT get created until inventory is returned from at least 1 PC.

Queries for what AD?

Have you confirmed that this data is being inventoried by any of your clients?