FIMservice database structure for SQL reporting purpose
Hi all, To get more detail users and groups reports in FIM portal, we are planning to use SQL reporting to generate the reports. Can anyone let me know where we can find tech reference documents for FIM database structure? At least the tables which contain user and group information. Thanks a lot!
April 1st, 2010 10:20am

The FIM database structure is extremely complex, and the product group doesn't support queries against the FIM Service database. In fact they strongly advise against it. There are about 7 tables that contain the information and getting at it is complex, plus the product group could change the schema later on.David Lundell www.ilmBestPractices.com
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2010 11:24am

correct. The only supported way is to query through WebService
April 1st, 2010 11:34am

Thanks for the answer. Then is there any samples we can do reporting to FIM portal ? I didn't find sample powershell scripts in the scriptbox. Such as: How many users and groups of some specific department in total? How many users with the attribute A as true? How many users with the attribute B larger than xxx? How many users with the attribute C which is not empty? Thanks a lot for your help.
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2010 6:54pm

like.. adding a graph in FIM Portal? i don't think u can
April 1st, 2010 8:02pm

You can do rudimentary reporting relative to an object. I do this to see what Sets and Groups a user is a member of: http://www.identitychaos.com/2008/11/ilm-2-rc0-adding-group-reporting-tab-to.html You should be able to apply the same controls to the RTM RCDC's. Currently there is no "out of the box" reporting through the portal. You do have other extensibility options using the web service but currently you'd have to write those extensions yourself.Brad Turner, ILM MVP - Ensynch, Inc - www.identitychaos.com
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2010 11:48pm

Also check out Joe Zamora's FIMQueryTool http://c--shark.blogspot.com/2009/07/auditing-with-fim-query-tool.htmlDavid Lundell www.ilmBestPractices.com
April 2nd, 2010 5:58pm

You can do rudimentary reporting relative to an object. I do this to see what Sets and Groups a user is a member of: http://www.identitychaos.com/2008/11/ilm-2-rc0-adding-group-reporting-tab-to.html You should be able to apply the same controls to the RTM RCDC's. Currently there is no "out of the box" reporting through the portal. You do have other extensibility options using the web service but currently you'd have to write those extensions yourself. Brad Turner, ILM MVP - Ensynch, Inc - www.identitychaos.com Hi Brad, I tried your code in FIM 2010 RTM version. It doesn't work. After I upload the xml via RCDC and reset iis, the page cannot show and report configuration error. Can you check whether it is because of some changes in RTM or there is any thing I need to do prior to this? Thanks! Actionxp
Free Windows Admin Tool Kit Click here and download it now
April 4th, 2010 6:54pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics