GarthMJ

Is this for CM07 or CM12? Have you look at the built-in report for example Upgrade Assessment - Windows 7

Maybe I’m missing the obvious but there is no special trick to adding more WM to a collection. Just add them as you normally would.

sure you can setup multiply MW on a Collection.

Yes you can upgrade the OS. http://be.enhansoft.com/post/2014/01/14/Upgrading-SCCM-2012-R2s-Site-Server-Operating-System.aspx

But why would it run again? It will only do that if you have an deployment setup to install on these WS, otherwise it will not do anything..

There is a bit of a tutorial in the CM12 docs but it is really basic..

You can get the collection info. from the v_collections and v_Fullcollectionmebership view.

Why would Software Rerun?

Download the RDL, make you change via BIDS or Report Builder and upload it back to your CM12 SSRS site. Don't forget to rest your datasource. http://be.enhansoft.com/post/2010/08/26/How-to-Change-the-SSRS-Datasource.aspx\ http://be.enhansoft.com/post/2013/10/10/How-To-Upload-a-SSRS-Report-and-Change-its-Data-Source.aspx

No need to uninstall the CM12 client, Personally I would just push out your CM12 client to these new PCs. Just make sure that you are at the same client level or higher.

Stupid question is there an reason why you have combined both RBA and non-RBA data together?

No there is no way to enable this globally. You would need to edit each and every report to add this.

<Evil Grin> I like Whiskey or a Good micro brew. Just kidding.

I never seen these be exactly the same and I think that is your problem. The first one is always ReportServer and the second one is Reports. Is this a shared SSRS server? If not then change the two items back to the defaults. If so, then make sure that both URLs are different. ReportService_<sitecode> and Reports_<Sitecode>. Once fixed reinstall the RP and everything should be good.

These are not the defaults. I have to figure out how to upload pic to this forums but what exactly do you have for Web Service URL and Report Manager URL in Reporting Services Configuration Manager (part of SQL/SSRS)

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.