vCAC 6 enable Notifications by default for users

[CKloseFUM]

By default notification by email are disabled for the user so the user didn't receive any information about a request or a lease end of his service.

Can this be enabled by default for every user? Don't want to give new users a documentation on how they first have to configure their environment to work properly

[ArrayaBrill]

I have the same concern.  Have you found a good way to implement this by default?

[CKloseFUM · Accepted solution]

The @vCACTeam helped me with that : please see https://twitter.com/christianklose/status/457093033281216512

[Czernobog]

Hi, I somehow cannot figure out where the modification is to be done. Must this entries be done on the applaince or in the web gui?

[bugblatterbeast]

Login to the vCAC appliance (https://<vcac appliance FQDN/shell-ui-app/) as your user, click on Preferences in the top right hand corner to set per user.

[Czernobog]

The point is to enable the notifications by default, not every single time per user. I just need to know where to insert the new rows OP posted.

[bugblatterbeast]

OK, so as far as i can see this is the postgres DB on the vCAC appliance.  I was able to do the following:-

1. ssh to vCAC appliance
2. sudo -u postgres /opt/vmware/vpostgres/9.2/bin/psql postgres - to connect to the DB
3. \l - to list the DBs (assumed that "vcac" is the one you need to edit)
4. \dt - to list the tables and sure enough the following tables are available:-
5. Now you can edit the tables!

Now this is where i get stuck as i have no idea what to do next .  If you work out what to do it would be good to post what you did so others can use it.

Danny

[Czernobog]

Thanks! In the next step you can see the output of both tables:

In this example I have disabled notifications for one user - the change is being reflected in the row value change.

In usernotificationpreference the first column represents the usernames in upn format, the second - I don't know.

In usernotificationpreference_notificationdeliverymechanisms the first column represents the usernames again, the second one indicates if the notifications are enabled. I guess you have to insert each username there and tag it with a "t" to enable notifications. Maybe someone with more insight could explain what the "version" column values in the first table stand for. Also if it is possible to send notifications to a user, that has no role assigned in vCAC (the user account being available thorugh the identity stored tied to vcac though), but still should recieve status change for approvals and requests (for example a service account which has a functional mailbox tied to it, which AD group members can access, but don't use this service account to approve requests or similar).

[CKloseFUM]

As you can't enable this by default for every user i decided to run it scheduled ever night.

For easy scheduling this task i created a Workflow in vCO which makes use of the existing "Execute a custom query on a database"

Important are the parameters database and query which i created as attributes to my own workflow.

sqlString is the query for the "Execute a custom query on a database" and is a simple update on field enabled in table usernotificationpreference_notificationdeliverymechanisms

update usernotificationpreference_notificationdeliverymechanisms SET enabled=true

database is the connection to the vCAC local Postgres DB which you can configure in the vCO SQL PlugIn.

Now you can schedule it in vCO to run every night.