Example of new report: Long unchanged accounts

Last modified 22 Apr 2021 17:31 +02:00

Please see Report configuration for basic information about configuration variables.

Usecase

We need create report of users which were long without changes.

Configuration

We need import object collection and report.

Object collection XML
<objectCollection oid="da51efb6-7d8d-43e5-9ea9-c55cf9b528e0">
    <name>Account shadow-raw</name>
    <type>ShadowType</type>
    <filter>
        <and>
            <ref>
                <path>resourceRef</path>
                <value oid="----OID_OF_YOUR_RESOURCE----"/>
            </ref>
            <equal>
                <path>kind</path>
                <value>account</value>
            </equal>
            <less>
                <q:path>synchronizationTimestamp</q:path>
                <q:value>2020-05-14T08:10:30.693+02:00</q:value>
            </less>
        </and>
    </filter>
    <getOptions>
        <option>
            <options>
                <raw>true</raw>
            </options>
        </option>
    </getOptions>
</objectCollection>

Please replace '----OID_OF_YOUR_RESOURCE----' with oid of your resource.

Report XML
<report>
    <name>Unchanged accounts</name>
    <assignment>
        <targetRef oid="00000000-0000-0000-0000-000000000171" relation="default" type="ArchetypeType">
            <!-- Collection report -->
        </targetRef>
    </assignment>
    <archetypeRef oid="00000000-0000-0000-0000-000000000171" relation="default" type="ArchetypeType">
        <!-- Collection report -->
    </archetypeRef>
    <roleMembershipRef oid="00000000-0000-0000-0000-000000000171" relation="default" type="ArchetypeType">
        <!-- Collection report -->
    </roleMembershipRef>
    <objectCollection>
        <collection>
            <collectionRef oid="da51efb6-7d8d-43e5-9ea9-c55cf9b528e0" relation="default" type="ObjectCollectionType">
                <!-- Account shadow R2 RAW -->
            </collectionRef>
        </collection>
        <view>
            <identifier>default-shadow</identifier>
            <column>
                <name>nameColumn</name>
                <path>name</path>
            </column>
            <column>
                <name>resourceRefColumn</name>
                <path>resourceRef</path>
                <previousColumn>nameColumn</previousColumn>
            </column>
            <column>
                <name>kindColumn</name>
                <path>kind</path>
                <previousColumn>resourceRefColumn</previousColumn>
            </column>
            <column>
                <name>intentColumn</name>
                <path xmlns="http://midpoint.evolveum.com/xml/ns/public/common/common-3">intent</path>
                <previousColumn>kindColumn</previousColumn>
            </column>
            <column>
                <name>synchronizationSituationColumn</name>
                <path>synchronizationSituation</path>
                <previousColumn>intentColumn</previousColumn>
            </column>
            <type>ShadowType</type>
        </view>
        <useOnlyReportView>true</useOnlyReportView>
    </objectCollection>
</report>