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
Login to the vCAC appliance (<vcac appliance FQDN/shell-ui-app/) as your user, click on Preferences in the top right hand corner to set per user.
OK, so as far as i can see this is the postgres DB on the vCAC appliance. I was able to do the following:-
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.
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).
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.