Sessions per scene and Client – Vision Group

Description

Query to extract sessions and scenes count per client

Query :

select Client, count (distinct SessionUid) SessionUid_Count,Count (SceneUid) SceneUid_Count,SceneTypeCategory,SceneTypeName
from vwAssetPurityList 
where ClientId = 213
and Country = 'United States'
and CreatedOn >= '2025-07-01'
And CreatedOn <= '2025-07-31'
Group by Client,SceneTypeCategory,SceneTypeName
order by SceneTypeCategory asc, SceneTypeName

--------------------------------------------------

Related to