Retrieve children elements of current element hierarchy

SELECT Name FROM NuGreen.Asset.ElementHierarchy
WHERE Path = N'\NuGreen\'

ElementHierarchy table query is equivalent to vElementHierarchy query with query date restriction set to current time. You can imagine the current element hierarchy table as a predefined view on top of an element hierarchy table that contains all element versions.