SQL query to find users with an archive on a different EV server from the one they archived from.
Hi, I was hoping someone can help me write a SQL query to find out users who are being archived with a mailbox archive task on EVserver2. But the archive resides in EVserver1's storage. When archive schedule runs we are seeing very poor performance due to the items being sent from EVserver12 to EVserver1 storage service. Finding this information out will help with making sure users are on the correct exchange servers DBs and we can move them accordingly.Solved1KViews0likes2Comments