Oracle OEM: get host uptime from repository
Hello,
I'd like to create a report about host uptime but I'm not able to find the right query to execute.
I've found an old question here where the answer was:
select target_name, value from mgmt$metric_current where target_type = 'host'
and metric_column = 'SystemBootTime'
and metric_name = 'SystemTime';
but on my OEM (12.1.0.3) this doesn't seem to work.
I need something similar but I wasn't able to find the right data sofar ...
any idea ?
thanks,
Roberto