GarthMJ

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?

Are you talking Physical or Virtual? There is different lic models for each.

BTW, I almost never recommend adding IP address to any report. only in very rare cases will I recommend it... It caught too many problems..

Give this a try. http://tinyurl.com/mfkof7d

Keep in mind that neither CM07 nor CM12 will inventory EventID by default, so you will need to come up with something custom to get this to work.

No there is not.. What HW error are you looking for?

Don't get me wrong, my point about SQL restore is that are a lot of moving parts to CM12 and if the restore is not done correctly you could have problems that go unnoticed for a long time. (backup failing; SSRS security; MP / DP issues, Client inventory; SUP sync issues; for example) I would at minimum preform a site reset to help ensure that all premising and related items are hopefully fixed. For others that find this post: For CM07, you CAN'T restore CM07 using the SQL backup (No, if, and, or, buts, about it). You MUST use the CM07 backup task only. For CM12, you can recover CM12 using just the CM12 db, but you should use the Use a site database that has been manually recovered to restore the site. see docs for more details. http://technet.microsoft.com/en-us/library/gg712697.aspx#BKMK_SiteDatabaseRecoveryOption

The method that you describe above to restore your CM!2 site is NOT supported (at least not as described). I would review the Docs on how to restore your site using just a SQL db. From there preform the missing steps required to restore your site. With any luck it will allow you to get back just about everything.

So why is it impossible to advertise? This should go without any problems.

Happy New year to everyone. Did you make any New year Resolutions?

This report will get you started. http://smsug.ca/blogs/garth_jones/archive/2008/03/28/adding-user-s-ou-to-query.aspx