You’re offline. This is a read only version of the page.
320
Hi,
Need to find all ENABLED users who doesn't have any security role assigned.
*This post is locked for comments
Hi,
in theory, you should be able to use advanced find in V9.. but it does not seem to work as it should.. you can also try this url (once you have logged into Dynamics) - just replace the org url, and, then, copy-paste to the address bar:
https://<YOUR_ORG_URL>/api/data/v8.2/systemusers?fetchXml=<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="systemuser">
<attribute name="fullname" />
<attribute name="businessunitid" />
<attribute name="title" />
<attribute name="address1_telephone1" />
<attribute name="positionid" />
<attribute name="systemuserid" />
<order attribute="fullname" descending="false" />
<link-entity name="systemuserroles" from="systemuserid" to="systemuserid" link-type="outer">
<link-entity name="role" from="roleid" to="roleid" link-type="outer" alias="ab" />
</link-entity>
<filter type="and">
<condition entityname="ab" attribute="roleid" operator="null" />
<condition attribute="isdisabled" operator="eq" value="true"/>
</filter>
</entity>
</fetch>
Hi,
You may find your answer here: crmbook.powerobjects.com/.../security-roles
Let me know in either case. Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (