Questions[bulk-action](server)

I have a number of existing virtual machines within my vSphere datacenter. These VMs were not created using our vRealize 8 blueprints etc. However, I want to add the VMs to the vRA 8 inventory so that my users, who do not have access to vSphere, can have the ability to power them off/on, do basic reconfiguration, etc.

I believe the way to do this with vRA 7 was via a bulk import, but I can't for the life of me work out how to do such a thing on vRA 8. I know VMware changed the names of a lot of things, so hopefully the functionality is still there but is hidden away.

Is this possible?

I (attempt to, at least) maintain our SBS2003 box, which uses POP3 Connector to retrieve email. I am regularly asked to add/remove several accounts at once, usually for the same domain, and it is a laborious process to type in the details one at a time - since the only thing that varys across the accounts is the username/password/mailbox, it would be nice to be able to import from CSV or something.

Obviously, there is no way to do this through the standard interface (if there is I shall be annoyed that I missed it) but could it be done by manipulating the details directly wherever they are stored? Come to that, where are they stored? It must be somewhere in AD, in an ini file, or in the registry I guess - if someone could point me in the direction of this I could do all the legwork myself...

Is there a way to update the "Managed By" field for every group in Active Directory? I would also need to check "Manager can update membership list" also.

How do you kill a mass of MySQL queries? Here is a good approach:

mysql> SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE user='root' INTO OUTFILE '/tmp/a.txt';
mysql> source /tmp/a.txt;

Any others besides clicking them to death in MySQL Administrator GUI?

I've got a new client that wants to send batches of around 1000 emails weekly to their client list (all opt-in recipients).

Previously when I've built something for a client it has been their own mail server.

Can anyone recommend any alternatives to hosting their own mail server?

Google apps seems to have a 500 emails in 24hr limitation.

Google Groups would require recipient sign-up & wouldn't use the clients email address.

Other third party services?

Thanks.