<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Lubomir,</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thank you very much for the examples. Using them we figured out how to create the Orphaned accounts report!</div>
<div id="Signature" class="elementToProof">
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<table id="x_zs-output-sig" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; width: 700px; color: rgb(60, 54, 58); box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<table id="x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 14px; padding-bottom: 14px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 14px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 12px; color: rgb(0, 1, 98); line-height: 14px;">Kind Regards,</span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<table id="x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 22px; padding-bottom: 2px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 22px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 20px; color: rgb(0, 1, 98); line-height: 22px; font-weight: 600;">Robbe Caes</span></p>
</td>
</tr>
<tr>
<td style="text-align: left; line-height: 18px; padding-bottom: 12px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 18px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 16px; color: rgb(255, 84, 0); line-height: 18px; font-weight: 600;">IGA Specialist</span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<table id="x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; padding-right: 20px; width: inherit; height: inherit;">
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 0px; color: rgb(60, 54, 58); line-height: 0px;"><a href="https://www.acen.eu/" target="_blank" id="OWA97ef10d5-b0dd-3ece-8ac3-27882be8033b" class="OWAAutoLink" rel="nofollow" style="text-decoration: none; margin-top: 0px; margin-bottom: 0px;"><img alt="Logo" width="178" height="87" style="width: 178px; height: 87px; max-width: 100%; margin-top: 0px; margin-bottom: 0px;" src="https://img2.gimm.io/2440cd65-5ed6-4e84-879d-6d6147718078/-/resize/356x174/image.png"></a></span></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="text-align: left; line-height: 0px; background-color: rgb(255, 84, 0); vertical-align: top; width: 2px; height: inherit;">
</td>
<td style="text-align: left; line-height: 0px; padding-right: 20px; width: inherit; height: inherit;">
</td>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; padding-right: 8px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 1px; color: rgb(60, 54, 58);"><img width="24" height="24" style="width: 24px; height: 24px; max-width: 100%; margin-top: 0px; margin-bottom: 0px;" src="https://img2.gimm.io/a4c6f625-9220-4efe-83d2-48e568599c1a/image.png"></span></p>
</td>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 12px; color: rgb(0, 1, 98); line-height: 14px;">+32 496 18 01 60 </span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align: left; line-height: 0px; padding-bottom: 6px; width: inherit; height: inherit;">
</td>
</tr>
</tbody>
</table>
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; padding-right: 8px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 1px; color: rgb(60, 54, 58);"><img width="24" height="24" style="width: 24px; height: 24px; max-width: 100%; margin-top: 0px; margin-bottom: 0px;" src="https://img2.gimm.io/10e53e9d-763a-4be6-98fa-eeca2977a790/image.png"></span></p>
</td>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 12px; color: rgb(0, 1, 98); line-height: 14px;"><a href="mailto:robbe.caes@acen.eu" target="_blank" id="OWA403401a7-65eb-5e7c-1bf8-fbadd7cf79e6" class="OWAAutoLink" rel="nofollow" style="color: rgb(0, 1, 98); text-decoration: none; display: inline; margin-top: 0px; margin-bottom: 0px;">robbe.caes@acen.eu </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align: left; line-height: 0px; padding-bottom: 6px; width: inherit; height: inherit;">
</td>
</tr>
</tbody>
</table>
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; padding-right: 8px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 1px; color: rgb(60, 54, 58);"><img width="24" height="24" style="width: 24px; height: 24px; max-width: 100%; margin-top: 0px; margin-bottom: 0px;" src="https://img2.gimm.io/1ae8c26f-8371-4eb1-a439-7868d9a3610d/image.png"></span></p>
</td>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 12px; color: rgb(0, 1, 98); line-height: 14px;"><a href="http://www.acen.eu/" target="_blank" id="OWAdec1dc11-af5d-f911-a357-2e53a5c0312b" class="OWAAutoLink" rel="nofollow" style="color: rgb(0, 1, 98); text-decoration: none; display: inline; margin-top: 0px; margin-bottom: 0px;">www.acen.eu </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align: left; line-height: 0px; padding-bottom: 6px; width: inherit; height: inherit;">
</td>
</tr>
</tbody>
</table>
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; padding-right: 8px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 1px; color: rgb(60, 54, 58);"><img width="24" height="24" style="width: 24px; height: 24px; max-width: 100%; margin-top: 0px; margin-bottom: 0px;" src="https://img2.gimm.io/32ff85f7-5c98-464f-8114-1fd12ac5e149/image.png"></span></p>
</td>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 12px; color: rgb(0, 1, 98); line-height: 14px;"><a href="https://maps.app.goo.gl/M4nC67m22KWx2XE2A" target="_blank" id="OWAac6a15a3-1e34-461c-f3f3-83233478ba6e" class="OWAAutoLink" rel="nofollow" style="color: rgb(0, 1, 98); text-decoration: none; display: inline; margin-top: 0px; margin-bottom: 0px;">Veldkant
7, 2550 Kontich </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align: left; line-height: 0px; padding-bottom: 6px; width: inherit; height: inherit;">
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<table id="x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align: left; line-height: 0px; margin: 0px; box-sizing: border-box; border-collapse: collapse; border-spacing: 0px;">
<tbody>
<tr>
<td style="text-align: left; line-height: 0px; padding-right: 8px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Arial, Helvetica, sans-serif; font-size: 1px; color: rgb(60, 54, 58);"><img width="24" height="24" style="width: 24px; height: 24px; max-width: 100%; margin-top: 0px; margin-bottom: 0px;" src="https://img2.gimm.io/e875ab9e-8ef1-4573-9dd2-d378f95d82ed/image.png"></span></p>
</td>
<td style="text-align: left; line-height: 0px; width: inherit; height: inherit;">
<p class="elementToProof" style="text-align: left; line-height: 0px; margin: 0.04px;">
<span style="font-family: Montserrat, sans-serif; font-size: 12px; color: rgb(0, 1, 98); line-height: 14px; font-weight: 700;"><a href="https://www.linkedin.com/company/98341614/admin/feed/posts/?feedType=following" target="_blank" id="OWAad9c9894-a835-9d56-87fd-11867b5c2ec5" class="OWAAutoLink" rel="nofollow" style="color: rgb(0, 1, 98); text-decoration: none; display: inline; margin-top: 0px; margin-bottom: 0px;">Follow
us </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align: left; line-height: 0px; padding-bottom: 6px; width: inherit; height: inherit;">
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align: left; line-height: 0px; padding-bottom: 16px; width: inherit; height: inherit;">
</td>
</tr>
</tbody>
</table>
<div class="elementToProof" style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Lubomir Odlevak <odlevak.lubomir@gmail.com><br>
<b>Sent:</b> Friday, June 12, 2026 15:47<br>
<b>To:</b> MidPoint General Discussion <midpoint@lists.evolveum.com><br>
<b>Cc:</b> Robbe Caes <Robbe.Caes@acen.eu><br>
<b>Subject:</b> Re: [midPoint] midPoint Digest follow-up question</font>
<div> </div>
</div>
<div>
<table border="0" cellspacing="0" cellpadding="0" width="100%" align="left" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; border:0!important; display:table!important; width:100%!important; table-layout:fixed!important; border-collapse:seperate!important; float:none!important; border-spacing:0px 0px!important">
<tbody style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; display:block!important">
<tr style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important">
<td valign="middle" width="1px" bgcolor="#A6A6A6" cellpadding="7px 2px 7px 2px" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; padding:7px 2px 7px 2px!important; background-color:#A6A6A6!important; width:0px!important">
</td>
<td valign="middle" width="100%" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 15px" color="#212121" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; width:100%!important; background-color:#EAEAEA!important; padding:7px 5px 7px 15px!important; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif!important; font-size:12px!important; font-weight:normal!important; color:#212121!important; text-align:left!important; word-wrap:break-word!important">
<div style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important">
You don't often get email from odlevak.lubomir@gmail.com. <a href="https://aka.ms/LearnAboutSenderIdentification" style="background:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; opacity:revert!important; visibility:revert!important">
Learn why this is important</a> </div>
</td>
<td valign="middle" align="left" width="75px" bgcolor="#EAEAEA" cellpadding="7px 5px 7px 5px" color="#212121" style="background:revert!important; border:revert!important; bottom:revert!important; color:revert!important; direction:revert!important; display:revert!important; font-size:revert!important; height:revert!important; letter-spacing:revert!important; line-height:revert!important; margin:revert!important; opacity:revert!important; order:revert!important; outline:revert!important; overflow:revert!important; padding:revert!important; position:revert!important; tab-size:revert!important; table-layout:revert!important; text-align:revert!important; text-indent:revert!important; text-orientation:revert!important; text-overflow:revert!important; text-transform:revert!important; top:revert!important; vertical-align:revert!important; visibility:revert!important; white-space:revert!important; width:revert!important; word-break:revert!important; word-spacing:revert!important; writing-mode:revert!important; zoom:revert!important; width:75px!important; background-color:#EAEAEA!important; padding:7px 5px 7px 5px!important; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif!important; font-size:12px!important; font-weight:normal!important; color:#212121!important; text-align:left!important; word-wrap:break-word!important">
</td>
</tr>
</tbody>
</table>
<div>
<div dir="ltr">I looked into this, and all you really need is to set up an ObjectCollection. You can define the filter there and then just reference that collection directly in your report.
<div>Please see attached files.</div>
</div>
<br>
<div class="x_gmail_quote x_gmail_quote_container">
<div dir="ltr" class="x_gmail_attr">pi 12. 6. 2026 o 14:43 Robbe Caes via midPoint <<a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a>> napísal(a):<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div class="x_msg-1529877066731635555">
<div dir="ltr">
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif">
<span style="font-size:12pt; color:rgb(0,0,0)">Hello </span><span style="font-size:11pt; color:rgb(0,0,0)">Lubomir,</span></div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
We have tried this approach as well using MQL and XML queries:</div>
<div>
<pre><div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)"><filter><br> <q:and><br> <q:ref><br> <q:path>resourceRef</q:path><br> <q:value oid="572fc2e9-dad8-4b52-955e-50c8d1ff082c" type="ResourceType"/><br> </q:ref><br> <q:equal><br> <q:path>kind</q:path><br> <q:value>ACCOUNT</q:value><br> </q:equal><br> <q:equal><br> <q:path>intent</q:path><br> <q:value>Account</q:value><br> </q:equal><br> <q:not><br> <q:equal><br> <q:path>synchronizationSituation</q:path><br> <q:value>LINKED</q:value><br> </q:equal><br> </q:not><br> </q:and><br></filter></div></pre>
</div>
<div>
<pre><div style="white-space:pre-wrap; font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)"><filter><br> <q:text><br> resourceRef matches (oid = "572fc2e9-dad8-4b52-955e-50c8d1ff082c")<br> and kind = "ACCOUNT"<br> and intent = "Account"<br> and synchronizationSituation != LINKED<br> </q:text><br></filter></div></pre>
</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
We have also tried changing LINKED to lowercase, "LINKED", linked, "linked",... but nothing seems to work.</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
When using LINKED or Linked we get back:</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<i>Path LINKED does not reference property</i></div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<i><br>
</i></div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
When using "LINKED" or "Linked" we get back:</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<i>Cannot combine on-resource and off-resource properties in a shadow search query. Encountered filter 'AND(REF: resourceRef, PRV(oid=572fc2e9-dad8-4b52-955e-50c8d1ff082c, targetType=null), targetFilter=null; EQUAL: kind, PPV(ShadowKindType:ACCOUNT); EQUAL:
intent, PPV(String:Account); NOT(EQUAL: synchronizationSituation, PPV(SynchronizationSituationType:LINKED)))'</i></div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
We are wondering if an error In our view parameter could be causing this but we don't believe this is the case. I have attached our file just in case someone wants to see in detail.</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:11pt; color:rgb(0,0,0)">
Thanks in advance!</div>
<div id="x_m_-1529877066731635555Signature">
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<table id="x_m_-1529877066731635555x_zs-output-sig" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; width:700px; color:rgb(60,54,58); box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<table id="x_m_-1529877066731635555x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:14px; padding-bottom:14px; width:inherit; height:inherit">
<p style="text-align:left; line-height:14px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:12px; color:rgb(0,1,98); line-height:14px">Kind Regards,</span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<table id="x_m_-1529877066731635555x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:22px; padding-bottom:2px; width:inherit; height:inherit">
<p style="text-align:left; line-height:22px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:20px; color:rgb(0,1,98); line-height:22px; font-weight:600">Robbe Caes</span></p>
</td>
</tr>
<tr>
<td style="text-align:left; line-height:18px; padding-bottom:12px; width:inherit; height:inherit">
<p style="text-align:left; line-height:18px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:16px; color:rgb(255,84,0); line-height:18px; font-weight:600">IGA Specialist</span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<table id="x_m_-1529877066731635555x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; padding-right:20px; width:inherit; height:inherit">
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Arial,Helvetica,sans-serif; font-size:0px; color:rgb(60,54,58); line-height:0px"><a href="https://www.acen.eu/" id="x_m_-1529877066731635555OWA9946c7e1-8774-983d-0264-74a4cd9f8c56" rel="nofollow" target="_blank" style="text-decoration:none; margin-top:0px; margin-bottom:0px"><img alt="Logo" width="178" height="87" style="width:178px; height:87px; max-width:100%; margin-top:0px; margin-bottom:0px" src="https://img2.gimm.io/2440cd65-5ed6-4e84-879d-6d6147718078/-/resize/356x174/image.png"></a></span></p>
</td>
</tr>
</tbody>
</table>
</td>
<td style="text-align:left; line-height:0px; background-color:rgb(255,84,0); vertical-align:top; width:2px; height:inherit">
</td>
<td style="text-align:left; line-height:0px; padding-right:20px; width:inherit; height:inherit">
</td>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; padding-right:8px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Arial,Helvetica,sans-serif; font-size:1px; color:rgb(60,54,58)"><img width="24" height="24" style="width:24px; height:24px; max-width:100%; margin-top:0px; margin-bottom:0px" src="https://img2.gimm.io/a4c6f625-9220-4efe-83d2-48e568599c1a/image.png"></span></p>
</td>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:12px; color:rgb(0,1,98); line-height:14px">+32 496 18 01 60 </span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align:left; line-height:0px; padding-bottom:6px; width:inherit; height:inherit">
</td>
</tr>
</tbody>
</table>
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; padding-right:8px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Arial,Helvetica,sans-serif; font-size:1px; color:rgb(60,54,58)"><img width="24" height="24" style="width:24px; height:24px; max-width:100%; margin-top:0px; margin-bottom:0px" src="https://img2.gimm.io/10e53e9d-763a-4be6-98fa-eeca2977a790/image.png"></span></p>
</td>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:12px; color:rgb(0,1,98); line-height:14px"><a href="mailto:robbe.caes@acen.eu" id="x_m_-1529877066731635555OWAe0cb30e4-6b57-4a6e-e689-5084bea161ee" rel="nofollow" target="_blank" style="color:rgb(0,1,98); text-decoration:none; display:inline; margin-top:0px; margin-bottom:0px">robbe.caes@acen.eu </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align:left; line-height:0px; padding-bottom:6px; width:inherit; height:inherit">
</td>
</tr>
</tbody>
</table>
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; padding-right:8px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Arial,Helvetica,sans-serif; font-size:1px; color:rgb(60,54,58)"><img width="24" height="24" style="width:24px; height:24px; max-width:100%; margin-top:0px; margin-bottom:0px" src="https://img2.gimm.io/1ae8c26f-8371-4eb1-a439-7868d9a3610d/image.png"></span></p>
</td>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:12px; color:rgb(0,1,98); line-height:14px"><a href="http://www.acen.eu/" id="x_m_-1529877066731635555OWA0756562d-087b-5438-96d4-24cc0c8e2bac" rel="nofollow" target="_blank" style="color:rgb(0,1,98); text-decoration:none; display:inline; margin-top:0px; margin-bottom:0px">www.acen.eu </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align:left; line-height:0px; padding-bottom:6px; width:inherit; height:inherit">
</td>
</tr>
</tbody>
</table>
<table role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; padding-right:8px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Arial,Helvetica,sans-serif; font-size:1px; color:rgb(60,54,58)"><img width="24" height="24" style="width:24px; height:24px; max-width:100%; margin-top:0px; margin-bottom:0px" src="https://img2.gimm.io/32ff85f7-5c98-464f-8114-1fd12ac5e149/image.png"></span></p>
</td>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:12px; color:rgb(0,1,98); line-height:14px"><a href="https://maps.app.goo.gl/M4nC67m22KWx2XE2A" id="x_m_-1529877066731635555OWAa82cadf1-5455-5f0d-5a30-cfee747fe2c0" rel="nofollow" target="_blank" style="color:rgb(0,1,98); text-decoration:none; display:inline; margin-top:0px; margin-bottom:0px">Veldkant
7, 2550 Kontich </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align:left; line-height:0px; padding-bottom:6px; width:inherit; height:inherit">
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<table id="x_m_-1529877066731635555x_inner-table" role="presentation" cellspacing="0" cellpadding="0" border="0" style="text-align:left; line-height:0px; margin:0px; box-sizing:border-box; border-collapse:collapse; border-spacing:0px">
<tbody>
<tr>
<td style="text-align:left; line-height:0px; padding-right:8px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Arial,Helvetica,sans-serif; font-size:1px; color:rgb(60,54,58)"><img width="24" height="24" style="width:24px; height:24px; max-width:100%; margin-top:0px; margin-bottom:0px" src="https://img2.gimm.io/e875ab9e-8ef1-4573-9dd2-d378f95d82ed/image.png"></span></p>
</td>
<td style="text-align:left; line-height:0px; width:inherit; height:inherit">
<p style="text-align:left; line-height:0px; margin:0.04px"><span style="font-family:Montserrat,sans-serif; font-size:12px; color:rgb(0,1,98); line-height:14px; font-weight:700"><a href="https://www.linkedin.com/company/98341614/admin/feed/posts/?feedType=following" id="x_m_-1529877066731635555OWAc8b566d7-6c83-0a9a-6fa1-336a1a0c66c1" rel="nofollow" target="_blank" style="color:rgb(0,1,98); text-decoration:none; display:inline; margin-top:0px; margin-bottom:0px">Follow
us </a></span></p>
</td>
</tr>
<tr>
<td colspan="2" style="text-align:left; line-height:0px; padding-bottom:6px; width:inherit; height:inherit">
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="text-align:left; line-height:0px; padding-bottom:16px; width:inherit; height:inherit">
</td>
</tr>
</tbody>
</table>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
</div>
<div><br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr style="display:inline-block; width:98%">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<b>From:</b> midPoint <<a href="mailto:midpoint-bounces@lists.evolveum.com" target="_blank">midpoint-bounces@lists.evolveum.com</a>> on behalf of
<a href="mailto:midpoint-request@lists.evolveum.com" target="_blank">midpoint-request@lists.evolveum.com</a> <<a href="mailto:midpoint-request@lists.evolveum.com" target="_blank">midpoint-request@lists.evolveum.com</a>><br>
<b>Sent:</b> Friday, June 12, 2026 13:47<br>
<b>To:</b> <a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a> <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
<b>Subject:</b> midPoint Digest, Vol 170, Issue 11 </div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-size:11pt">Send midPoint mailing list submissions to<br>
<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" id="x_m_-1529877066731635555OWA6e447c75-eae6-3783-d4a1-50fbdbcbf803" target="_blank">
https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:midpoint-request@lists.evolveum.com" target="_blank">midpoint-request@lists.evolveum.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:midpoint-owner@lists.evolveum.com" target="_blank">midpoint-owner@lists.evolveum.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of midPoint digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Orphaned accounts report not possible to create? (Robbe Caes)<br>
2. Re: Orphaned accounts report not possible to create?<br>
(Lubomir Odlevak)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Fri, 12 Jun 2026 10:07:22 +0000<br>
From: Robbe Caes <<a href="mailto:Robbe.Caes@acen.eu" target="_blank">Robbe.Caes@acen.eu</a>><br>
To: "<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
Subject: [midPoint] Orphaned accounts report not possible to create?<br>
Message-ID:<br>
<<a href="mailto:PAVPR03MB918845C783D7FFEE3B695ECA8F182@PAVPR03MB9188.eurprd03.prod.outlook.com" target="_blank">PAVPR03MB918845C783D7FFEE3B695ECA8F182@PAVPR03MB9188.eurprd03.prod.outlook.com</a>><br>
<br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
Hi,<br>
<br>
We are having trouble generating a report of orphaned accounts on our AD resource.<br>
We have tried many different filters and syntaxes to come up with a solution for this but nothing has worked.<br>
The most common error we get is:<br>
Cannot combine on-resource and off-resource properties in a shadow search query. Encountered filter 'AND(REF: resourceRef, PRV(oid=572fc2e9-dad8-4b52-955e-50c8d1ff082c, targetType=null), targetFilter=null; EQUAL: kind, PPV(ShadowKindType:ACCOUNT); EQUAL: intent,
PPV(String:Account); EQUAL: objectClass, PPV(QName:{...resource/instance-3}user); NOT(OWNED-BY(CTD ({.../common/common-3}FocusType),null,null)))'<br>
<br>
Our current filter looks like this:<br>
<br>
<filter><br>
<q:and><br>
<q:ref><br>
<q:path>resourceRef</q:path><br>
<q:value oid="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx"/><br>
</q:ref><br>
<br>
<q:equal><br>
<q:path>kind</q:path><br>
<q:value>ACCOUNT</q:value><br>
</q:equal><br>
<br>
<q:equal><br>
<q:path>intent</q:path><br>
<q:value>Account</q:value><br>
</q:equal><br>
<br>
<q:equal><br>
<q:path>objectClass</q:path><br>
<q:value xmlns:ri="<a href="http://midpoint.evolveum.com/xml/ns/public/resource/instance-3%22%3Eri:user%3C/q:value" id="x_m_-1529877066731635555OWA3a8b9644-d8b2-d0c8-106b-bd7eaecdcbb0" target="_blank">http://midpoint.evolveum.com/xml/ns/public/resource/instance-3">ri:user</q:value</a>><br>
</q:equal><br>
<br>
<q:not><br>
<q:ownedBy><br>
<q:type>FocusType</q:type><br>
</q:ownedBy><br>
</q:not><br>
</q:and><br>
</filter><br>
<br>
We have also tried using marks on accounts without owners to then filter on these marks but this does not work either.<br>
<br>
Does anyone have a solution for this? If so, please let me know how we can implement this.<br>
<br>
Kind Regards,<br>
<br>
Robbe Caes<br>
<br>
IGA Specialist<br>
<br>
[Logo]<<a href="https://www.acen.eu/" target="_blank">https://www.acen.eu/</a>><br>
<br>
[<a href="https://img2.gimm.io/a4c6f625-9220-4efe-83d2-48e568599c1a/image.png" id="x_m_-1529877066731635555OWA317f67e2-c755-d599-6091-a6dc53b28b94" target="_blank">https://img2.gimm.io/a4c6f625-9220-4efe-83d2-48e568599c1a/image.png</a>]<br>
<br>
+32 496 18 01 60<br>
<br>
[<a href="https://img2.gimm.io/10e53e9d-763a-4be6-98fa-eeca2977a790/image.png" id="x_m_-1529877066731635555OWA00c126c7-5e42-e61a-7fb4-aa3ca4d9e07d" target="_blank">https://img2.gimm.io/10e53e9d-763a-4be6-98fa-eeca2977a790/image.png</a>]<br>
<br>
<a href="mailto:robbe.caes@acen.eu" target="_blank">robbe.caes@acen.eu</a> <<a href="mailto:robbe.caes@acen.eu" id="x_m_-1529877066731635555OWA8a63fbc4-0ead-c259-a075-de570b1d2d2a" target="_blank">mailto:robbe.caes@acen.eu</a>><br>
<br>
[<a href="https://img2.gimm.io/1ae8c26f-8371-4eb1-a439-7868d9a3610d/image.png" id="x_m_-1529877066731635555OWA41dcffb2-bba5-d88e-1fac-435c66c0ff80" target="_blank">https://img2.gimm.io/1ae8c26f-8371-4eb1-a439-7868d9a3610d/image.png</a>]<br>
<br>
<a href="http://www.acen.eu" id="x_m_-1529877066731635555OWA3e9e3e9d-1f20-c7cc-c1f8-c8013ca3ed8b" target="_blank">www.acen.eu</a> <<a href="http://www.acen.eu/" id="x_m_-1529877066731635555OWA704f4b46-28a0-b44e-9908-fb89f1c96a2b" target="_blank">http://www.acen.eu/</a>><br>
<br>
[<a href="https://img2.gimm.io/32ff85f7-5c98-464f-8114-1fd12ac5e149/image.png" id="x_m_-1529877066731635555OWAecdf72a5-d6f9-a32a-606f-3a865a2ac5f3" target="_blank">https://img2.gimm.io/32ff85f7-5c98-464f-8114-1fd12ac5e149/image.png</a>]<br>
<br>
Veldkant 7, 2550 Kontich <<a href="https://maps.app.goo.gl/M4nC67m22KWx2XE2A" id="x_m_-1529877066731635555OWAc6a28fed-cff2-7bdd-e0e4-1c830f892794" target="_blank">https://maps.app.goo.gl/M4nC67m22KWx2XE2A</a>><br>
<br>
[<a href="https://img2.gimm.io/e875ab9e-8ef1-4573-9dd2-d378f95d82ed/image.png" id="x_m_-1529877066731635555OWAa727a623-ae6c-4236-9be0-8650de083463" target="_blank">https://img2.gimm.io/e875ab9e-8ef1-4573-9dd2-d378f95d82ed/image.png</a>]<br>
<br>
Follow us <<a href="https://www.linkedin.com/company/98341614/admin/feed/posts/?feedType=following" id="x_m_-1529877066731635555OWA63b65c93-cf08-f9ed-ccbc-7385fc382b39" target="_blank">https://www.linkedin.com/company/98341614/admin/feed/posts/?feedType=following</a>><br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="https://lists.evolveum.com/pipermail/midpoint/attachments/20260612/d131d867/attachment-0001.htm" id="x_m_-1529877066731635555OWA75a509f3-f64c-a677-f4c9-cb9aad3926f9" target="_blank">https://lists.evolveum.com/pipermail/midpoint/attachments/20260612/d131d867/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 12 Jun 2026 13:46:54 +0200<br>
From: Lubomir Odlevak <<a href="mailto:odlevak.lubomir@gmail.com" target="_blank">odlevak.lubomir@gmail.com</a>><br>
To: MidPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
Cc: Robbe Caes <<a href="mailto:Robbe.Caes@acen.eu" target="_blank">Robbe.Caes@acen.eu</a>><br>
Subject: Re: [midPoint] Orphaned accounts report not possible to<br>
create?<br>
Message-ID:<br>
<<a href="mailto:CABppFo5RPjYv-aDHJpVJhPyw0VhWywzadCwqaoDvMgfN2kzjww@mail.gmail.com" target="_blank">CABppFo5RPjYv-aDHJpVJhPyw0VhWywzadCwqaoDvMgfN2kzjww@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hey,<br>
<br>
I saw you were running into that on-resource/off-resource error. That<br>
usually happens when you mix objectClass and ownedBy in the same shadow<br>
query.<br>
A much easier and faster way to find orphaned accounts is to use the<br>
synchronizationSituation attribute. Instead of checking if an account has<br>
no owner, you can just filter for accounts that are not LINKED. It<br>
completely avoids that error.<br>
Here?s what the query looks like in MQL:<br>
<br>
resourceRef matches (oid = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx") and<br>
kind = "ACCOUNT" and intent = "Account" and synchronizationSituation<br>
!= LINKED<br>
<br>
Or xml way:<br>
<br>
<filter><br>
<q:and><br>
<q:ref><br>
<q:path>resourceRef</q:path><br>
<q:value oid="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx"/><br>
</q:ref><br>
<q:equal><br>
<q:path>kind</q:path><br>
<q:value>ACCOUNT</q:value><br>
</q:equal><br>
<q:equal><br>
<q:path>intent</q:path><br>
<q:value>Account</q:value><br>
</q:equal><br>
<q:not><br>
<q:equal><br>
<q:path>synchronizationSituation</q:path><br>
<q:value>linked</q:value><br>
</q:equal><br>
</q:not><br>
</q:and><br>
</filter><br>
<br>
Kind Regards<br>
Lubo<br>
<br>
pi 12. 6. 2026 o 12:42 Robbe Caes via midPoint <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
nap?sal(a):<br>
<br>
> Hi,<br>
><br>
> We are having trouble generating a report of orphaned accounts on our AD<br>
> resource.<br>
> We have tried many different filters and syntaxes to come up with a<br>
> solution for this but nothing has worked.<br>
> The most common error we get is:<br>
> Cannot combine on-resource and off-resource properties in a shadow search<br>
> query. Encountered filter 'AND(REF: resourceRef,<br>
> PRV(oid=572fc2e9-dad8-4b52-955e-50c8d1ff082c, targetType=null),<br>
> targetFilter=null; EQUAL: kind, PPV(ShadowKindType:ACCOUNT); EQUAL: intent,<br>
> PPV(String:Account); EQUAL: objectClass,<br>
> PPV(QName:{...resource/instance-3}user); NOT(OWNED-BY(CTD<br>
> ({.../common/common-3}FocusType),null,null)))'<br>
><br>
> Our current filter looks like this:<br>
><br>
> <filter><br>
> <q:and><br>
> <q:ref><br>
> <q:path>resourceRef</q:path><br>
> <q:value oid="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx"/><br>
> </q:ref><br>
><br>
> <q:equal><br>
> <q:path>kind</q:path><br>
> <q:value>ACCOUNT</q:value><br>
> </q:equal><br>
><br>
> <q:equal><br>
> <q:path>intent</q:path><br>
> <q:value>Account</q:value><br>
> </q:equal><br>
><br>
> <q:equal><br>
> <q:path>objectClass</q:path><br>
> <q:value xmlns:ri="<a href="http://midpoint.evolveum.com/xml/ns/public/resource/instance-3%22%3Eri:user%3C/q:value" id="x_m_-1529877066731635555OWA7e9b6163-aae1-c5a7-9bc1-cd69334cbb16" target="_blank">http://midpoint.evolveum.com/xml/ns/public/resource/instance-3">ri:user</q:value</a>><br>
> </q:equal><br>
><br>
> <q:not><br>
> <q:ownedBy><br>
> <q:type>FocusType</q:type><br>
> </q:ownedBy><br>
> </q:not><br>
> </q:and><br>
> </filter><br>
><br>
> We have also tried using marks on accounts without owners to then filter on these marks but this does not work either.<br>
><br>
> Does anyone have a solution for this? If so, please let me know how we can implement this.<br>
><br>
> Kind Regards,<br>
><br>
> Robbe Caes<br>
><br>
> IGA Specialist<br>
><br>
> [image: Logo] <<a href="https://www.acen.eu/" id="x_m_-1529877066731635555OWAbd879014-647a-69fb-15da-4dbfce1708a7" target="_blank">https://www.acen.eu/</a>><br>
><br>
> +32 496 18 01 60<br>
><br>
> <a href="mailto:robbe.caes@acen.eu" target="_blank">robbe.caes@acen.eu</a> <<a href="mailto:robbe.caes@acen.eu" target="_blank">robbe.caes@acen.eu</a>><br>
><br>
> <a href="http://www.acen.eu" id="x_m_-1529877066731635555OWA87d610ed-4460-0ae7-7019-6b6c1487f465" target="_blank">
www.acen.eu</a> <<a href="http://www.acen.eu/" id="x_m_-1529877066731635555OWAa2fa0151-33c5-6669-8d5e-e7735b1e4a29" target="_blank">http://www.acen.eu/</a>><br>
><br>
> Veldkant 7, 2550 Kontich <<a href="https://maps.app.goo.gl/M4nC67m22KWx2XE2A" id="x_m_-1529877066731635555OWA4e6305c5-8e04-de9f-1333-e4e0a2349b10" target="_blank">https://maps.app.goo.gl/M4nC67m22KWx2XE2A</a>><br>
><br>
> Follow us<br>
> <<a href="https://www.linkedin.com/company/98341614/admin/feed/posts/?feedType=following" id="x_m_-1529877066731635555OWA13f3ed96-a697-253c-4811-0b2cf27910fd" target="_blank">https://www.linkedin.com/company/98341614/admin/feed/posts/?feedType=following</a>><br>
><br>
> _______________________________________________<br>
> midPoint mailing list<br>
> <a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
> <a href="https://lists.evolveum.com/mailman/listinfo/midpoint" id="x_m_-1529877066731635555OWA5db59c6e-7645-8787-5c6d-b5b4ba2ec561" target="_blank">
https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="https://lists.evolveum.com/pipermail/midpoint/attachments/20260612/aaea3cc9/attachment.htm" id="x_m_-1529877066731635555OWA2f664058-2c20-41fc-fcf9-11c50c293176" target="_blank">https://lists.evolveum.com/pipermail/midpoint/attachments/20260612/aaea3cc9/attachment.htm</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" id="x_m_-1529877066731635555OWAe1295ec1-6f91-3555-0b93-4d8b63a5d07f" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br>
<br>
------------------------------<br>
<br>
End of midPoint Digest, Vol 170, Issue 11<br>
*****************************************<br>
</div>
</div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</div>
</blockquote>
</div>
</div>
</div>
</body>
</html>