This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Date node added

It would be very helpful to have a field for each node, interface, and volume for when it was first monitored/discovered. Currently we are using the script below, but it takes a load on the database across all our nodes availability data and once we get past the stats collection it will be out of date.

 

Select n.caption as 'Node Name' , Min(datetime) as 'Date Added'
from responsetime r join nodes n on n.nodeid = r.nodeid
Group by n.caption
order by n.caption