Ask our Experts
Didn't find what you are looking for? Ask our experts!
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Search in
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-10-03 11:41 AM . Last Modified: 2025-10-03 11:47 AM
Hello,
I’m looking for a supported method to obtain the Object ID values for all tags in our Geo SCADA Expert system.
At the moment, I can only see the ID for a single tag by opening its Status Information window. What I need is a way to pull all tag IDs in bulk. Specifically, I’m asking:
Can Bulk Edit / CSV Export include the Id field for each tag?
Is there a supported SQL query within Geo SCADA (ViewX → Queries) that lists Id, FullName, TypeName
for all points?
Is it supported to use the Geo SCADA ODBC/OLE DB provider with an external SQL viewer to export the IDs (read-only)?
If SQL is the right approach, what are the canonical table/column names for accessing object IDs across built-in drivers and modules?
My goal is a simple list or CSV containing at least:
Id, FullName, TypeName
Any official guidance on the recommended approach (Bulk Edit vs. SQL vs. ODBC) would be greatly appreciated.
Thank you,
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-10-03 11:53 AM
In ViewX create a list with the following query:
SELECT Id, Id, FullName, TypeDesc FROM CDBOBJECT ORDER BY FullName ASC
Note the Id field appears twice (lists hide the first occurrence).
Alternative, use the following query in Query Pad:
SELECT Id, FullName, TypeDesc FROM CDBOBJECT ORDER BY FullName ASC
You can also use this second query in Microsoft Excel, Crystal Reports etc. using ODBC or OLE DB.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-10-03 11:53 AM
In ViewX create a list with the following query:
SELECT Id, Id, FullName, TypeDesc FROM CDBOBJECT ORDER BY FullName ASC
Note the Id field appears twice (lists hide the first occurrence).
Alternative, use the following query in Query Pad:
SELECT Id, FullName, TypeDesc FROM CDBOBJECT ORDER BY FullName ASC
You can also use this second query in Microsoft Excel, Crystal Reports etc. using ODBC or OLE DB.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2025-10-03 12:00 PM
THANK YOU SO MUCH!
Link copied. Please paste this link to share this article on your social media post.
You’ve reached the end of your document
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.