New user added - How to set "Follow all existing accounts"

[BKS]

Dear all,

Let's say we have a new salesman joining the company. He will need to keep track of updates from all accounts, contacts and opportunities. How can I let this person follow all these at once? Now I have the idea I need to select an account, press "Follow" and do the same thing for the next account.
So basically the question is; is there an easy way to follow all accounts, contacts, etc for a new user in just a few clicks?

Thanks,
Bas

[yuri]

Hi

You can do it only by running sql query.

[BKS]

Thanks, sounds great. If you know by heart, can you tell me the query I should run? Otherwise I will take a look in the source.

[yuri]

INSERT INTO subscription (entity_id, entity_type, user_id)
SELECT id, 'Account', 'id_of_your_user' FROM account WHERE deleted = 0

[BKS]

Ah super, thanks a lot!

[SteveHar]

can this mass update "Follow" be a standard thing in the future? Would be great for user with less sql knowledge....

[yuri]

Not planned.