[ISS Support Case] Way to limit tags and trends in Historian Client
Last updated: October 17th, 2025Description
1 user does not disconnect Trend appy SELECT * FROM sys.dm_exec_sessions WHERE status = 'running'; Declare @dbName varchar(150) set @dbName = '[YOURDATABASENAME]' --Total machine connections --SELECT COUNT(dbid) as TotalConnections FROM sys.sysprocesses WHERE dbid > 0 --Available connections DECLARE @SPWHO1 TABLE (DBName VARCHAR(1000) NULL, NoOfAvailableConnections VARCHAR(1000) NULL, LoginName VARCHAR(1000) NULL) INSERT INTO @SPWHO1 SELECT db_name(dbid), count(dbid), loginame FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame SELECT * FROM @SPWHO1 WHERE DBName = @dbName --Running connections DECLARE @SPWHO2 TABLE (SPID VARCHAR(1000), [Status] VARCHAR(1000) NULL, [Login] VARCHAR(1000) NULL, HostName VARCHAR(1000) NULL, BlkBy VARCHAR(1000) NULL, DBName VARCHAR(1000) NULL, Command VARCHAR(1000) NULL, CPUTime VARCHAR(1000) NULL, DiskIO VARCHAR(1000) NULL, LastBatch VARCHAR(1000) NULL, ProgramName VARCHAR(1000) NULL, SPID2 VARCHAR(1000) NULL, Request VARCHAR(1000) NULL) INSERT INTO @SPWHO2 EXEC sp_who2 'Active' SELECT * FROM @SPWHO2 WHERE DBName = @dbName
- Author: Kevin Modlin
- Published: October 17th, 2025
Details:
| Product: Historian Client |
| Version: 2020 R2 |
| Solution: [Solution is visible below when you're logged in and have a current subscription] |
| Date Created: | 02/14/2022 |
| Case: | 80735 |
Give feedback about this article
Recommended articles
[ISS Support Case] Historian Client Trend Delay in Data Retrieval
Client reached out due to when using Historian Client Trend application data would not populate for five plus minutes. This is in reference to local Historian tags.
Read More[ISS Support Case] Historian Client add-in in Excel is unable to obtain a license
Trend is able to grab a license from the same client PC and Query is unable to grab a license from the license serve but it able to read a demo file (LOC style)
Read More[ISS Support Case] Historian Client Questions
Client has new machines that need the new version of the software. Recommending the latest 2023 R2 as it's compatible with 2017 historian client. regarding the installation process sees a patch released for the product. Do they need the base package first or just the patch files run that directly?
Read More[ISS Support Case] Search Issue with AVEVA Web Client post Server Migration
Search bar is not working on hist client web, but trends still display data correctly since the change of Hist server name and IP.
Read More