gogetsome
asked on
users table?
Hello, I want to create an asp.net 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!
Does Citrix store these sessions in a data table somewhere? Is is accessable?
Any help would be great!
just curious though, why don't you want to use the CMC?
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
On Error Resume Next
'Dim excApp As Object, _
'excBook As Object, _
'excSheet As Object, _
'intRow As Integer
Set excApp = CreateObject("Excel.Applic
Set excBook = excApp.Workbooks.Add()
Set excSheet = excBook.ActiveSheet
excApp.DisplayAlerts = False
Set farm = CreateObject("MetaframeCOM
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.LogonTi
Session_Connected=Logon_Ti
'If session.sessionstate=Activ
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
Next
'Change the file name and path as desired
excBook.SaveAs "T:\log.xls"
excBook.Close
Set excSheet = Nothing
Set excBook = Nothing
Set excApp = Nothing
Set farm = Nothing
Wscript.Echo "DONE"