Find orphaned license assignments

To call via an automation, and output a table of assignments, copy, and paste this snippet into a new automation workspace:

{"blocks":[{"id":"E3E724B2-A5E8-4865-88D6-3D32514B1181","type":"StartBlock","disabled":false,"name":"Start","displayName":"Start","comment":"","childId":"D0FA6C62-3093-4C9C-9659-486E2B18E9A2","inputs":[{"id":"run_mode","value":"manual","type":"select","structure":{}}],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":0,"y":0},{"id":"1AB4517E-0BDB-4F65-8684-B281C99022B6","type":"EndpointBlock","disabled":false,"name":"rawAPIListRequest","displayName":"Qlik Cloud Services - Raw API List Request","comment":"","childId":"61212565-8914-4A1E-B50B-BB727D346AC7","inputs":[{"id":"c3a1c780-2076-11ec-98c4-dd329f9ef682","value":"licenses/assignments","type":"string","structure":[]},{"id":"c6915fb0-2839-11ec-a450-03c7d8aebbe7","value":[{"key":"orphans","value":"true"}],"type":"object","mode":"keyValue","structure":[]}],"settings":[{"id":"maxitemcount","value":"","type":"string","structure":[]},{"id":"blendr_on_error","value":"stop","type":"select","structure":[]},{"id":"cache","value":"0","type":"select","structure":[]},{"id":"automations_censor_data","value":false,"type":"checkbox","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":0,"y":640,"loopBlockId":"E278D040-E0F4-4412-A486-163B0CEBA7A0","datasourcetype_guid":"61a87510-c7a3-11ea-95da-0fb0c241e75c","endpoint_guid":"4b993580-2072-11ec-8f59-e5aaa8656a36","endpoint_role":"list"},{"id":"D0FA6C62-3093-4C9C-9659-486E2B18E9A2","type":"ShowBlock","disabled":false,"name":"output","displayName":"Output","comment":"Note on the output","childId":"6CA09EB1-352A-471B-9E6E-BE4C177B5996","inputs":[{"id":"input","value":"Current orphaned assignments for this entitlement will be output below. Assignments are made to a user subject. Only assignments for users not in this tenant will be returned.","type":"string","structure":[]}],"settings":[{"id":"display_mode","value":"add","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":0,"y":120},{"id":"6CA09EB1-352A-471B-9E6E-BE4C177B5996","type":"ShowBlock","disabled":false,"name":"output2","displayName":"Output 2","comment":"Table header","childId":"94AD4B53-D0B3-41DB-9688-EC1F83774551","inputs":[{"id":"input","value":"| Output | User subject | Assignment type | \n| ------ | ------ | ------ |","type":"string","structure":[]}],"settings":[{"id":"display_mode","value":"add","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":0,"y":240},{"id":"E1465418-0D2E-4A0B-869B-AE85C25A1B7D","type":"ShowBlock","disabled":false,"name":"output3","displayName":"Output 3","comment":"Table output per assignment","childId":"4C83C1D5-8134-41AB-AD32-081870718B1F","inputs":[{"id":"input","value":"| {$.count} | {replace: {$.rawAPIListRequest.item.subject}, '|', '|'} | {$.rawAPIListRequest.item.type} |","type":"string","structure":[]}],"settings":[{"id":"display_mode","value":"add","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":120,"y":460},{"id":"61212565-8914-4A1E-B50B-BB727D346AC7","type":"ShowBlock","disabled":false,"name":"output4","displayName":"Output 4","comment":"Output complete.","childId":"9B9D7C14-FEFB-45FA-A860-F7CD2D02DD28","inputs":[{"id":"input","value":"Output complete for { $.count } assignments.","type":"string","structure":[]}],"settings":[{"id":"display_mode","value":"add","type":"select","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":0,"y":1300},{"id":"94AD4B53-D0B3-41DB-9688-EC1F83774551","type":"VariableBlock","disabled":false,"name":"count","displayName":"Variable - count","comment":"","childId":"1AB4517E-0BDB-4F65-8684-B281C99022B6","inputs":[],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":0,"y":360,"variableGuid":"3E60E53B-B716-4606-A095-4BB6BA3EB27F","operations":[{"id":"set_value","key":"71FD2AAB-DD64-42A6-B3BE-EC8F19BFD985","name":"Set value of { variable }","value":"0"}]},{"id":"E278D040-E0F4-4412-A486-163B0CEBA7A0","type":"VariableBlock","disabled":false,"name":"count","displayName":"Variable - count","comment":"","childId":"E1465418-0D2E-4A0B-869B-AE85C25A1B7D","inputs":[],"settings":[],"collapsed":[{"name":"loop","isCollapsed":false}],"x":120,"y":700,"variableGuid":"3E60E53B-B716-4606-A095-4BB6BA3EB27F","operations":[{"id":"add","key":"944B6106-9F1A-4D61-BA34-B69A43039C44","name":"Add to { variable }","value":"1"}]},{"id":"4C83C1D5-8134-41AB-AD32-081870718B1F","type":"UpdateJobBlock","disabled":false,"name":"updateRunTitle","displayName":"Update Run Title","comment":"","childId":null,"inputs":[{"id":"title","value":"Printing assignment { $.count }","type":"string","structure":[]}],"settings":[{"id":"automations_censor_data","value":false,"type":"checkbox","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":120,"y":820},{"id":"9B9D7C14-FEFB-45FA-A860-F7CD2D02DD28","type":"UpdateJobBlock","disabled":false,"name":"updateRunTitle2","displayName":"Update Run Title 2","comment":"","childId":null,"inputs":[{"id":"title","value":"Output complete for { $.count } assignments.","type":"string","structure":[]}],"settings":[{"id":"automations_censor_data","value":false,"type":"checkbox","structure":[]}],"collapsed":[{"name":"loop","isCollapsed":false}],"x":370,"y":820}],"variables":[{"guid":"3E60E53B-B716-4606-A095-4BB6BA3EB27F","name":"count","type":"number"},{"guid":"C824FF00-2EFF-43A1-B4ED-BD6E0395C501","name":"users","type":"object"},{"guid":"1CB3311F-0745-4623-B0C2-330B36BFE372","name":"user","type":"object"}]}