SQL Query which returns points within a template instance that have Historic Enabled

[Hazz2b]

I am wanting to Audit GeoSCADA templates to see which data points within a pre-designed template have Historic Enabled. This is achievable for Analogue and Digital Points via the below SQL script (change CDNP3Dig for digital points):

SELECT WITH TEMPLATES

P."FullName" AS "~FullName", P."Id", P."TypeDesc", P."ParentGroupName", CASE  WHEN AP."HistoricLogging" IS NOT NULL THEN 1 ELSE 0 END AS "Trended in GeoSCADA"

FROM

CDBOBJECT AS P LEFT OUTER JOIN CDNP3ANALOGIN AS AP ON ( P.ID = AP.ID )

WHERE

"~FullName" LIKE '~Templates%' AND P."TypeDesc" LIKE '%Point'

However I can't figure out which table to query for points of type "Internal Digital Point" ?

Any guidance would be appreciated. 

Thankyou,

[AdamWoodlandToo]

CPointDigitalManual is the table for internal digitals.

To make it generic you can go from the other direction, get a list of historic configuration and just join on CDBPoint, e.g.

SELECT WITH TEMPLATES
 P.ID, P.FULLNAME, P.TYPEDESC, P.PARENTGROUPNAME
FROM
 CHISTORY AS "H" LEFT JOIN CDBPOINT AS "P" ON H.ID = P.ID
WHERE
 P.FULLNAME LIKE '~Templates.%'
ORDER BY
 "FullName" ASC