Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Location in SW database of custom app stats

We have purchased a BI tool that can mine data from SW DB. I have download a new template called "Citrix Sessions" and need to know where the stats for this are stored in the DB? I need to know the session counts specifically. Is there a way for me to find stats on all applications I have on the system? I would assume they would be in a similar place.

Find more posts tagged with

Accepted answers

All comments

blsanner

Probably what you are looking for is the StatisticData column in the APM_CurrentComponentStatus table. However, you are going to need to do some joins to tie the ComponentID and ApplicationID back to only the component/application monitor/template you are interested in.

aLTeReGo

The following query should get you pointed in the right direction. Simply replace "LDAP Bind Time" with the name of your component

SELECT  TOP 10000 APM_StatisticsUsage.AvgStatisticData AS Statistic_Data FROM APM_AlertsAndReportsData INNER JOIN APM_StatisticsUsage ON (APM_AlertsAndReportsData.ComponentId = APM_StatisticsUsage.ComponentID)WHERE ( DateTime BETWEEN 42425 AND 42456 ) AND  (  (APM_AlertsAndReportsData.ComponentName = 'LDAP Bind Time'))

brent.weaver

This is in SWSQL format though right? I need it in std SQL.

aLTeReGo

The query I provided is SQL not SWQL.

brent.weaver

Alter - As always you are the best,m you help me SO much ... Thank you!! The query has a line that is cut off. Can you please tell me what is missing? I am having success with what you gave me so far though.

Thanks!

aLTeReGo

The query I posted above is complete and functioning, but was provided only as an example to point out which tables are used to store this data and what other table joins may be necessary.