V$ASM_CLIENT definition in Oracle Database 11.2
V$ASM_CLIENT

select
  group_number,                            -- GROUP_NUMBER NUMBER
  instance_name,                           -- INSTANCE_NAME VARCHAR2(64)
  db_name,                                 -- DB_NAME VARCHAR2(8)
  status,                                  -- STATUS VARCHAR2(12)
  software_version,                        -- SOFTWARE_VERSION VARCHAR2(60)
  compatible_version                       -- COMPATIBLE_VERSION VARCHAR2(60)
from
  gv$asm_client
where
  inst_id = USERENV('Instance')

home |  up