GarthMJ

Your plan will not work the way you expect it to, it will cause a lot of headaches and will take DAYS, yes days, if not weeks to migrate everyone. The only supported HA method is to us clustered VMs, BUT I challenge you on your downtime needs. I have yet to find an org that requires CM to be up within 1 day, For that matter , 95% of all orgs can handle CM to be down to 7 days. Removing the political reasons, What technical reason is there to have CM up in under a day?

OK I will bite, Why?

I NEVER recommend using or enabling SW inventory.. Too many issues with it. Instead stick with the Hardware inventory reports, you clients will thank you. http://www.enhansoft.com/blog/slow-software-inventory-cycle-in-sccm-2012

Just create a program/package with no source file. Then deploy it as any other package. Tip make sure that you DON'T sent it to your DPs. This will generate an error and hold up the deployment to your end clients.

OK, I will bite, why do you think the results are wrong? Have you audited the results?

Exactly what report are you looking at? Those problem sound like they are for SW inventory and NOT ARP. Try a report with ARP listed within the title.

In your second query you will only find x86 versions. use v_ADD_REMOVE_PROGRAMS to get both x86 and x64.

Serial numbers are not listed within WIM class. https://msdn.microsoft.com/en-us/library/aa394363(v=vs.85).aspx Also keep in mind that Printers are a user setting and not a computer setting.

What are you Boundaries? IP Ranges, IP Subnet? AD Sites? Do you have fallback enabled for this deployment?

Have you confirm that your cert can authenticate computers via WIFI?

0x87d00231 = Transient error 0x80090006 = Invalid Signature. These would suggest that your clients don't have the right certificate in place or that your new CA is not fully trusted yet. Since you say that the MPlist is work fine this is not going to be a CM12 issue. I would focus on your CA and the Certs on the Client / CM12 itself. I would confirm that a client is working internal. Then walk it to the local coffee shop and confirm that IBCM still works correctly.

SMS_G_System_ADD_REMOVE_PROGRAMS is only 32 bit problems, Where as SMS_G_System_ADD_REMOVE_PROGRAMS_64 is 64 bit programs.

In all but rare cases, SQL should be local to CM. As for what drives DB, Log etc. should live on that question, can only be answered after understanding exactly how your server is setup.. If for example you have a VM and all the VHDs exist on the same physical disks then there is ZERO point is splitting up db, logs, etc.

Yes it is possible but it is not a simple task. in a nutshell you need to use the IIF functions and based on the value that is selected select a different report name. BTW, I will also tell you to stop using RB 3.0 and instead use BIDS or SSDT-BI, as BIDS and SSDT-BI have more features than RB 3.0.

This might work with on prem PXE DP but I have not tried it.

Yes, Why do you think otherwise?

Since there is no CM12 Current Branch (CB) and it is important to know, What version of CM are you using CM12 (SP1, SP2, R2, etc.) CMCB (1602 or 1511)

NAP should be able to do that for you.

In general, using name vs Netbiois_name will have zero affect on the results. It is easy to see, open the console find one of your computers and compare the name and NetBIOS name. in all but rare cases will they not match.

This SQL query will get you started. Select RV.Netbios_name0, SSGN.System_Group_Name0 from dbo.v_R_system_valid RV join dbo.v_RA_System_System_Group_Name SSGN on RV.ResourceId = SSGN.resourceID Where RV.Netbios_name0 = 'CAOTTANT-GJL' Order by RV.Netbios_name0

So you need to map the GPO setting to the registry key or WMI item the GPO sets and then you can create a compliance check on that.

ok, I will bite, What exactly are you trying to do? You can easily run the command that Niall post using CM12 and a package/program but I'm willing to bet that is not what you are trying to do. So what exactly are you trying to do or hope to do?

Have you tested this script outside of CM? does this script work? Have you tested it as CM would execute using the local system account on the local PC?

It is not supported to do this with CM12 however it is supported with CMCB.

I think that you posted this exact question at least three different places. Have you applied an updated to Windows 2012 R2, and therefore these updates don't apply anymore?