how do i access user login info

[zina]

hi,

I need to access user login information from project web access(which
is an asp application) to an asp.net application so that I can display
content dynamically. I have embedded the aspx page into a custom menu.
so i need to obtain the login information of PWA user. please help!
thanks in advance.

 

[Kevin W Flanagan]

Zina-

The following SQL query will get windows logon resources from PWA. If you
want all resources, delete the where clause from the query.

Select RES_NAME, WRES_NT_ACCOUNT
from MSP_WEB_RESOURCES
where WRES_USE_NT_LOGON = 1
order by RES_NAME

You can also get the email address by adding WRES_EMAIL on the first line

Hope this helps.

Kevin