<ConfigurationFile xmlns="urn:schemas-usercube-com:configuration">

  <!-- Menus d'affichage />-->
<MenuItem Identifier="Reports" ConsolidationMode="Merge">
    <MenuItem Identifier="Reports_ResourceReconciliation" ReportQuery="ResourceReconciliation" />
    <MenuItem Identifier="Reports_ResourceReconciliationScalars" ReportQuery="ResourceReconciliationScalars" />
    <MenuItem Identifier="Reports_Workflow_ActivityInstances" ReportQuery="Workflow_ActivityInstances" />
    <MenuItem Identifier="Reports_ResourceReconciliationNavigations" ReportQuery="ResourceReconciliationNavigations" />
    <MenuItem Identifier="Reports_RoleReconciliation" ReportQuery="RoleReconciliation" />
    <MenuItem Identifier="Reports_ResourceProvisioningReviewAwaitingApproval" ReportQuery="ResourceProvisioningReviewAwaitingApproval" />
    <MenuItem Identifier="Reports_ResourceProvisioningReviewError" ReportQuery="ResourceProvisioningReviewError" />
    <MenuItem Identifier="Reports_ResourceProvisioningReviewScalars" ReportQuery="ResourceProvisioningReviewScalars" />
    <MenuItem Identifier="Reports_ResourceProvisioningReviewNavigations" ReportQuery="ResourceProvisioningReviewNavigations" />
    <MenuItem Identifier="Reports_ResourceADEntryOrphansAccount" ReportQuery="ResourceADEntryOrphansAccount" />
    <MenuItem Identifier="Reports_ResourcesADEntryActiveAccountArchivedUser" ReportQuery="ResourcesADEntryActiveAccountArchivedUser" />
    <MenuItem Identifier="Reports_ResourcesADEntryUnused" ReportQuery="ResourcesADEntryUnused" />
</MenuItem>

<!-- Rapports SQUERY />-->

<ReportQuery Identifier="ResourceReconciliation" ReturnedEntityType="AssignedResourceType" Query="join Resource re join Role r join ParametersContext pc join Owner of type Directory_User Owner select Id, re.InternalDisplayName, IsDenied, WorkflowState, OwnerType, OwnerId, ParametersContextId, r.FullName, r.TargetEntityTypeId, Owner.InternalDisplayName, Owner.Op_MainRecord_FirstName, Owner.Op_MainRecord_LastName, Owner.Op_MainRecord_Title_DisplayName, Owner.Id, Owner.PhotoTag, Owner.Op_MainRecord_Organization_DisplayName, Owner.Op_MainRecord_Site_DisplayName, Owner.Op_MainRecord_PhoneNumber, Owner.Op_MainRecord_MobileNumber, Owner.Op_MainRecord_Suspended, Owner.Op_MainRecord_VIP, Owner.Op_MainRecord_UserType_IsExternal,pc.DisplayName where (OwnerType=15 and (WorkflowState = 1 OR WorkflowState = 3) and ResourceId != null) order by OwnerId asc, Id asc" DisplayName_L1="Resource Reconciliation - Unauthorized accounts" DisplayName_L2="Ecarts de resources - Comptes non autorisés" />

<ReportQuery Identifier="ResourceReconciliationScalars" ReturnedEntityType="AssignedResourceScalar" Query="join Owner of type Directory_User Owner join Property Property join AssignedResourceType AssignedResourceType join AssignedResourceType.WorkflowInstance AssignedResourceTypeWorkflowInstance join AssignedResourceType.Role AssignedResourceTypeRole select Value,PolicyValue,WorkflowState,Id,Owner.InternalDisplayName,Property.Identifier,Property.DisplayName,AssignedResourceTypeWorkflowInstance.Identifier,AssignedResourceType.WorkflowInstanceId,AssignedResourceTypeRole.FullName,AssignedResourceTypeRole.DisplayName,StartDate,EndDate,AssignedResourceType.OwnerId,AssignedResourceType.OwnerType,AssignedResourceType.WorkflowState,AssignedResourceType.ProvisioningState,Owner.Op_MainRecord_FirstName,Owner.Op_MainRecord_LastName,Owner.Op_MainRecord_Title_DisplayName,Owner.Id,Owner.PhotoTag,Owner.Op_MainRecord_Organization_DisplayName,Owner.Op_MainRecord_Site_DisplayName,Owner.Op_MainRecord_PhoneNumber,Owner.Op_MainRecord_MobileNumber,Owner.Op_MainRecord_Suspended,Owner.Op_MainRecord_VIP,Owner.Op_MainRecord_UserType_IsExternal where (((OwnerType=15 and (WorkflowState=1 or WorkflowState=3) and (AssignedResourceType.WorkflowState=16 or AssignedResourceType.WorkflowState=18) and AssignedResourceType.ProvisioningReviewFilter!=2 and AssignedResourceType.ProvisioningReviewFilter!=16)) AND (AssignedResourceType.ConsolidatedWorkflowFoundState=1 OR AssignedResourceType.ConsolidatedWorkflowFoundState=3)) order by OwnerId asc, AssignedResourceType.ConsolidatedWorkflowFoundState asc, Id asc" DisplayName_L1="Resource Reconciliation - Unreconciled scalars properties" DisplayName_L2="Ecarts de resources - Propriétés scalaires en écart" />
 
