GarthMJ

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.

Here are my notes about the queries and you questions. 1) It is NOT supported to query the table directly, you need to query the views. 2) You are only getting the x86 software titles because you are querying the x86 table only. instead use View. v_add_remove_programs 3) Look at the ISNULL function. 4) Use Outer joins for all queries. BTW, that is a great start.

so you can easily run both versions at the same time but you do have to watch out for a few things. The simplest thing is to speed up your deployment. Remove the boundaries from CM07. All new clients start with CM12. Use the slow network setting option for your advertisements in CM07.

yes the first two links on the page are the ones to look at. They are examples of what you are looking to do.

#1 The query you have posted will only every find software titles from an x64 computer. The reason is because of your inner joins and the Where conditions. #2 Remember that the query that you post is WQL and NOT SQL. Report builder (RB), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Data Tools for Visual Studio (SSDT) all using SQL. #2, what you are looking for an NOT a simple query. It is at least 4 different queries. These blog will get you started. http://smsug.ca/search/SearchResults.aspx?q=two #3, Break this down to its simple form and only look for 1 thing. Computer and AV Engine then repeat, for each item until you have 4 different queries. #4, Remember the ResourceID is your friend. #5 once you have the 4 queries, create the all encompassing query. See blog posts above. #6 Ignore Report Builder and use BIDS/ SSDT instead. They can do more that RB. Tip: sign up for the Enhansoft newsletter. I will be posting report building tips in the new year. http://www.enhansoft.com/blog