Workflow: How can I get assets assigned to a user?
This should be easy and it seems like the built-in compents should do this, but I need to get a list of all assets owned by a user from SMP 7 and I have the user's Active Directory info (ADUserInfo). Was thinking I could use the "Common Name" attribute and map that to the "Name" attribute in the Get Assets for User component editor but not so much. Errors out stating the guid (all zeros) is invalid.
Aside from manually querying my CMDB with SQL in Workflow, does anyone have any good solutions?
The context for this is that I'm trying to automate our offboarding process and need to provide the person filling out the form (HR) with a list of all company-owned assets the selected user has in their possession.