<ReportQuery Identifier="ResourceReconciliationNavigations" DisplayName_L1="Resource Reconciliation - Unreconciled navigation properties" DisplayName_L2="Ecarts de resources - Propriétés navigations en écart" Query="join Resource Resource join PolicyResource PolicyResource join Owner of type Directory_User Owner join Property Property join AssignedResourceType AssignedResourceType join AssignedResourceType.WorkflowInstance AssignedResourceTypeWorkflowInstance join AssignedResourceType.Role AssignedResourceTypeRole select AssignedResourceTypeRole.DisplayName, Property.Identifier, Resource.InternalDisplayName, PolicyResource.InternalDisplayName, IsDenied, WorkflowState, Id, Owner.InternalDisplayName, Property.DisplayName, AssignedResourceTypeWorkflowInstance.Identifier, AssignedResourceType.WorkflowInstanceId, AssignedResourceTypeRole.FullName, StartDate, EndDate, AssignedResourceType.OwnerId, AssignedResourceType.OwnerType, AssignedResourceType.WorkflowState, AssignedResourceType.ProvisioningState, Owner.LastFirstName where ((((WorkflowState=1 or WorkflowState=3) and (AssignedResourceType.WorkflowState=16 or AssignedResourceType.WorkflowState=18) and AssignedResourceType.ProvisioningReviewFilter!=2 and AssignedResourceType.ProvisioningReviewFilter!=16)) AND (AssignedResourceType.ConsolidatedWorkflowFoundState=1 OR AssignedResourceType.ConsolidatedWorkflowFoundState=3 OR AssignedResourceType.ConsolidatedWorkflowFoundState=2)) order by OwnerId asc, AssignedResourceType.ConsolidatedWorkflowFoundState asc, Id asc" ReturnedEntityType="AssignedResourceNavigation" />

<ReportQuery Identifier="RoleReconciliation" ReturnedEntityType="AssignedSingleRole" Query="join Role r join ParametersContext pc join Owner of type Directory_User Owner select Id, IsDenied, WorkflowState, OwnerType, OwnerId, ParametersContextId, r.FullName, Owner.InternalDisplayName, Owner.Op_MainRecord_FirstName, Owner.Op_MainRecord_LastName, Owner.Op_MainRecord_Title_DisplayName, Owner.Id, Owner.PhotoTag, Owner.Op_MainRecord_Organization_DisplayName, Owner.Op_MainRecord_Site_DisplayName, Owner.Op_MainRecord_PhoneNumber, Owner.Op_MainRecord_MobileNumber, Owner.Op_MainRecord_Suspended, Owner.Op_MainRecord_VIP, Owner.Op_MainRecord_UserType_IsExternal,pc.DisplayName where (OwnerType=15 and (WorkflowState=1 or WorkflowState=3)) order by OwnerId asc, Id asc" DisplayName_L1="Role Reconciliation" DisplayName_L2="Ecarts de roles" />

<ReportQuery Identifier="Workflow_ActivityInstances" ReturnedEntityType="ActivityInstance" Query="join WorkflowInstance wi join wi.Workflow w join Activity activity join Actors actor join State state join Performer performer select w.DisplayName, wi.Identifier, activity.DisplayName, state.DisplayName, CreationDate, actor.InternalDisplayName, performer.InternalDisplayName, Subject, Body" DisplayName_L1="Tasks List" DisplayName_L2="Tâches" />
 
