Filter query to get all identities with inactive managers

IdentityIQ (IIQ) IIQ Discussion and Questions
, , , ,
1

Hi all,

Can someone help with a query to find all identities with inactive managers?

This is for IIQ

Thanks in advance.

2

Are you looking for DB Query ?

3

@rishavghoshacc If you are looking for DB Query, then it is below:

SELECT i.name AS identity_name,
       m.name AS manager_name,
       m.inactive AS manager_status
FROM identityiq.spt_identity i
JOIN identityiq.spt_identity m ON i.manager = m.id
WHERE m.inactive = 1;
4

@kumarSinghM A DB query and also a filter query

5

@rishavghoshacc

  Filter filter = Filter.and(
    Filter.eq("manager.inactive", true),
    Filter.eq("inactive", false)
  );

  // Query matching identities
  QueryOptions qo = new QueryOptions();
  qo.addFilter(filter);

  Iterator it = context.search(Identity.class, qo);

  // Create a list to hold usernames
  List usernames = new ArrayList();

  // Iterate over identities and collect their names (usernames)
  while (it.hasNext()) {
    Identity id = (Identity) it.next();
    if (id != null) {
      usernames.add(id.getName()); 
    }
  }

  // Return the list of usernames
  return usernames;
6

@rishavghoshacc this is your code via Filter query.

Please mark it as solution, if this is what you are looking for,