Is there a way to have members of a group auto subscribed to receive status messages.

This is important because I have a main group where I send out updates. I would like those group members to receive them via notification.

If it requires a SQL script please provide.

You should be able to go into the AF Control Panel and set subscriptions for that specific forum.

CP > Forums > Forum Name > Uncheck Inherit Group Settings > Features Tab > Auto Subscriptions

Although I'm not 100% sure if the AS group settings will override individual forum settings.

That may not work Jeff. When a forum is created automatically by Active Social, the "roles" that are added to control the security, are not real DNN roles. They would not appear in the roles drop-down list after you have enabled auto-subscriptions.

Not to mention, as soon as you uncheck Inherit Group Settings, the view/read/create/reply permissions might be screwed up, since it would no longer be using the group "roles".

There is no built in way to achieve this, but:

You could create a new DNN role and a new forum, specifically for this purpose. Set the new role as a "Linked Role" to the group (in the control panel on the group's details page.) Then set that role as the autosubscribed role for the new forum. You may need to add all the currently existing users to the role manually. Any posts made in that forum would go to all group members. If you linked the forum to the group, and made the posts via the group discussions tab, they would also appear on the group's journal.

Another way to achieve this could be to use jQuery/javascript to check if the subscribe to status checkbox is not checked and force it to be checked > save upon the page load. I am not sure about the performance impacts of this method though.

Achieving this behavior via SQL is complicated. It would require adding a row to the dbo.activesocial_Groups_Subscriptions table for each user x each group. I would not suggest doing it this way.

Thanks for the clarification Ben. I was actually interested myself once Gary raised the question. I've just not had the time to physically look into it.

I am confused about this issue: the question seems straight-forward. We have members of a group, we have AS missing the basic use case of allowing us as administrators to predefine the subscription to notices for a group. This is clear and concise. AS currently enforces the ideal that group members should learn how and then to act on the idea of checking the Subscribe toggles to allow them to realize actual notices of posts to a group. 

I am sorry you are confused, let me explain.

This is the community support forum and I can only really support features that currently exist. If you feel that this should be a built in feature in Active Social, please create a topic in the Requests forum (or post in a topic that already exists in that forum.)

I gave a few suggestions/alternatives/work-arounds that could be performed. I have not personally performed any of them. Although, I tried to list them in order of most-likely-to-work.