<ReportQuery Identifier="ResourceProvisioningReviewAwaitingApproval" ReturnedEntityType="AssignedResourceType" Query="join Resource re join Role r join ParametersContext pc join Owner of type Directory_User Owner select Id, re.InternalDisplayName, IsDenied, WorkflowState, OwnerType, OwnerId, ParametersContextId, r.FullName, r.TargetEntityTypeId, Owner.InternalDisplayName, Owner.Op_MainRecord_FirstName, Owner.Op_MainRecord_LastName, Owner.Op_MainRecord_Title_DisplayName, Owner.Id, Owner.PhotoTag, Owner.Op_MainRecord_Organization_DisplayName, Owner.Op_MainRecord_Site_DisplayName, Owner.Op_MainRecord_PhoneNumber, Owner.Op_MainRecord_MobileNumber, Owner.Op_MainRecord_Suspended, Owner.Op_MainRecord_VIP, Owner.Op_MainRecord_UserType_IsExternal,pc.DisplayName where (OwnerType=15 AND ProvisioningState=5) order by OwnerId asc, Id asc" DisplayName_L1="Provisioning Review - Awaiting verification" DisplayName_L2="Revue de Provisioning - En attente de contrôle" />

<ReportQuery Identifier="ResourceProvisioningReviewError" ReturnedEntityType="AssignedResourceType" Query="join Resource re join Role r join ParametersContext pc join Owner of type Directory_User Owner select Id, re.InternalDisplayName, IsDenied, WorkflowState, OwnerType, OwnerId, ParametersContextId, r.FullName, r.TargetEntityTypeId, Owner.InternalDisplayName, Owner.Op_MainRecord_FirstName, Owner.Op_MainRecord_LastName, Owner.Op_MainRecord_Title_DisplayName, Owner.Id, Owner.PhotoTag, Owner.Op_MainRecord_Organization_DisplayName, Owner.Op_MainRecord_Site_DisplayName, Owner.Op_MainRecord_PhoneNumber, Owner.Op_MainRecord_MobileNumber, Owner.Op_MainRecord_Suspended, Owner.Op_MainRecord_VIP, Owner.Op_MainRecord_UserType_IsExternal,pc.DisplayName where (OwnerType=15 AND ProvisioningState=3) order by OwnerId asc, Id asc" DisplayName_L1="Provisioning Review - Provisioning orders with errors" DisplayName_L2="Revue de Provisioning - Ordres de provisioning en erreur" />
 
<ReportQuery Identifier="ResourceProvisioningReviewScalars" ReturnedEntityType="AssignedResourceScalar" Query="join Owner of type Directory_User Owner join Property Property join AssignedResourceType AssignedResourceType join AssignedResourceType.WorkflowInstance AssignedResourceTypeWorkflowInstance join AssignedResourceType.Role AssignedResourceTypeRole select Value,PolicyValue,WorkflowState,Id,Owner.InternalDisplayName,Property.Identifier,Property.DisplayName,AssignedResourceTypeWorkflowInstance.Identifier,AssignedResourceType.WorkflowInstanceId,AssignedResourceTypeRole.FullName,AssignedResourceTypeRole.DisplayName,StartDate,EndDate,AssignedResourceType.OwnerId,AssignedResourceType.OwnerType,AssignedResourceType.WorkflowState,AssignedResourceType.ProvisioningState,Owner.Op_MainRecord_FirstName,Owner.Op_MainRecord_LastName,Owner.Op_MainRecord_Title_DisplayName,Owner.Id,Owner.PhotoTag,Owner.Op_MainRecord_Organization_DisplayName,Owner.Op_MainRecord_Site_DisplayName,Owner.Op_MainRecord_PhoneNumber,Owner.Op_MainRecord_MobileNumber,Owner.Op_MainRecord_Suspended,Owner.Op_MainRecord_VIP,Owner.Op_MainRecord_UserType_IsExternal where (OwnerType=15 and ProvisioningState = 5 and (AssignedResourceType.WorkflowState=16 or AssignedResourceType.WorkflowState=18) and (AssignedResourceType.ProvisioningReviewFilter!=2 and AssignedResourceType.ProvisioningReviewFilter!=16)) order by OwnerId asc, Id asc" DisplayName_L1="Provisioning Review - Scalars awaiting approval" DisplayName_L2="Revue de Provisioning - Scalaires en attente de contrôle" />

