Hyperion DRM record count

Hyperion DRM product licensing is record based.  If you are looking to see how many records are in use, run the below statement.  You need to know your Current Working Version.

Select N.i_version_id as "Version ID", V.c_abbrev as "Version Name", V.e_version_status as "Version Status", Count(*) as "Node Count"
From RM_Node N
Join RM_Version V on (N.i_version_id = V.i_version_id)
Where V.e_version_type = 'Normal'
Group by N.i_version_id, V.c_abbrev, V.e_version_status
Order by N.i_version_id Desc