does anyone have some SQL I can fire at the CMS DB to generate a list of LDAP Groups. I’ve tried but can’t get it to work … our IT won’t let us install the Security Viewer (and I’m not sure if it can generate an output file anyway?)
Ideally I’d like to run this SQL every night in a DIXI job to compare with an extract from the LDAP system itself … we’re in the process of trying to identify all our redundant LDAP groups as I’ve inherited a system with a large amount of redundant LDAP groups … some of which have been imported to BOBJ and some of which haven’t.
You can run something along these lines and look for the string ‘secLDAP:cn=’ although directly querying the CMS db is not recommended. The best thing to do is to write a utility using the SDK that extracts the groups to a file and then use this file as input into your DIXI job. Some people have contributed utilities to do this but I’m not sure how, or if, they could be integrated into your DIXI job.
(BOB member since 2002-10-16)
(BOB member since 2006-07-28)