Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Link copied. Please paste this link to share this article on your social media post.
Originally published on Geo SCADA Knowledge Base by sbeadle1 | June 10, 2021 04:10 AM
SELECT COUNT( "Id" ) FROM CDBOBJECT
TYPE Result: STRUCT Count : DINT; Memory : DINT; END_STRUCT; END_TYPE PROGRAM ObjectCount VAR Objects AT %S(SELECT COUNT(*) AS "Count", SUM(MemoryUsage) AS "Memory" FROM CDBObject) : RESULTSET OF Result; Count AT %M(.ObjectCount.CurrentValue) : DINT; Memory AT %M(.ObjectMemory.CurrentValue) : DINT; END_VAR Count := Objects.Value.Count; Memory := Objects.Value.Memory; END_PROGRAM
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.