All:

Thanks for your posts.

Fate actually helped me out in the end.

Some other folks in our organization were able to use Cold Fusion to query our Corporate LDAP database and get back values to pass in as variables to the WFSERVLET for use in WebFOCUS.

It's working quite nicely.

Joan,would you mind sharing the steps to configure or set that up. I need to pull some info from our corporate database to create variables.

Thanks

For the record, WF 7.1.1 and up has LDAP as a data adaptor. You can now query your LDAP environment with the TABLE command.

Thanks. We're still running 5.3 and have no plans to upgrade, so I guess I'm out of luck.

db,

How about calling a visual basic script to pull your variables? I use this to get full names and other items -

Set objArgs = Wscript.Arguments

if objArgs.Count = 0 then 
 Wscript.Echo  "sAMAccountName argument required. ""Jerry"" or ""*"" or ""J*"" or etc.."
 WScript.Quit (1)
End If

sam = objArgs(0)

Set oShell = CreateObject( "WScript.Shell" )
domain =oShell.ExpandEnvironmentStrings("%USERDOMAIN%")
Set objConnection = CreateObject("ADODB.Connection")
Set objCommand = CreateObject("ADODB.Command")

objConnection.Provider = "ADsDSOOBject"
objConnection.Open "Active Directory Provider"

Set FileSystem = WScript.CreateObject("Scripting.FileSystemObject")
Set OutPutFile = FileSystem.CreateTextFile("username.txt", True) 

Set objCommand.ActiveConnection = objConnection
Set objRootDSE = GetObject("LDAP://RootDSE")

'Get domain
strDNSDomain = objRootDSE.Get("defaultNamingContext")
strBase = "<LDAP://" & strDNSDomain & ">"

'Define the filter elements
strFilter = "(&(objectCategory=person)(objectClass=user)(sAMAccountName=" & sam & "))"

'List all attributes you will require
strAttributes = "sAMAccountName,distinguishedName,name"

'compose query
strQuery = strBase & ";" & strFilter & ";" & strAttributes & ";subtree"
objCommand.CommandText = strQuery
objCommand.Properties("Page Size") = 99999
objCommand.Properties("Timeout") = 300
objCommand.Properties("Cache Results") = False

Set objRecordSet = objCommand.Execute

objRecordSet.MoveFirst
Do Until objRecordSet.EOF
    strSA = objRecordSet.Fields("sAMAccountName")
    strDN = objRecordSet.Fields("distinguishedName")
    strUserName = objRecordSet.Fields("name")
    strDomainUser = domain & "/" & strSA
    Set objUser = GetObject("WinNT://" & strDomainUser ) 
    Desc = objUser.Description
'        Wscript.Echo """" & strDN & """"
'        Wscript.Echo """" & strSA & """;""" & strUserName & """;""" & strDN  & """;""" & Desc  & """"
' Now write that string to a file which is created
' within the EDATEMP folder and is therefore temporary
    OutPutFile.WriteLine  """" & strSA & """;""" & strUserName & """;""" & strDN  & """;""" & Desc  & """"
'    OutPutFile.WriteLine strSA & "	;	" & strUserName
    objRecordSet.MoveNext
Loop

' Clean up.
objConnection.Close
Set objConnection = Nothing
Set objCommand = Nothing
Set objRootDSE = Nothing
Set objRecordSet = Nothing

Which I call with a DOS bat job -

getUserd.vbs smith*

Have a play with it

T

quote:

Originally posted by dhagen:
For the record, WF 7.1.1 and up has LDAP as a data adaptor. You can now query your LDAP environment with the TABLE command.

Could you please explain how this might be done? Do you have any examples? We are on 7.1.3 and would like to access a corporate LDAP. We currently are using CGI, HTML and Javascript in our application.

WebFOCUS LDAP Adapter, A fairly new adapter is the WebFOCUS LDAP Adapter which when configured can be used to Query LDAP or AD to reterive information. I have recently installed this at a customer site and with a few changes to the Master File Description that the Adapter creates I was able to access information from AD. In Querying AD a big benefit I saw was the ability to get a users mail address. Now with the LDAP Adapter and Report Casters ability to create dynamic distribution list WebFOCUS can create those list from extracts from LDAP/AD. Another Key advantged that a AD Administrator pointed out to me is being able to create reports that can be used to audit her AD Environment.

Hope this Helps