GarthMJ

I generally agree with AdinE but if this is seriously only for 150 users/devices then I would think that you can do it one 1 box, assuming SCSM will allow you to install everything on 1 box.

Create a report, I think that I missed that tidbit, did you copy the SQL certificate to you local PC? And just to close off the other bit, can you run report from your RPs?

Where did you install the RP? Are you trying to access the site via the cluster or the one of the node of the cluster?

There is no best practice either way, there is few note about performance on site with 100 000 device or more. However, from a management standpoint you will have far fewer support issues with SQL be local than with it being remote. Heck I add 15 days to any project where SQL is remote due to the complexity it add and the inevitable problem that will crop up over time.

SSRS is not supported to be installed on a cluster. You can install SSRs on one or both node but each will be separate install of SSRS. In order to use CM12 RP you would need to install the RP on each node and access then via the node address not the cluster address. As an aside, I never recommend splitting SQL from the primary server.

What is causing the reboot messages? Are you sure they are CM12 Messages and not something like Windows Update?

So how are you deploying you server?

You can do this with WSUS or CM07/CM12. Are you using CM07 orCM12?

We are looking for your help! Help us about by take 2 minutes to complete this survey about SCCM reports. It will help us decide on what new reports to add to Enhance Web Reporting (EWR) and what new reports we will be giving away in the future. http://fluidsurveys.com/surveys/info-HZv/configmgr-ssrs-report-survey-sept-2013/

Then you will NEVER be able to install any service pack using CM12 and SUP.

A 1 hour MW is too short make it 4 hours.

Have you talked to the team at Flexera to see how they suggest you handle this issue? They are the best people to talk to about this.

This should be an non issue as you are using the CM12 server for SSRS, just create the reporting role on the server and then use the real CM12 db for the source.

There isn't a spreadsheet like this. if you want one you will need to create one on your own.

Have you look at the software updates Superflow on troubleshooting SU? http://technet.microsoft.com/en-us/library/ff385001.aspx

Moving to the CM07 forum... You will need to review the log file to see what is going.

Try this http://tinyurl.com/lqnlbzx

What is wrong with the query that I posted?

To be honest, I have never looked at the InventoryProvider.log, I haven't found a need to.. After a quick review of my InventoryProvider.log, it too has a number of errors, so I would suggest that they are normal.

In CM12 SW inv can literally take days to complete. The reason for this is that SW inv task is started with the lowest possible CPU priority. This is due to the high overhead within WMI. There is a rumor of an unsupported edit that will change the priority to the highest CPU priority but that will like impact your client PCs. My question to you is why use SW inv at all?

If you add IP address or subnet to the report you will end up with (might for subnets) duplicate PCs within the report. Thereby make the report not all the helpful. Add AD site to the report. The column is the AD_Site_name0 within the v_r_system view.

If you are talking to CSS (MS support) then you really shouldn’t be trying to work on the problem here. No it is not possible to save the data and move it to the new server. You CAN migrate your applications and package from one server to the new server but they both MUST be up at the same time. Personally I would challenge the CSS team about re-installing CM12. I would have thought that triggering one of the maintenance tasks would have solved this issue. Yes you might need to do some additional SQL work but that is CSS job to walk you thought the whole process.

Are all of your domains within one forest? Are you considering starting over? How many clients do you have? Best practice is for all admin to connect to the CAS and do their work there.

There is no way to do this. You could manually do this via OOB/iLo/Drac/ etc. but that means you need to logon to the PC.

I have done this many time, I wouldn't worry about rebuilding your MP.