Experts,
I have following data in file as well as in SQL table.

#Deptname,deptnumber

I want to create group in FIM Portal with name DEPT_deptname and criteria 'user's having such deptnumber'.

Not able to find anyway.

Please suggest.

Thanks,
Mann

Hi,

Speaking off top of my head, I'd do the following:

• Establish attribute flow for group object with FIM MA,
• Do not forget to add Filter Attribute on FIM MA, add filter attribute in FIM Sycnhronization engine on group object
• I think you can go and try with Inbound Synchronization Rule for SQL MA, for filter attribute, create custom expression:
• "<Filter xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Dialect="http://schemas.microsoft.com/2006/11/XPathFilterDialect" xmlns="http://schemas.xmlsoap.org/ws/2004/09/enumeration">/Person[DeptNumber='" + deptNumber + "']</Filter>"

Again, this hasn't been tested at all (for instance, you'll have to escape quotation marks, used inside filter), but I think this approach should work for you..

Regards, P

Thanks Poulson!

As I understand, filter attribute in FIM Service is storing the criteria that we create in FIM Portal.

So I will create an inbound rule and will flow the value mentioned by you in 'filter'.

Let me try.

-Mann

Thanks Poulson!

As I understand, filter attribute in FIM Service is storing the criteria that we create in FIM Portal.

So I will create an inbound rule and will flow the value mentioned by you in 'filter'.

Let me try.

-Mann

• Marked as answer by Mann.Cool 18 hours 43 minutes ago

Thanks Poulson!

As I understand, filter attribute in FIM Service is storing the criteria that we create in FIM Portal.

So I will create an inbound rule and will flow the value mentioned by you in 'filter'.

Let me try.

-Mann

• Marked as answer by Mann.Cool Tuesday, April 22, 2014 4:14 PM