How to Find the Owner of a Shared Power Monitoring Expert (PME) Trend
Issue
Would like to find who is the owner of a particular saved and shared Power Monitoring Expert (PME) trend.
Product
Power Monitoring Expert 8.x
Environment
SQL Server Management Studio
Cause
There is currently no method to find out who owns a particular saved trend within the User Interface of Power Monitoring Expert (PME).
Typically, only the owner of the trend can modify it. Therefore, in order to make any desired changes to it, the owner would need to be identified.
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio.
Databases should be backed up prior to performing this procedure.*
The following SQL query will return configuration information for a particular saved trend with the UserId of the owner displayed in the UserId column.
Execute the following query in a New Query window within SQL Management Studio, replacing '%TRENDNAMEHERE%' with the name of the trend to be retrieved.
SELECT *
FROM [ApplicationModules].[Configuration].[ConfigurationSettings]
WHERE
Item = 'Realtime Trend'
And Value LIKE '%TRENDNAMEHERE%'
-- Example
SELECT *
FROM [ApplicationModules].[Configuration].[ConfigurationSettings]
WHERE
Item = 'Realtime Trend'
And Value LIKE '%Keating Energy%'
Would like to find who is the owner of a particular saved and shared Power Monitoring Expert (PME) trend.
Product
Power Monitoring Expert 8.x
Environment
SQL Server Management Studio
Cause
There is currently no method to find out who owns a particular saved trend within the User Interface of Power Monitoring Expert (PME).
Typically, only the owner of the trend can modify it. Therefore, in order to make any desired changes to it, the owner would need to be identified.
Resolution
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio.
Databases should be backed up prior to performing this procedure.*
The following SQL query will return configuration information for a particular saved trend with the UserId of the owner displayed in the UserId column.
Execute the following query in a New Query window within SQL Management Studio, replacing '%TRENDNAMEHERE%' with the name of the trend to be retrieved.
SELECT *
FROM [ApplicationModules].[Configuration].[ConfigurationSettings]
WHERE
Item = 'Realtime Trend'
And Value LIKE '%TRENDNAMEHERE%'
-- Example
SELECT *
FROM [ApplicationModules].[Configuration].[ConfigurationSettings]
WHERE
Item = 'Realtime Trend'
And Value LIKE '%Keating Energy%'
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.