I saw this post  regarding routing Approval groups within a workflow based on answers to questions. We have at least one solution like this today in our environment. Is there guidance on how to dump the data for this logic? Currently we are auditing our system and I need to see how many approval workflows use this Conditional Question logic but I am unable to find the data table that contains this. I've managed to pull other data like approval workflows, groups, conditions that route to different groups based on User AD property data, etc, but I cannot find this question condition logic. I thought a table like WD_ApprovalTemplateCondition or WD_ApprovalGroupCondition or WD_ConditionalQuestion would contain such mapping but these tables are pulling BLANK when I run a select * query. Any guidance on this would be much appreciated!  ... View more

I have a requirement to see about configuring the CC property of our License Reclamation notification emails to have the Manager of the Target user of the alert. We have some scenarios where some of our targets do not always check email, and business has asked if we can CC the manager in these scenarios. Of course the Manager is dynamic so I can't statically configure each manager on the email. I've tried to see if App Portal has a property similar to ##Manager## email address but so far no luck in sending email. I know in the WD_User table there is the Manager field but it is more the metadata associated to manager including name, unique identifier, etc.  1. Is there a list somewhere of what all possible variables App Portal can use for configuring? I know there is like ##TargetUserName##, ##OrderName##, I've also seen you can pull in Question responses into Actions (ex: to push to Workflow Manager project), and so on. What all can App Portal handle?  2. Any suggestions or similar use cases on how to meet this requirement?  ... View more

I'm trying to do a custom query to report out on the Search Keywords (under Title & Description tab) associated on a catalog item in App Portal. I'm searching the WD_WebPackages table and cannot find such a field. I'm struggling locating the Search Keywords value in any other data tables. Does anyone know what table the Search Keywords data is stored in App Portal so I can update my query? Thanks!  ... View more

Hello - This is my second post on here as I am new to the Flexera/App Portal space and I have some clarification needed for a functionality on Leasing in App Portal v. 2019 R1 14.0.0.0. We have a Leased catalog item that has the option enabled: Allow user to extend lease when approval is required Allow extension only up to maximum days allowed This catalog item does require approval for Install. For this catalog item, an approved Install request adds user Machine to an AD group. Upon lease expiring, an Uninstall request is automatically triggered, user Machine is removed from AD group. First Clarification: As per my understanding - let's assume a user has Request A whose lease is about to expire 20 days from today. To renew, user is currently creating an entirely new request, Request B. This request is approved today and user Machine remains in AD group. However, Request A hasn't expired yet. So once Request A DOES expire after Request B has been approved, Request A expiration/Uninstall actually removes User machine from AD group and thus, overwrites what Request B was supposed to do - maintain user in AD group. Is this understanding correct as per what App Portal functionality does here? It seems App Portal doesn't associate the lease to the user/machine, rather associates the lease to the request itself. Hence this potential gap that can occur. Next: need to clarify: for the options we have enabled, if a User does go into Request A and instead extends their Lease rather than create Request B, this extension step will NOT retrigger approvals to the Approval process configured. Is this correct? Our use case is: that we do not want a user extending their lease without it going through approvals first, and we also don't want the leasing gap to occur where they create their new request before their previous one expires and thus has an issue. If my understanding on both above points is correct, we are considering educating our special approver to review a "Request B" request scenario and either cancel that request and extend the Request A lease themselves, or possibly cancel the Request A and proceed with Request B… Any thoughts on this solution also would be much appreciated. 🙂 ... View more