GarthMJ

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?

I could have sworn that I added the Max function to this query. select Distinct RV.Netbios_Name0, RV.User_Name0, RV.Resource_Domain_OR_Workgr0, OS.Caption0, max(MUS.LastUsage) from v_R_SYSTEM_Valid RV inner join v_MonthlyUsageSummary MUS on RV.ResourceID = MUS.ResourceID inner join v_MeteredFiles MF ON MUS.FileID = MF.MeteredFileID left outer join dbo.v_GS_OPERATING_SYSTEM OS on RV.ResourceID = OS.ResourceID WHERE DateDiff(day, MUS.LastUsage, GetDate()) < 90 --AND MF.RuleID = 16777318 Group by RV.Netbios_Name0, RV.User_Name0, RV.Resource_Domain_OR_Workgr0, OS.Caption0 Order by RV.Netbios_Name0, RV.User_Name0, RV.Resource_Domain_OR_Workgr0, OS.Caption0 BTW, I will tell you to pay attend to my blog too and I post many helpful tips there too.

Actually your WQL code wasn't that bad. I only fixed two things (really), ensured that you only get active PCs and that you get the real OS name. If you want to learn more about reporting, <sorry for the shameless self promotion> this book can help you out https://www.amazon.com/System-Configuration-Manager-Reporting-Unleashed/dp/0672337789/ or I will be presenting at IT/Dev connections too http://www.itdevconnections.com/dc16/Public/Enter.aspx

So clone that report and edit it to give you the last 90 days. It is fairly easy to add the last logon user or top console user. Again, if you clone the report you can add anything. That is what I love about SSRS report you can create any report that you like and it will do anything that you want, it just takes time to create it. Personally I would avoid using Excel only because you are adding an extra step each month, instead I would create a SSRS will all the data that is need and formatted exactly how you want it to reduce the effort involved in this. I took the time to convert and clean up your query to give you the best results. I commented out the Rule # for my testing, you will need to undo that. select RV.Netbios_Name0, RV.User_Name0, RV.Resource_Domain_OR_Workgr0, OS.Caption0, MUS.LastUsage from v_R_SYSTEM_Valid RV inner join v_MonthlyUsageSummary MUS on RV.ResourceID = MUS.ResourceID inner join v_MeteredFiles MF ON MUS.FileID = MF.MeteredFileID left outer join dbo.v_GS_OPERATING_SYSTEM OS on RV.ResourceID = OS.ResourceID WHERE DateDiff(day, MUS.LastUsage, GetDate()) < 90 --AND MF.RuleID = 16777318 You can edit the report to get the query within any report.

Have you looked at the built-in reports for this? Computers that have run a specific metered software program Computers that have a metered program installed but have not run the program since a specified date

Technically nothing should be deleted. Instead you should add more disk space to the server. How big is you D:\? What is installed on D:\? How many clients do you have? How is you CM12 environment setup?

0x87d00231 = Transient error So it sound like you have a network error that has nothing to do with CM12

First off it is not recommend to run the report via the console. Running the report via the console add extra over head. Secondly, if you have created two RP then they will automatically show up within the console. However you will first have to change over to the other RP.

You will have to try it to find out. Since this is not supported, you will have to figure is this this work. IMO = In My Opinion

I'm glad you got it working.

You are asking the wrong person, you need to ask you client / stake holder, if they call that HA. Personally, I would question the need to have reporting HA. IMO it is a waste of money. Again, You will have to manually keep the reports consistent. As such you will need to manually write the process to this. Again, you are asking the wrong person, you need to ask your client / stake holder. IMO there is no reason to have HA for RPs.