1 of 1 people found this helpful
you could use the 'modified()' function.
Something like this:
friendlyTime(creationTime(#)) as 'Discovery Created',
friendlyTime(modified(#)) as 'Discovery Modified'
2 of 2 people found this helpful
The modification time will only change if the node is actually modified. If it is not changed the date is not updated.
You cannot, in general tell the last inference time. It is possible looking at a pattern to be able to determine when the additional information is last checked. Though this can be hard, for example discovery failures mean you need to distinguish between the discovery failure and confirmation of the model. Also depending upon a pattern it may have inferences to DDD nodes in which case it was obviously updated during the associated scan.
In general the easiest thing is just to base it on the time of the first order nodes and accept the odd occasions when this is not the case.
so we will not able to use this Latest inference time attribute in the query?
This is not an attribute but a code computed value displayed in the UI, as you can read it in the UI tool-tip if you hover your mouse over the "Last Inference Time" string in the UI.
What this represents is the latest inference time of the associated node. There is no real way to use this in a general query. No way to pick the largest value and it could be very expensive for nodes which have lots of inferences. For a single node you could order the results by the time and piick the latest but that does not work in a general report.