EM12c : MGMT$STORAGE_REPORT_LOCALFS view does not have entries for all the hosts discovered on EM.

(Doc ID 1932709.1)

Last updated on OCTOBER 05, 2014

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

The issue can be reproduced at will with the following steps:
1. Connect as sysman to repository
2. Run the following query :

SELECT
b.target_name,
FROM mgmt_storage_report_data a,
mgmt$ecm_current_snapshots b
WHERE storage_layer = 'LOCAL_FILESYSTEM'
AND entity_type = 'Mountpoint'
AND a.ecm_snapshot_id = b.ecm_snapshot_id
AND b.snapshot_type = 'host_storage'

This does not return the hosts details.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms