GarthMJ

So your source location is not unique, Hence it clean up all the old SU (directories) that no longer applied. You will need to fix you ARD and give it a unique folder. aka. \\bacb...\sources$\ADR

ADR will create directory with very specific names, they will look like random names but they are not. They will per se not replace any folders or rename any folders that you already have. This does assume that your source folder for ADR is unique for the ADR. I'm confused as to what your problem is, ADR have not changed between CM12 and CMCB. So what exactly is your problem?

This will not have been caused by and upgrade to CM1702. this is more likely a HD corruption issues. As such you should check the health of you HD.

If you love it, please review it on Amazon. Heck, I'm sure that @Niall, would be ok with you reviewing it here too. If you have question about it, I'm always around.

Personally I would look for one on CM reporting. Why because it will show you the details on using SSRS with CM. This is the one I wrote so I'm bias but I think it is good and it will work for all version of CM. https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/

In the datasets for the prompts. Have you every edited a SSRS report before? if not then you should look at that first. there are a few good books on the subject. Mine being one of them.

Edit your prompts queries and added Getdate and Datadiff to them to get the results that you are looking for.

You will need to edit the report and setup the prompts to have the floating 10 days.

http://lmgtfy.com/?s=b&q=Uninstall+Autodesk

So how do you uninstall it manually? Once you know that you can automated it.

As you already know from your others post on TechNet, No you can't do this. You only need a CAS if you have others 150,000 computers. Since you have a CMCB primary site, use that and migrate all of your clients to it. Save yourself the headache of a CAS.

Don’t miss out on a Free report giveaway for ConfigMgr! https://www.enhansoft.com/blog/asset-intelligence-computer-details-is-june-2017s-free-configmgr-report The Asset Intelligence Computer Details report is a brand new report! This report is designed to fill the gap created by ConfigMgr’s built-in AI reports. We heard that you wanted to see both the normalized and true product name software titles in one report, so you’ve got it! If you’re asking why you would need this information the answer is simple. Have you ever tried to determine who has SQL Server 2016 Management Studio (SSMS) only to discover that the normalized name is Microsoft SQL Server 2016 (all components) which not only includes SSMS, but also SQL Server Configuration Manager, SQL Server Data Tools, etc.? It’s impossible to know from the built-in AI reports who has SSMS without writing your own query, so we saved you the trouble! The Asset Intelligence Computer Details report will also display each title’s software category and software family. This information will help you better understand what each product does. For any software items with no date, the result 1980-02-14 will be displayed.

What exactly does "I did configure SSRS after installing it on Server 3 and linked it to Server 2 (CM Database)." this mean? Did you make sure that you can connect the report URL from a remote computer? Have you ensured that all firewall ports are open? Did you grant your CM site both local admin access and SA access within SQL on your SSRS server?

What is wrong with that interface? it nicely organized by folders. (Lists if you check that button) The link point to my old blog site. You should check out my new blog site. https://www.enhansoft.com/blog/ there are lots of reporting tips! Plus we talk about our free monthly report giveaway too. And for that matter this one is on Computer AI data too.

I'm not sure why you think the interface isn't nice.. it looks fine to me.. Are you looking at the Reports URL or the Reportservices URL? Sure you can edit the report and do what ever you want.. Personally I would clone the report and edit that.

yes it is really that simple. It will reinstall the client, but you will need to do that anyways.

Yes it is fully supported to do that, one of my lab is step that way. Did you configures SSRS after installing it? BTW, it is generally recommend that SQL be install with CM and it is also generally recommend that SSRS be installed with SQL.

You shouldn't be accessing the reports from the console, you should be accessing them from the web interface. The first report you are rung to run use SW inventory , which is useless and shouldn't be turn on anyways. Therefore the error is normal.

Remove your boundaries from CMCB 1606, then when you are ready move each role one at a time. Push out the client from CMCB 1702.

BTW What the SSRS error is telling you, is that the there is no SQL view called that within the CM database.

Just to be clear the MOF edit will give you no results when you don't have WMI provided installed for SQL, one of the SU removed it and it never gets put back. Or you will get duplicated results if you have two or more different version of SQL installed on the same computer. Now as for others there is product that will give you this and a lot more. PM me if you want more details.

Have you looked at the Builtin ARP reports? They should give you what you want.

I can tell you that the MOF edit listed within your first will product wildly inaccurate results. I can tell you that this blog post will help with showing you the true error within your SSRS RDL. https://www.enhansoft.com/blog/turn-on-remote-error-reporting

There are several things you can try, Uninstall and reinstall the CM client. maybe even deleted the computer form CM console first. Confirm that the results within WMI are correct Check the health of WMI; Don't destroy WMI just because.

Did you refresh the WMI on those computers to ensure that everything is correct? Have you force a full HW inventory on them?