Hi,
Using EnvironmentName is not desired directly from the Table T_SYSTEM_SETTINGS
What (public) view contains this information?
Thanks
SELECT
Value as WF_SYSTEM_ENVIRONMENT
FROM
T_SYSTEM_SETTINGS
WHERE
PARAMETER='EnvironmentName'
See for reference: 000029223 - How to differentiate between multip... | RSA Link
Select value from PV_TELEMETRY_DATA
Where name='environmentName'
order by event_date desc
fetch first row only;
Check out the PV_TELEMETRY_DATA view. It contains some other data as well that could be of interest.
its also found here, which will show you the history every day, if the value has ever changed
there is lots of other useful info in this table, if you seach by "category" = "product"
select
*
from avuser.PV_TELEMETRY_DATA td
where name = 'environmentName'
order by td.day desc
;
Check out the PV_TELEMETRY_DATA view. It contains some other data as well that could be of interest.