Work out folder path in which an Agent Login is located...

[pinguin]

Just wondering if anyone can guide me through the SQL that would return the path to the SWITCH name if I start with the Agent Login value.

So, if the Agent Login in question was in .../SWITCH1/Agent Logins/Top Floor/West Side/Front/123456 (where 123456 is the Agent Login), how would I work out the path between the Agent Login and the Switch if I was given the value 123456 to begin with?

Many thanks!

[Dionysis]

What are you trying to achieve with this?  Sounds like perhaps you should be using the PSDK for this type of function.

Accessing the database directly is normally frowned upon as Genesys can alter the schema with newer versions.

[Tambo]

use the search function in CME that will give you the folder path

[cavagnaro]

[quote author=Tambo link=topic=9125.msg41000#msg41000 date=1443533984]
use the search function in CME that will give you the folder path
[/quote]

I think he wants the SQL code...no clue why

[Tambo]

better hope no-one moves agents about then 

[Adam G]

I [i]think [/i]you are asking [i]"How can I get the Switch name of an Agent, by entering their LoginID, using plsql?"[/i]

Make sure you are using this Query to [i]READ ONLY[/i] and run it against your cfg database [i]at your own risk[/i]:

[font=times new roman][color=blue]SELECT CFG_AGENT_LOGIN.LOGIN_CODE,
  CFG_PERSON.FIRST_NAME,
  CFG_PERSON.LAST_NAME,
  CFG_PERSON.EMPLOYEE_ID,
  CFG_PERSON.USER_NAME,
  CFG_SWITCH.NAME AS "SWITCH NAME"
FROM CFG_AGENT_LOGIN
INNER JOIN CFG_LOGIN_INFO
ON CFG_LOGIN_INFO.AGENT_LOGIN_DBID = CFG_AGENT_LOGIN.DBID
INNER JOIN CFG_PERSON
ON CFG_LOGIN_INFO.PERSON_DBID = CFG_PERSON.DBID
INNER JOIN CFG_SWITCH
ON CFG_AGENT_LOGIN.SWITCH_DBID  = CFG_SWITCH.DBID
WHERE CFG_AGENT_LOGIN.LOGIN_CODE = '[b]XXXXXXXXX[/b]'
ORDER BY "SWITCH NAME",
  CFG_PERSON.USER_NAME[/color][/font]

[Adam G]

bump after edit

[pinguin]

Hi adamgill (and others),

I'm mortified that this thread has languished so long without a reply from me. Apologies.

That's great code, but no, I'm not attempting to identify Agents.

I'm trying to determine the folder structure in which any given Agent Login resides.

I'd like to be able to start with any given Agent Login, and be able to work out the path of the folders between the Switch and the folder in which the Agent Login lives.

In abstract, that might look like: /SWITCH/AGENT LOGINS/FOLDER 1/FOLDER 2/FOLDER 3/123456

Where 123456 is the Agent Login.

I have an idea this information is located in some relationship between CFG_FOLDER and CFG_OBJ_FOLDER, but I haven't been able to work out the relationship, so of course I could be entirely wrong about that.

Thanks again for the code above, it will definitely prove useful to me in other situations.

pinguin