Sametime: Monitoring the health of you Sametime Environment: Difference between revisions

From Wiki
No edit summary
No edit summary
Line 1: Line 1:


{| class="wikitable"
|-
! Product !! Port !! Urls !! Details
|-
| '''Sametime System Console''' || 8700 ||
* <nowiki>http://serverhostname.domain:8700/ibm/console</nowiki>
|| Example


= Sametime Community servers =
|-
| '''Sametime Community Server''' || 80, 443 ||
* <nowiki>http://serverhostname.domain/stcenter.nsf</nowiki>
* <nowiki>http://serverhostname.domain/stats</nowiki>
|| * [[IBM Domino: Monitoring the health of you Domino Server using HTTP and show stats]]
|-
| '''Sametime Proxy Server:''' || Example ||
* <nowiki>http://serverhostname.domain:9080/stwebclient/index.jsp</nowiki>
|| Url Check
|-
| '''Sametime Meeting Server:''' || Example ||
* <nowiki>http://serverhostname.domain/stmeetings/</nowiki>


* [[IBM Domino: Monitoring the health of you Domino Server using HTTP and show stats]]
* <nowiki>http://serverhostname.domain:9080/stmeetings/</nowiki>


= Sametime Proxy =
||
 
If you do a get using basic authentication, you can parse for:
Check urls:
 
<nowiki>https://<SAMETIME_PROXY_SERVER:PORT>/stwebclient/index.jsp</nowiki>
 
==Sametime Proxy  - DB2==
 
1) Connect to database STPR
 
2) Use this select:
 
select * from STPROXY.STP_IMMSG
 
= Sametime Meetings =
 
Check urls:
  <nowiki>https://<SAMETIME_MEETING_SERVER:PORT>/stmeetings/</nowiki>
 
If you do a get using basic authentication, in can parse for:


   displayName= "wsadmin"
   displayName= "wsadmin"
 
|-
==Sametime Meetings  - DB2==
| '''Sametime Media Manager:''' || Example ||
 
* <nowiki>http://serverhostname.domain:9081</nowiki>
1) Connect to database STMS
||
 
2) Use this select:
 
select * from MTG.CONFIGURATION
 
 
== Sametime Active Meeting Rooms on DB2 ==
 
1) Connect to database STMS
 
2) Use this select:
 
SELECT COUNT(*) AS VALUE FROM MTG.ROOM R WHERE ACTIVE_STATE = 'ACTIVE'
 
3) Threshold can be
 
100
==Sametime Meeting Active Users on DB2 ==
 
1) Connect to database STMS
 
2) Use this select:
 
SELECT COUNT(*) AS VALUE FROM MTG.ROOM_USER RU, MTG.ROOM R WHERE RU.ROOM_ID = R.ROOM_ID
 
3) Threshold can be
 
3000
 
= Sametime VMGR =
 
Check urls:
 
  https://<SAMETIME_VMGR_SERVER>:74431/api/lb/rest/status
 
Parse for:
 
  Alive
 
SolidDB - Necessário JDBC Drivers soliddb
 
  stvmgr901.company.com_db_user=admin
  stvmgr901.company.com_db_pw=
  stvmgr901.company.com_db_port=2315
  stvmgr901.company.com1_db_sql=select count (*)  FROM PERSISTEDUSERINFO_INDIVIDUALROLES
 
  #Monitoring size of the DB, you must be the follow command as is below (Case sensitive).  size parameter is in KB
  stvmgr901.company.com2_db_sql=ADMIN COMMAND 'info dbsize'
  stvmgr901.company.com2_db_size=600000
 
  stvmgr902.company.com_db_user=user
  stvmgr902.company.com_db_pw=
  stvmgr902.company.com_db_port=2315
  stvmgr902.company.com1_db_sql=select count (*)  FROM PERSISTEDUSERINFO_INDIVIDUALROLES
  #Monitoring size of the DB, you must be the follow command as is below (Case sensitive).  size parameter is in KB
  #stvmgr902.company.com2_db_sql=ADMIN COMMAND 'info dbsize'
  #stvmgr902.company.com2_db_size=600000
 
=Sametime A/V=
 
Check urls:
  http://stmsip903.company.com:9081
 
Parse for variable=threshold:
Parse for variable=threshold:


Line 101: Line 37:
   P2PActiveUsers=250
   P2PActiveUsers=250
   PSActiveUsers=1000
   PSActiveUsers=1000
= Sametime SIP =


Check SIP:
|-
| '''Sametime Media Manager:''' || 5060 ||
* <nowiki>http://serverhostname.domain:5060</nowiki>
||
Parse for variable=threshold:


  stsip901.company.com_port=5060
SIP/2.0 200
  stsip901.company.com_response=SIP/2.0 200


|-


= Sametime System Console=
| '''Sametime Video Manager:''' || Example ||
  db2srv-st9sc.company.com_db_user=stuser
* <nowiki>https://serverhostname.domain:74431/api/lb/rest/status</nowiki>
  db2srv-st9sc.company.com_db_pw=
||
  db2srv-st9sc.company.com_db_port=50000
  db2srv-st9sc.company.com1_db_sql=SELECT * from SSC.VERSIONINFO
  db2srv-st9sc.company.com1_db_database=ST9SC
  db2srv-st9sc.company.com2_db_sql=select * from POLICY.TEMPLATE
  db2srv-st9sc.company.com2_db_database=ST9SC


