Rob thanks. That does help. I think that I will end up writing my own solution using the standard insert and update objects. It's not hard in my system to...

I know that I can create a column specifically for tracking my criteria and use a sp or function to update that column. But I was trying to avoid that...

That is the account that I am logged in with. It has local admin rights to all the nodes plus it has limited domain admin rights.

Not sure if this is...

Yes the account I want to use has admin rights on all nodes.

The new service account was setup on all nodes and give full local administrative access. The account also has limited domain admin access as well.

Reporting, Analysis, SQL Agent, it depended...