How to report how many changes made in the last week or month?

ian2009

How to report how many changes made in the last week or month?

Not the individual changes made but the number of statistics.

Thank you for your help.

chris.lapoint

Unfortunately, this isn't an out of the box report.   However, I asked dev and they provided me the SQL query below which can be used to retrieve this info.

NOTE: We cannot guarantee that this query will work on subsequent upgrades due to internal schema changes.

HTH,

-Chris

=============

SELECT
COUNT(DISTINCT CacheDiffResults.NodeID) as CountOfChanges
FROM CacheDiffResults
JOIN ComparisonCache AS ComparisonCache ON
CacheDiffResults.CacheID = ComparisonCache.CacheID
JOIN Nodes  ON
Nodes.NodeID = CacheDiffResults.NodeID
WHERE
ComparisonCache.TimeStamp >= {PutStartDateThere} AND
ComparisonCache.TimeStamp <= {PutEndDateThere} AND
CacheDiffResults.ComparisonType=3 AND
CacheDiffResults.DiffFlag=1

CacheDiffResults.ComparisonType=3 menas that query will report changes in case there were differences between downloaded config in compare to previous one (does not matter running,startup or baseline) in defined time frame.

There are also other comparison type which report other type of changes:
CacheDiffResults.ComparisonType=1  - means that query will report changes in case there were differences between downloaded config and latest running or startup config depends form config type of downloaded config. This actually report differences between running and startup configs in defined time frame

CacheDiffResults.ComparisonType=2 - means that query will report changes in case there were diferences between downloaded config and latest baseline config in defined time frame.