=Sametime Advanced  - DB2=
Parse for:
   #db2srv-st9ms.company.com5_db_sql=select * from ORGCOL.CONFIGURATION
 
  #db2srv-st9ms.company.com5_db_database=STADV
   Alive
  # Sametime Bandwith Manager
|-
  #db2srv-st9ms.company.com6_db_sql=select * from "db2admin".BWM_CONFIGURATION_SETTINGS
| Example || Example || Example || Example
  #db2srv-st9ms.company.com6_db_database=STBWM
|-
| Example || Example || Example || Example
|-
| Example || Example || Example || Example


|}




{| class="wikitable"
|-
! Product !! Driver !! Query !! Details !! Details
|-
| Sametime System Console || db2jdbc.jar || STSC || SELECT * from SSC.VERSIONINFO || Example
|-
| Sametime System Console || db2jdbc.jar || STSC || select * from POLICY.TEMPLATE || Example
|-
| Sametime Proxy || db2jdbc.jar || STPR || select * from STPROXY.STP_IMMSG || Example
|-
| Sametime Meetings || db2jdbc.jar || STMS || select * from MTG.CONFIGURATION || Example
|-
| Sametime Meetings || db2jdbc.jar || STMS || select * from MTG.CONFIGURATION || Example
|-
| Sametime Meetings || db2jdbc.jar || STMS || SELECT COUNT(*) AS VALUE FROM MTG.ROOM R WHERE ACTIVE_STATE = 'ACTIVE' || Sametime Active Meeting Rooms - Threshold can be: 100
|-
| Sametime Meetings || db2jdbc.jar || STMS || SELECT COUNT(*) AS VALUE FROM MTG.ROOM_USER RU, MTG.ROOM R WHERE RU.ROOM_ID = R.ROOM_ID || Sametime Meeting Active Users - Threshold can be: 3000
|-
| Sametime Advanced || db2jdbc.jar || STADV || select * from ORGCOL.CONFIGURATION || Example
|-
| Sametime Bandwith Manager || db2jdbc.jar || STBWM || select * from "db2admin".BWM_CONFIGURATION_SETTINGS || Example
|-
| Sametime VMGR || soliddb.jar || - || select count (*)  FROM PERSISTEDUSERINFO_INDIVIDUALROLES || user=admin, port=2315
|-
| Sametime VMGR || soliddb.jar || - || ADMIN COMMAND 'info dbsize' || user=admin, port=2315, threshold size=600000
|}




Revision as of 15:07, 23 November 2017

Product Port Urls Details
Sametime System Console 8700
  • http://serverhostname.domain:8700/ibm/console
 Example
Sametime Community Server 80, 443
  • http://serverhostname.domain/stcenter.nsf
  • http://serverhostname.domain/stats
 * IBM Domino: Monitoring the health of you Domino Server using HTTP and show stats
Sametime Proxy Server: Example
  • http://serverhostname.domain:9080/stwebclient/index.jsp
 Url Check
Sametime Meeting Server: Example
  • http://serverhostname.domain/stmeetings/
  • http://serverhostname.domain:9080/stmeetings/

If you do a get using basic authentication, you can parse for: 

 displayName= "wsadmin"
Sametime Media Manager: Example
  • http://serverhostname.domain:9081

Parse for variable=threshold: 

 AllActiveUsers=2000  
 MCUActiveUser=250
 P2PActiveUsers=250
 PSActiveUsers=1000
Sametime Media Manager: 5060
  • http://serverhostname.domain:5060

Parse for variable=threshold: 

SIP/2.0 200
Sametime Video Manager: Example
  • https://serverhostname.domain:74431/api/lb/rest/status

Parse for: 

 Alive
Example Example Example Example
Example Example Example Example
Example Example Example Example


Product Driver Query Details Details
Sametime System Console db2jdbc.jar STSC SELECT * from SSC.VERSIONINFO Example
Sametime System Console db2jdbc.jar STSC select * from POLICY.TEMPLATE Example
Sametime Proxy db2jdbc.jar STPR select * from STPROXY.STP_IMMSG Example
Sametime Meetings db2jdbc.jar STMS select * from MTG.CONFIGURATION Example
Sametime Meetings db2jdbc.jar STMS select * from MTG.CONFIGURATION Example
Sametime Meetings db2jdbc.jar STMS SELECT COUNT(*) AS VALUE FROM MTG.ROOM R WHERE ACTIVE_STATE = 'ACTIVE' Sametime Active Meeting Rooms - Threshold can be: 100
Sametime Meetings db2jdbc.jar STMS SELECT COUNT(*) AS VALUE FROM MTG.ROOM_USER RU, MTG.ROOM R WHERE RU.ROOM_ID = R.ROOM_ID Sametime Meeting Active Users - Threshold can be: 3000
Sametime Advanced db2jdbc.jar STADV select * from ORGCOL.CONFIGURATION Example
Sametime Bandwith Manager db2jdbc.jar STBWM select * from "db2admin".BWM_CONFIGURATION_SETTINGS Example
Sametime VMGR soliddb.jar - select count (*) FROM PERSISTEDUSERINFO_INDIVIDUALROLES user=admin, port=2315
Sametime VMGR soliddb.jar - ADMIN COMMAND 'info dbsize' user=admin, port=2315, threshold size=600000


Ver também


Retrieved from "https://ebasso.net/wiki/index.php?title=Sametime:_Monitoring_the_health_of_you_Sametime_Environment&oldid=4356"