I've a issue where 1500 users index is set to offline and we need to make it online.
I know we can got to EAC and bring every user from Offline index to Online but running the same for 1500 users is very bad.
I'm looking for a SQL query where I can bring all the Offline archives to Online.
Gurmeet Singh Kohli
Gurmeet, this would be done from the EV console. go to the indexing section and then manage indexes. it will present you with a few options and it should be clear from there how to proceed. you dont have to process them all at the same time, you can do them in batches or however you'd like.