Resource Manager - User count per farm 1

[citrixchic]

Hi,

I am trying to get user count per farm. I can get reports from RM on amount of users per application, processs, server, etc but not per farm. Has anyone writen a custom report using crystal reports or something similar? I have been asked to pull out graphs showing amount of users on the farm at intervals (i.e each hour) for the week. This is something I will need to often. I can get MS Perfmon to report on TS sessions per server and output to excel, but I need to set this up for each server and then colate the information. Surely RM can do this? Any thoughts?

Thanks

 

[Ogi]

Hi,

If your struggling, you could script it!

Try:-

U:\Winnt\EnquireServer.Cmd

===========================
@Echo Off
quser /SERVER:%1| find /c "ica">U:\UserCount\%1.txt
===========================

U:\Winnt\CountUsers.Cmd
=============================
@Echo Off

REM
REM Store Date/Time Variables in Memory
REM

setlocal
for /f "tokens=2-4 delims=/ " %%a in ('date /t') do (
set dd=%%a
set mm=%%b
set yy=%%c
)
for /f "tokens=5-7 delims=:. " %%a in ('echo.^|time') do (
if not "%%c"=="" (
set hh=%%a
set mi=%%b
set ss=%%c
)
)

REM
REM Ensure the UserCount Directory Exists!
REM

IF NOT EXIST "U:\UserCount" Md U:\UserCount

REM
REM Get User Count from Each Server
REM

Call EnquireServer SERVER1
Call EnquireServer SERVER2
Call EnquireServer SERVER3
Call EnquireServer SERVER4
Call EnquireServer SERVER5
Call EnquireServer SERVER6
Call EnquireServer SERVER7
Call EnquireServer SERVER8

REM
REM Create a directory for the day
REM

IF NOT EXIST "U:\UserCount\%dd%%mm%%yy%" Md U:\UserCount\%dd%%mm%%yy%

REM
REM Copy all the individual files to a single one
REM

Copy U:\UserCount\SERVER1.Txt+U:\UserCount\SERVER2.Txt+U:\UserCount\SERVER3.Txt+U:\UserCount\SERVER4.Txt+U:\UserCount\SERVER5.Txt+U:\UserCount\SERVER6.Txt+U:\UserCount\SERVER7.Txt+U:\UserCount\SERVER8.TXT U:\UserCount\%dd%%mm%%yy%\%hh%%mi%.Txt

REM
REM Delete all the redundant files
REM

Del U:\UserCount\SERVER1.Txt
Del U:\UserCount\SERVER2.Txt
Del U:\UserCount\SERVER3.Txt
Del U:\UserCount\SERVER4.Txt
Del U:\UserCount\SERVER5.Txt
Del U:\UserCount\SERVER6.Txt
Del U:\UserCount\SERVER7.Txt
Del U:\UserCount\SERVER8.Txt

=======================================================

Instructions
------------

1) Change U: to your main drive
2) Alter the script names if you don't like them!
3) Create an AT command to run them hourly

Now, the only downside is that each file has a carriage return/line feed so you'll have to cater for that.

If that isn't worth a star....nothing is! ;-)

Hope this helps,
Carl.

 

[citrixchic]

Carl!
You got that Star mate! I will give it a go in our UAT enviroment today.
One question; where do I find CountUsers.cmd and EnquireServer.Cmd?
Thanks for your help!

 

[Ogi]

Hi,

Many Thanks!

Thats the code in between the "=" cut and paste it from this page, save the first one to be CountUsers.Cmd And the second EnquireServer.Cmd. *** Don't save the "=" line!

Then you can do copy and paste the information with the "=" below and save it as "U:\Winnt\SetupEnquireServer.Cmd"
==============================================
At 00:05 U:\Winnt\EnquireServer.Cmd
At 01:00 U:\Winnt\EnquireServer.Cmd
At 02:00 U:\Winnt\EnquireServer.Cmd
At 03:00 U:\Winnt\EnquireServer.Cmd
At 04:00 U:\Winnt\EnquireServer.Cmd
At 05:00 U:\Winnt\EnquireServer.Cmd
At 06:00 U:\Winnt\EnquireServer.Cmd
At 07:00 U:\Winnt\EnquireServer.Cmd
At 08:00 U:\Winnt\EnquireServer.Cmd
At 09:00 U:\Winnt\EnquireServer.Cmd
At 10:00 U:\Winnt\EnquireServer.Cmd
At 11:00 U:\Winnt\EnquireServer.Cmd
At 12:00 U:\Winnt\EnquireServer.Cmd
At 13:00 U:\Winnt\EnquireServer.Cmd
At 14:00 U:\Winnt\EnquireServer.Cmd
At 15:00 U:\Winnt\EnquireServer.Cmd
At 16:00 U:\Winnt\EnquireServer.Cmd
At 17:00 U:\Winnt\EnquireServer.Cmd
At 18:00 U:\Winnt\EnquireServer.Cmd
At 19:00 U:\Winnt\EnquireServer.Cmd
At 20:00 U:\Winnt\EnquireServer.Cmd
At 21:00 U:\Winnt\EnquireServer.Cmd
At 22:00 U:\Winnt\EnquireServer.Cmd
At 23:00 U:\Winnt\EnquireServer.Cmd
At 00:00 U:\Winnt\SetupEnquireServer.Cmd
=======================================================

Then all you need to do manually is:-

At 00:00 U:\Winnt\SetupEnquireServer.Cmd

Then tomorrow it will run forever (well until the server crashes and looses all the At instructions!

Does that help?

Cheers,
Carl.