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.

Generate a report for Monthly or Daily Node frequency of change and duration in status

How can I generate a report which has Node Monthly or Daily frequency of change and Duration in status.I used the code below but it doesn't seem to produce correct values as well as producing the current date.

Please see attached SQL code.