Hi, I have not been accessing CA Communities for a week, first I was traveling abroad for work and then we had Easter holidays. If your questions / requests are urgent, you should open a ticket with CA Support. Otherwise, myself or our peers make our best effort to respond based on our availability.
As I mentioned above, there are several ways to implement your requirement. Below I am just describing one way based on what you seem to have already configured:
1. It seems you have set up self subscribing services to request access to the physical assets. You can configure a screen that appears to users when they request access to services. Configure an attribute with a drop-down list here to allow the user to select whatever asset they need or configure the screens based on whatever information you want to collect from each user during the service request. For example, see the screenshot below:
2. You can trigger a policy xpress policy on the event AddServiceToUserEvent or you can configure fulfillment actions for the Service itself as shown on the below 2 screens:
Policy xpress:
Service fulfillment actions:
3. in the action of these policy xpress or service fullfilment policy xpress you can perform all the desired actions such as opening a service desk ticket (check out IdentityManager/IAM_Suite/IdentityManager/tools/samples/PolicyXpress/NIMIntegration for a sample service and actions for NIMintegration. I believe this example does something very similar to what you are trying to achieve.
4. As a policy xpress action or a service fulfillment action you can also assign a provisioning role to this user to provision the user's asset information to SQL Server database you created for tracking asset information. Alternatively, you can execute SQL queries from policy xpress to update the SQL Server tables directly.
I hope this helps,
KR
Russi