Query to show tags that is an instance of a template

[Clearscada_EIT]

Hi,

I have a list of all the tags inside my database, my task is to query create a query to show all the tags that are instance of a template and tags that don't belong to any template

Does anyone has a query can do this task?

Thanks 

[AndrewScott]

The CDBObject::ParentInstanceId field will give the object ID of the template instance that the object is in or NULL_REFID (minus one) if it is not in a template instance.

SELECT Id, FullName FROM CDBObject WHERE ParentInstanceId <> -1

[Clearscada_EIT]

Thanks Scott,

The problem I have is within the same Instance folder, I have some tags that come from the template and some one off tags too, the query above will list all the tags under a folder of template instance but doesn't tell you if the tags are from the template or one off tag 

[AndrewScott · Accepted solution]

The CDBObject::ParentTemplateId field will give the object ID of the template that controls the object or NULL_REFID (minus one) if it is not controlled by a template.

The following query will give the local objects in an instance that are not controlled by a template, where <Instance Group Full Name> is full name of instance that you want to query:

SELECT Id, FullName FROM CDBObject WHERE ParentTemplateId = -1 AND FullName LIKE '<Instance Group Full Name>.%'

 NB. There is trailing dot and percent (wildcard) on the end of the instance name so that only objects in the group are queried.

[sbeadle]

This page shows how to use Python to get template/instance heirarchy information:

https://community.se.com/t5/Geo-SCADA-Knowledge-Base/Python-API-Reading-the-Instance-and-Template-St...

[Clearscada_EIT]

Hi Steve,

I replicated the example in the link that you shared and use this query 

SELECT WITH TEMPLATES
	"Id", "Id", "FullName", "TypeDesc", "ParentInstanceId", "ParentTemplateId", "ParentInstanceId"->"TemplateId", "ParentInstanceId"->"TemplateId", "ParentInstanceId"->"TemplateId"->"FullName"
FROM	CDBOBJECT
WHERE	"FullName" LIKE 'test.%'
ORDER BY "FullName" ASC

as you can see, the result of the query doesn't tell you if a point comes from a template (with the red arrow). Or it's Freestanding point. So for now, I can no idea how to distinguish between a point from a template of Freestanding points
We are still using Geoscada 2023 so no Python application. 

[sbeadle]

Hi. You CAN use Python with Geo SCADA 2023, either on the same host or a different host.

Just install Geo SCADA 2025+ on any other PC and get hold of the files in the PythonPackages folder:

C:\Program Files\Schneider Electric\ClearSCADA\PythonPackages

Then copy these to the PC where you're going to run Python and call the PIP command, e.g:

python -m pip install --force-reinstall --no-index --find-links="C:\Program Files\Schneider Electric\ClearSCADA\PythonPackages" geoscada-client

(Future note for Geo SCADA 2025 R2/88 versions - also find the Python packages when you install just the Client installer at: C:\Program Files\Schneider Electric\ClearSCADA Client\PythonPackages).