GarthMJ

The issue is going to be with WQL "joins". You can't use inner join for this, they must be outer join.

That is normal, since the data can't/will not be displayed within a Collection. Use a query instead, or better yet create a report.

Use a Subselect or Collection exclusion. http://www.enhansoft.com/?s=subselect

Your best bet to fix, I hate to say it, it to contact Microsoft support (CSS). They have some non-public tools to help troubleshoot CAS and replication issue. SQL Replication is not simple, at all. I know this is not helpful but, personally unless you have 150,000 computers I would start looking at rebuilding your site using best practices. aka no CAS, understand what DR mean for CM12. Define your allowable downtime frame, this will dictate your design for example Cluster Hyper-v Hosts or define backup tasks. As soon as you have a CAS, you are begging for problems. IMO, It is a full time job to monitor and manage a CAS, because of SQL replicate.

Actually there is no extra network overhead between CL12 clients and site server because fast channel already exists within CM12 SP1. As for the collection, since you are already querying the CM database, there is only minimal overhead with respect to keeping the results updated.

Some directories/reg keys are protected, even from an Administrator. use the local System account to delete the folders.

Have you run the discovery yet?

So you know that a second primary site is NOT a DR solution, right? Did you also know that you should be doing all of your Administration on the CAS, this is the whole point of a CAS? In fact it can be dangerous to not do your work on the CAS. Have you looked at the log files?

I'm still not understanding what exactly the problem is. So you have applied a WIN to a computer????? And now you are trying to capture it?????

Ok, I will bite, why do you want to do this in the first place?

Keep in mind that the Caption filed should always say the "real" OS name, whereas the "Operation System Name and Version" attribute on the computer will give you OS Version. see the screenshot for the difference.

So like I said, you should really open a support case with Microsoft support (CSS). Missing one of the main Inbox folders is not good and you should have the whole site check over. BTW, the Afterbackup.bat doesn't exist by default, you create it to do what every you need it to do.

The product team demo a POC of this at MMS. it used the fast channel data to know if a computer is online. in worse case, it will be a max of 60 seconds out of date and that is only if the computer was disconnected from the network.

IMO you should be calling CSS directly for support. Missing an Inbox folder is a big deal and how do you know that my inbox folder is the same as yours? Why don't you look at your backups?

As pointed out by JayBone, look within resource explorer for what is listed within the caption field.

You test your scripts running as the local system account. Until they have been tested as the local system account there is not much more that can be done.

ok that does NOT use the local system account. Here is how to run as the local system account. http://verbalprocessor.com/2007/12/05/running-a-cmd-prompt-as-local-system/

When you manually test the PowerShell scripts, what account are you testing them as? How exactly are you testing them when you test them manually?

Have you run your scripts using the local system account? This is the account CM12 will use to run them, so.....

What do you mean by you run them manfully? How did you run them manually? Did you test the scripts as the local system account?

You need to give us more details, Why do you think it is not working right? what is listed for the caption on the Windows 7 computer? is the CM12 client installed on the Windows 7 computer?

Take a look at this blogs, they will help with the CI stuff. Read this post set about four files to remove from your environment. It will help you get started with CI stuff. http://www.enhansoft.com/?s=four+files&post_type=post (July 15-23rd)

ok, I will bite, why not do this via CI or Hardware inventory? This will remove all the permission issue.

I will bite, why do you think it hang? Why are you doing anything more than CCMsetup /uninstall? aka what is with all the other stuff?

If it will not work using the Local System account, then you have no other choice but to preform this task manually on each computer. I would suggest, contact AVG and talk to their support about how to fix this.