How to query object attributes in the historian that still exist in the GR?

Richard Köhlerstrand rickard.norin Will appreciate any input on this. Thanks!

There isn't a way to determine if a Historian tag currently exists in the Galaxy. This is because object renames and deletes are not echoed to Historian.

The closest way to approximate this is based on the tags which have "recent" data--if an object was undeployed and renamed/deleted a week ago, the tags linked to the old name won't have any data in the last week. Of course, a setpoint that hasn't changed in a week, also won't have a new value in that time, but if the Engine is configured with "Reconnect as soon as possible & do not mark disconnects" left at the default of "unchecked", then tags for undeployed objects will have a "QualityDetail=24". We can adapt your query to consider this as:

select t.TagName, AreaLLocation=CAST([PropertyValue] AS NVARCHAR), vValue, DateTime
from TagExtendedPropertyInfo t
inner remote join Live l on l.TagName = t.TagName
where PropertyName='Location'
and CAST([PropertyValue] AS NVARCHAR) like '%Ai1Scaled#PV%'
and DateTime > dateadd(day,-2,getdate())
and QualityDetail <> 24

Hi, in addition to Elliotts comment, there are at least a possibility to get the Attributes/UDAs that has History enabled in the galaxy database.

Perhaps it can move you closer to your goal.

This list will return any attribute, deployed or undeployed so it is not to be taken as a list of a tag that is active and logged in Historian. Perhaps you can refine it or use it to combine with the data from the query provided by Elliott

SELECT g.tag_name + '.' + p.primitive_name
AS name, p.gobject_id, p.package_id, p.mx_primitive_id
FROM dbo.gobject AS g
INNER JOIN dbo.primitive_instance AS p
ON p.gobject_id = g.gobject_id AND p.execution_group = 18
INNER JOIN dbo.primitive_definition AS pd
ON p.primitive_definition_id = pd.primitive_definition_id
AND pd.primitive_name <> ''
INNER JOIN dbo.package AS pkg
ON p.gobject_id = pkg.gobject_id
and p.package_id = pkg.package_id
and pkg.package_id = g.checked_in_package_id
where (g.is_template = 0) AND (g.namespace_id = 1)

Sorry for the late update! and thanks for the suggestions. I am currently using the following to get to values that are active and don't belong to deleted objects: 

SELECT DISTINCT datasource.Tag
FROM (
SELECT tep.[TagName] as Tag,
CAST(tep.[PropertyValue] AS NVARCHAR) as AreaLocation,
tep.[ChangeVersion]
FROM [Runtime].[dbo].[_TagExtendedProperty] tep
WHERE tep.[TagName] LIKE ''<TAGNAME>''
AND CAST(tep.[PropertyValue] AS NVARCHAR) LIKE ''<AREANAME>''
AND tep.[PropertyNameKey] = ''3''
) AS datasource
JOIN ( SELECT His.[TagName], His.[OPCQuality]
FROM dbo.History His
WHERE His.TagName LIKE ''<TAGNAME>''
AND His.OPCQuality = 192) AS history
ON datasource.Tag = history.TagName
ORDER BY datasource.Tag ASC

Basically, I am using the PropertyNameKey property from the dbo._TagExtendedProperty table to filter out the attributes that don't exist (or so I think).