Search based on creation Identity date in Advanced Analytics

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Which IIQ version are you inquiring about?

Version 8.1

Share all details related to your problem, including any error messages you may have received.

Hello team,

Is possible to create a population in IIQ based on the creation Identity date? Like the last creations of identities in 24 hours,

created >= {date.YESTERDAY}

I was trying to get some example but I couldn’t, for now I’m trying to get this type of value basing on actual day.

Thank you,
Regards.

2

You can try below format in filter

< Filter operation=“GT” property=“created”>
< Value>

epoch value of date

< /Value>
< /Filter>

1 Like
3

Is possible to run a script inside? Like:
In this case is a String, but can must work with long type

<GroupFilter>
    <CompositeFilter operation="OR">
      <Filter ignoreCase="true" operation="EQ" property="name">
        <Value>
          <Script>
            <Source>
              import java.lang.*;
              return "username";
            </Source>
          </Script>
        </Value>
      </Filter>
    </CompositeFilter>
  </GroupFilter>

Trying to return a type I can’t, returns a error casting from Script to String

4

You can leverage the sailpoint utils class for any conversions and yes you can run these filters in via run rule and get the values in list format and or if required in a map and implement jasper class to have a report generated.

1 Like
5

Why the filter doesn’t work? The returned value works with DATE$LONG_NUMBER

I am using this GroupDefinition

  <GroupFilter>
    <CompositeFilter operation="OR">
      <Filter operation="GT" property="created">
        <Value>
          <Script>
            <Source>
              import java.time.LocalDate;
              import java.time.ZoneId;
              import java.util.Date;
              import java.time.Instant;

              LocalDate today = LocalDate.now();

              LocalDate previousDate = today.minusDays(1);

              Instant previousDateInstant = previousDate.atStartOfDay(ZoneId.systemDefault()).toInstant();
              long timestampMillis = previousDateInstant.toEpochMilli();

              return timestampMillis;
            </Source>
          </Script>
        </Value>
      </Filter>
    </CompositeFilter>
  </GroupFilter>

Thanks

6

try adding < Date> < /Date> after < value> and before < /value>

7

Show the following error:
Caused by: org.xml.sax.SAXParseException; lineNumber: 27; columnNumber: 18; The content of element type "Date" must match "null".

8

Is the date tag properly closed with < /date>

9

Yes

imagen
imagen851×353 8.03 KB

10

Okay i guess date tag is not supported , i would expect it to work with simple string return in milliseconds, but not sure why it didn’t work

1 Like
11

this way it works for me

< GroupFilter>
< CompositeFilter operation=“OR”>
< Filter operation=“GT” property=“created”>
< Value>
< Date>1712755981437< /Date>
< /Value>
< /Filter>
< /CompositeFilter>
< /GroupFilter>

1 Like
12

Great. But do you know a way to create this long value using a Java script? I’m trying to do that based on the current system day.

13

Probably have to write a rule to generate the population object. so whenver you need to generate the population execute the rule and create the group definition object of the population.

2 Likes
14

Well, I think that’s the best way now for that.

Many thanks!!