users table?

Hello, I want to create an application that will allow admins to quickly logoff a sekected user. Basically, the functionality of the management console when you right click a user and logoff the selected session.
Does Citrix store these sessions in a data table somewhere? Is is accessable?

Any help would be great!
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

yes... stored in the DB.  Here's a VB script that reads from this DB that was created to pull some info into an excel file for logging.  I'm not sure how to log users off but this will at least give you access to the DB:

On Error Resume Next

'Dim excApp As Object, _
    'excBook As Object, _
    'excSheet As Object, _
    'intRow As Integer    

    Set excApp = CreateObject("Excel.Application")
    Set excBook = excApp.Workbooks.Add()
    Set excSheet = excBook.ActiveSheet
    excApp.DisplayAlerts = False
    Set farm = CreateObject("MetaframeCOM.MetaframeFarm")
    farm.initialize 1

    excSheet.Cells(1, 1) = "Application Name"
    excSheet.Cells(1, 2) = "Server Name"
    excSheet.Cells(1, 3) = "User Name"
    excSheet.Cells(1, 4) = "Logon Time"

    intRow = 2
    For Each session in farm.sessions
        Set Logon_Time=Session.LogonTime(True)
         Session_Connected=Logon_Time.Month&"/"&"/"&Logon_Time.Year&" "&Logon_Time.Hour&":"&Logon_Time.Minute

        'If session.sessionstate=Active Then     'Track Active Sessions only
            excSheet.Cells(intRow, 1) = session.appname
            excSheet.Cells(intRow, 2) = session.ServerName
            excSheet.Cells(intRow, 3) = session.UserName
            excSheet.Cells(intRow, 4) = Session_Connected
            intRow = intRow + 1
        'End if

    'Change the file name and path as desired
    excBook.SaveAs "T:\log.xls"
    Set excSheet = Nothing
    Set excBook = Nothing
    Set excApp = Nothing
    Set farm = Nothing

Wscript.Echo "DONE"
just curious though, why don't you want to use the CMC?
gogetsomeAuthor Commented:
Thanks mgcIT for responding. Where is the DB located and the name? What type of DB is it; SQL?

I built an Intranet applicaiton and have a dashboard for admins to quickly perform some mondane tasks, such as kicking users out of Great Plains, unlocking accounts... Often in our environment we have to log the user out of citrix too. Which takes several clicks to get the job done. For example, with the dashboard I have the great plains logout with just 2 clicks. One to populate a grid and one to logoff the user. I'm looking to do the same with the Citrix session as well.
the default database type is MS Access but it could be SQL or Oracle also.  If you went with the default it will be located at

C:\Program Files\Citrix\Independent Management Architecture\mf20.mdb

all servers will have a local copy (LHC or Local Host Cache) of this file called imalhc.mdb but only your data store will have the mf20.mdb file.  Be careful though as this database holds all the info for your farm.

if you set up citrix to use an SQL or oracle DB it would be on the database server that you specified originally.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.