Listusermap

 4 Replies
 1 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Brett
Basic Member Send Private Message
Posts: 19
Basic Member
What tables are used to get the data for the listusermap command?
mikeP
Veteran Member Send Private Message
Posts: 151
Veteran Member

Edit: Not sure what happened, but the forum ate the code I originally posted and replaced it with a graphic of an "f" in a circle. Flash?  Facebook?   I'll try again, first removing the initial "xml" line.

 

Edit 2: Same thing, will try putting all the text in quotes

 

Edit 3: Argh. First two queries are in next response

 

===

We have a PF that creates an xref table of NTxxxxxxx to user IDs. It uses a couple Resource Queries:

This is the outer loop resource query:

See next response.

 

 

This inner loop resource query is performed once for each rec returned:

See next response.

 

For each rec returned, this transaction string is used to write a record to the xref file.

"_PDL=<!--appProdline-->&_TKN=XH30.1&_EVT=ADD&_RTN=DATA&_LFN=ALL&_TDS=IGNORE&FC=A&NTX-EMPLOYEE=<!--sEmployee-->&NTX-LOGONID=<!--rqryUsers_ID-->&NTX-UID=<!--rqryIdentities_UID-->&NTX-NTID=<!--sNTID-->&NTX-LASTNAME=<!--rqryUsers_LASTNAME-->&NTX-FIRSTNAME=<!--rqryUsers_FIRSTNAME-->&_DELIM=%09&_OUT=XML&_EOT=TRUE"

 

I'm more a SQL guy, yet to play with resource queries, so I can't offer much help as to what's really going on with these.

 

 

 

mikeP
Veteran Member Send Private Message
Posts: 151
Veteran Member
[code] [/code]


[code] )]]> [/code]
les
New Member Send Private Message
Posts: 1
New Member

What tables are use within the listusermap command

Randy
Veteran Member Send Private Message
Posts: 50
Veteran Member
No Tables. Uses LDAP / Active Directory.