GarthMJ

The answer is always going to be it depends.. for a CM Lab you will need. 1 VM for your DC 1 VM for your CM12 server 1 VM for your test client This means, you really need ~13 GB of RAM just for your VMs. if you can give 1 core to each VM that should be enough. As with any lab the bigger the better.

First off, Why does it matter? Secondly, none of my Hyper-v VMs has a floppy drive. Not unless I enable it.

Simply create DP at each location, when setup correctly this is exactly what they are for. Don't forget to "protect" them.

You need lots of RAM and SSD are really nice to for this type of thing. But honestly why not use VPN or Direct access to access a real lab?

There is no tool that can do this. I'm sure that if you look there are some that MIGHT be able to tell you this for files and shares but not everything. You will need to do that manually.

That is the wrong directory, it should be something like "C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\PrivateAssemblies"

If I remember right all the pre-req for IE are SU, So why not deployment them via SU method?

You can't.. You can only have one active session on Workstation.

Why don't you just look for FixName: Nov15FixVer1.0, instead? I know that I'm getting my first coffee, but IMO it would make more sense to Create REG keys like. HKLM\Software\<companyname>\Updates\Nov15FixVer1.0 then have keys under it. The only way to do wild cards like this is to use a script to detect if the SU is applied or not.

So What is the failed state? why do you care about this reg key?

It would not be populated by the CU, instead it would be populated by the AI sync point

ok, I will bite, why do you want to do this?

Is if the Reg keys are NOT added when you execute the batch file via PSExec then you need to fix that before looking at CM12.

Sadly, you didn't answer any of my questions and therefore no one can help you.

1) Don't try, the CM DS name is not a valid DS. Only use the DS once you upload you report to SSRS site. Then it works. 2) When you followed this blog post http://www.enhansoft.com/blog/how-to-preview-sccm-2012-r2-ssrs-reports-in-bids ; exactly which directly did you place the dll in?

What are the reg key for this? what error are you getting? Have you tested this batchfile using PSEXEC?

You a Task Sequence to do it at once..

What permissions have you set on SSRS?

I use this trick. http://www.enhansoft.com/blog/invalid-object-name-in-sql-server-management-studio-ssms ;-)

Dumb question but are you connect to the CM12 database or the Master db?

I see no reason for you to get this error message. I commented out the McAfee custom mof stuff and the query works great.. How about you? SELECT RV.Netbios_Name0 as 'Computer Name', -- isnull(EPO.McAfeeVirusScanEnterprise, 'n/a') as 'VirusScan Enterprise', -- isnull(EPO.McAfeeAgent, 'n/a') as 'McAfee Agent', -- isnull(HIP.HostIntrusionPrevention, 'n/a') as 'Host Intrusion Prevention', isnull(RDNS.EnCaseEnterpriseAgent, 'n/a') as 'EnCase Enterprise Agent' FROM dbo.v_R_System_Valid RV /* LEFT OUTER JOIN ( SELECT RV.Netbios_Name0 AS 'ComputerName', RV.ResourceID AS 'ResourceID', ARP.Version0 AS 'McAfeeVirusScanEnterprise', EPO.Version0 AS 'McAfeeAgent' FROM dbo.v_R_System_Valid RV INNER JOIN dbo.v_Add_Remove_Programs ARP ON RV.ResourceID = ARP.ResourceID INNER JOIN dbo.v_GS_McAfeeEPO0 EPO ON RV.ResourceID = EPO.ResourceID WHERE ARP.DisplayName0 like '%VirusScan%' AND EPO.SoftwareID0 = 'EPOAGENT3000' ) EPO ON RV.ResourceID = EPO.ResourceID LEFT OUTER JOIN ( SELECT EPO.ResourceID AS 'ResourceID', EPO.Version0 AS 'HostIntrusionPrevention' FROM dbo.v_GS_McAfeeEPO0 EPO WHERE EPO.ProductName0 = 'Host Intrusion Prevention' ) HIP ON RV.ResourceID = HIP.ResourceID*/ LEFT OUTER JOIN ( SELECT SF.ResourceID AS 'ResourceID', SF.FileVersion AS 'EnCaseEnterpriseAgent' FROM dbo.v_GS_SoftwareFile SF WHERE SF.FileName = 'RDNS.exe' ) RDNS ON RV.ResourceID = RDNS.ResourceID ORDER BY RV.Netbios_Name0

What is the error?

Try this, completely untested as I don't have the McAfee mof edit. BTW, can you avoid using line numbers in your post, you have to clean them out before you can use the queries. SELECT RV.Netbios_Name0 as 'Computer Name', isnull(EPO.McAfeeVirusScanEnterprise, 'n/a') as 'VirusScan Enterprise', isnull(EPO.McAfeeAgent, 'n/a') as 'McAfee Agent', isnull(HIP.HostIntrusionPrevention, 'n/a') as 'Host Intrusion Prevention', isnull(RDNS.EnCaseEnterpriseAgent, 'n/a') as 'EnCase Enterprise Agent' FROM dbo.v_R_System_Valid RV LEFT OUTER JOIN ( SELECT RV.Netbios_Name0 AS 'ComputerName', RV.ResourceID AS 'ResourceID', ARP.Version0 AS 'McAfeeVirusScanEnterprise', EPO.Version0 AS 'McAfeeAgent' FROM dbo.v_R_System_Valid RV INNER JOIN dbo.v_Add_Remove_Programs ARP ON RV.ResourceID = ARP.ResourceID INNER JOIN dbo.v_GS_McAfeeEPO0 EPO ON RV.ResourceID = EPO.ResourceID WHERE ARP.DisplayName0 like '%VirusScan%' AND EPO.SoftwareID0 = 'EPOAGENT3000' ) EPO ON RV.ResourceID = EPO.ResourceID LEFT OUTER JOIN ( SELECT EPO.ResourceID AS 'ResourceID', EPO.Version0 AS 'HostIntrusionPrevention' FROM dbo.v_GS_McAfeeEPO0 EPO WHERE EPO.ProductName0 = 'Host Intrusion Prevention' ) HIP ON RV.ResourceID = HIP.ResourceID LEFT OUTER JOIN ( SELECT SF.ResourceID AS 'ResourceID', SF.FileVersion AS 'EnCaseEnterpriseAgent' FROM dbo.v_GS_SoftwareFile SF WHERE SF.FileName = 'RDNS.exe' ) RDNS ON RV.ResourceID = RDNS.ResourceID ORDER BY RV.Netbios_Name0

I'm not sure why you are querying ARP data, when you are not using it within the results. Notice that I fixed the second "inner join" line. BTW, The EPO View is a custom MOF edit. Try this. SELECT RV.Netbios_Name0 AS 'Computer Name', EPO.Version0 AS 'McAfee VirusScan Enterprise', EPO.Version0 AS 'McAfee Agent' FROM dbo.v_R_System_Valid RV INNER JOIN dbo.v_Add_Remove_Programs ARP ON RV.ResourceID = ARP.ResourceID INNER JOIN dbo.v_GS_McAfeeEPO0 EPO ON RV.ResourceID = EPO.ResourceID WHERE ARP.DisplayName0 like '%VirusScan%' AND EPO.SoftwareID0 = 'EPOAGENT3000'

You need to do both. But don't forget that you also need to fix all the other ones too, so that you are only querying the SQL views.