Scene and Application Data

Description

Extracts scene information along with the application and version used.


Query :

select A.SessionUid,A.SceneUid,A.SceneId,A.SceneTypeCode,A.SceneTypeCategory,A.SceneSubTypeCode,A.SceneTypeName,D.IruserName,A.CreatedOn,C.ApplicationName,E.AppVersion,A.ImageCount,A.OutletCode,B.Name,D.SurveyStatus
from vwAssetPurityList A
inner join Location B with (nolock) on B.LocationId = A.LocationId
inner join AssetPurity E with (nolock) on E.AssetPurityId = A.AssetPurityId
inner join MobileApplication C with (nolock) on C.AppIdentifier = E.AppIdentifier
inner join vwSurveyList D with (nolock) on A.SessionUid = D.SessionUid
where A.ClientId = 463
and A.CreatedOn >= '2025-11-01'
and D.SurveyStatus = 'Complete'
order by A.CreatedOn asc