This is a view in the mssqlsystemresource database. Returns a row showing the state and pipe name of each user instance spawned from the parent server instance.
CREATE VIEW sys.dm_os_child_instances AS SELECT * FROM OpenRowset(ChildInstances)