GarthMJ

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

BTW, I'm presenting at http://www.mmsmoa.com/, on reporting and CM12. You can still register for this event.

First, it would help if you post a link to your McAfee MOF edits. Second, without your query it is really hard for anyone to help you.

What do you need to content library? Are you talking about the source files or the actual files that client download to their PC? For the first one you can use the network share. For the second one , no it must be a local drive. but you can move it to another drive on the same server.

Have you seen Kent's blog post? http://blog.coretech.dk/kea/house-of-cardsthe-configmgr-software-update-point-and-wsus/ Sure why wouldn't you be able to upgrade to SQL 2014?

How much longer will you be running the old version? How many Client do you have in CM12?

What makes you think that?

Why don't you just upgrade the server to Windows 2012 R2? What is your issue?

What do you mean by migrate feature? BTW, I would install SQL local to CM12. A ton less headache and generally better performance.

I hate to say it but this is overlapping boundaries.

Do you have overlapping boundaries, if so this is a big no-no for site assignment. Exactly what is your command line for deploying the CM12 client in CM07? if you are not telling it what site to get assigned to they will use AD to figure this out and therefore #1 is likely the issue. If there are not boundaries in CM12, then understand the deployments MUST be setup correctly for them to work.

To close off this tread, since you posted this topic in multiple forums. https://social.technet.microsoft.com/Forums/en-US/6fa1d65d-9abd-4b9e-ba7e-649b9199a86f/microsoft-office-2010-inventory?forum=configmanagerapps The date changed because you applied a Software Update to Office. No you can't get the original date back.

From my experience, I have learn to NEVER to setup PKI for CM12/CM07, it is just too much of a pain. If CSS doesn't know what the problem is then you will likely never get an answer here either. I would continue to work with them.

You should call CSS for support, there is something weird with your environment.

First off I never recommend accessing the reports via the console too much overhead too many issues. Instead only access then via the web. Second start with a simple report. All software metering rules applied to this site. then run Software metering summarization progress then run

It sound you our PKI setup is causing problems. Try forcing all of your client to re-install.