<ReportQuery Identifier="ResourceProvisioningReviewNavigations" DisplayName_L1="Provisioning Review - Navigations awaiting approval" DisplayName_L2="Revue de Provisioning - Navigations en attente de contrôle" Query="join Resource Resource join PolicyResource PolicyResource join Owner of type Directory_User Owner join Property Property join AssignedResourceType AssignedResourceType join AssignedResourceType.WorkflowInstance AssignedResourceTypeWorkflowInstance join AssignedResourceType.Role AssignedResourceTypeRole select AssignedResourceTypeRole.DisplayName, Property.Identifier, Resource.InternalDisplayName, PolicyResource.InternalDisplayName, IsDenied, WorkflowState, Id, Owner.InternalDisplayName, Property.DisplayName, AssignedResourceTypeWorkflowInstance.Identifier, AssignedResourceType.WorkflowInstanceId, AssignedResourceTypeRole.FullName, StartDate, EndDate, AssignedResourceType.OwnerId, AssignedResourceType.OwnerType, AssignedResourceType.WorkflowState, AssignedResourceType.ProvisioningState, Owner.LastFirstName where (OwnerType=15 and ProvisioningState = 5 and (AssignedResourceType.WorkflowState=16 or AssignedResourceType.WorkflowState=18) and (AssignedResourceType.ProvisioningReviewFilter!=2 and AssignedResourceType.ProvisioningReviewFilter!=16)) order by OwnerId asc, AssignedResourceType.ConsolidatedWorkflowFoundState asc, Id asc" ReturnedEntityType="AssignedResourceNavigation" />

<ReportQuery Identifier="ResourceADEntryOrphansAccount" ReturnedEntityType="AssignedResourceType" Query="join Role r join r.TargetEntityType tgt join Resource of type AD_Entry ade join Owner of type Directory_User own select Id, ade.InternalDisplayName, IsDenied, StartDate, EndDate, WorkflowState, ProvisioningState, OwnerType, OwnerId, ParametersContextId, r.FullName, r.TargetEntityTypeId, own.InternalDisplayName, own.Op_MainRecord_FirstName, own.Op_MainRecord_LastName, own.Op_MainRecord_Title_DisplayName, own.Id, own.PhotoTag, own.Op_MainRecord_Organization_DisplayName, own.Op_MainRecord_Site_DisplayName, own.Op_MainRecord_PhoneNumber, own.Op_MainRecord_MobileNumber, own.Op_MainRecord_Suspended, own.Op_MainRecord_VIP, own.Op_MainRecord_UserType_IsExternal where (tgt.Identifier=&quot;AD_Entry&quot; and own.InternalDisplayName=null)" DisplayName_L1="Orphans AD accounts" DisplayName_L2="Comptes AD orphelins" />

<ReportQuery Identifier="ResourcesADEntryActiveAccountArchivedUser" ReturnedEntityType="AssignedResourceType" Query="join Role r join r.TargetEntityType tgt join Resource of type AD_Entry ade join Owner of type Directory_User own join own.PresenceState prstt select own.InternalDisplayName, r.DisplayName, ade.dn, ade.cn, ade.userPrincipalName, ade.displayName, ade.userAccountControlBit2, ade.mail, ade.sAMAccountName, ade.c, ade.comment, ade.company, ade.department, ade.description, ade.employeeID, ade.l, ade.lastLogonTimestamp, ade.mobile, ade.pwdLastSet, ade.st, ade.telephoneNumber, ade.title, ade.userAccountControl, ade.accountExpires, ade.isUnused, ade.whenCreated, prstt.InternalDisplayName, WorkflowState, ProvisioningState, StartDate, EndDate, IsDenied where (tgt.Identifier=&quot;AD_Entry&quot; and own.InternalDisplayName!=null and ade.userAccountControlBit2=&quot;0&quot; and prstt.Identifier=&quot;A&quot;)" DisplayName_L1="Actives AD accounts of archived users" DisplayName_L2="Comptes AD actifs des collaborateurs partis" />
 
<ReportQuery Identifier="ResourcesADEntryUnused" ReturnedEntityType="AssignedResourceType" Query="join Role r join r.TargetEntityType tgt join Resource of type AD_Entry ade join Owner of type Directory_User own join own.PresenceState prstt select own.InternalDisplayName, r.DisplayName, ade.dn, ade.cn, ade.userPrincipalName, ade.displayName, ade.mail, ade.sAMAccountName, ade.c, ade.comment, ade.company, ade.department, ade.description, ade.employeeID, ade.l, ade.lastLogonTimestamp, ade.mobile, ade.pwdLastSet, ade.st, ade.telephoneNumber, ade.title, ade.userAccountControl, ade.accountExpires, ade.isUnused, ade.whenCreated, prstt.InternalDisplayName, WorkflowState, ProvisioningState, StartDate, EndDate, IsDenied where (tgt.Identifier=&quot;AD_Entry&quot; and own.InternalDisplayName!=null and ade.isUnused=true and prstt.Identifier=&quot;A&quot;)" DisplayName_L1="Unused AD accounts" DisplayName_L2="Comptes AD inutilisé" />

<!-- Access Control Rules for reports />-->

<AccessControlRule Profile="Administrator" EntityType="ReportQuery" Identifier="Custom_Administrator_Reports" DisplayName_L1="Custom_Administrator_Reports">
    <Entry Permission="/Custom/Reports/ResourceReconciliation/View" CanExecute="true" />
    <Entry Permission="/Custom/Reports/ResourceReconciliationScalars/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourceReconciliationNavigations/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/RoleReconciliation/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourceProvisioningReviewAwaitingApproval/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourceProvisioningReviewError/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourceADEntryOrphansAccount/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourcesADEntryActiveAccountArchivedUser/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourcesADEntryUnused/View" CanExecute="true" />
</AccessControlRule>
<AccessControlRule Profile="Administrator" EntityType="AssignedResourceType" Identifier="Custom_Reports_AssignedResourceType" DisplayName_L1="Custom_Reports_AssignedResourceType">
	<Entry Permission="/Custom/Reports/ResourceReconciliation/View" CanExecute="true" />
    <Entry Permission="/Custom/Reports/ResourceProvisioningReviewAwaitingApproval/View" CanExecute="true" />
	<Entry Permission="/Custom/Reports/ResourceProvisioningReviewError/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourceADEntryOrphansAccount/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourcesADEntryActiveAccountArchivedUser/View" CanExecute="true" />
     <Entry Permission="/Custom/Reports/ResourcesADEntryUnused/View" CanExecute="true" />
</AccessControlRule>
<AccessControlRule Profile="Administrator" EntityType="AssignedResourceScalar" Identifier="Custom_Reports_AssignedResourceScalar" DisplayName_L1="Custom_Reports_AssignedResourceScalar">
    <Entry Permission="/Custom/Reports/ResourceReconciliationScalars/View" CanExecute="true" />
    <Entry Permission="/Custom/Reports/ResourceProvisioningReviewScalars/View" CanExecute="true" />
</AccessControlRule>
<AccessControlRule Identifier="Administrator_Reports_AssignedResourceNavigation" DisplayName_L1="Administrator_Reports" EntityType="AssignedResourceNavigation" Profile="Administrator">
    <Entry CanExecute="true" Permission="/Custom/Reports/ResourceReconciliationNavigations/View" />
    <Entry Permission="/Custom/Reports/ResourceProvisioningReviewNavigations/View" CanExecute="true" />
</AccessControlRule>

<AccessControlRule Identifier="Administrator_Reports_AssignedSingleRole" DisplayName_L1="Administrator_Reports_AssignedSingleRole" EntityType="AssignedSingleRole" Profile="Administrator">
    <Entry CanExecute="true" Permission="/Custom/Reports/RoleReconciliation/View" />
</AccessControlRule>

<AccessControlRule Profile="Administrator" EntityType="ActivityInstance" Identifier="Administrator_Reports_ActivityInstance" DisplayName_L1="Administrator_Reports">
   <Entry Permission="/Custom/Reports/Workflow_ActivityInstances/View" CanExecute="true" />
</AccessControlRule>

</ConfigurationFile>