Hi Dojo,
I'd need to identify which services and Visios have not been updated in the past 9 months - is there any query I can perform to get the created/modified info directly from the DB?
The "Created/Modified" info is something that is available in the general properties but only for elements - any hints?
If this isn't available yet for views and services, I'm happy to raise a feature request.
Ad interim, I was wondering if there is a known event ID that can be searched in the Information Events table, whenever a Visio gets modified or updated, to fetch data & author of the edit.
Thanks,
A.
Hi Alberto,
'Created and modified' properties for Services are expected in one of the coming 10.2.x feature releases.
For Visio changes (both assignment and edits) we have information events indeed. In your alarm filter, select 'Information events' and compose a filter based on parameter description by protocol like this:
your result should look like this:
Hope this helps.
I’m looking forward to tha parts that will be released in the range of 10.2
Logging this for the visio bits, as having the last modification easily accessible can be useful – https://community.dataminer.services/new-feature-suggestions/created-modified-info-for-views-services-and-for-the-uploaded-visio-file-and-visio-preview-when-assigning-existing-visio/
Hi Alberto,
For Visio files, for a limited amount of time after the change was done, you will be able to find a .zip file with details on the change in the "recycle bin" folder (C:\Skyline DataMiner\Recycle Bin). The file name format will be something like "2022_01_27 09_43_54_666_VDX View_14884.vsdx View_14884.vsdx.zip". When unzipping the archive, you will find the original *.vsdx file there and a small XML file with some details on what triggered the file change. This can be handy to revert to a previous version if needed.
Thanks for this tip, Michiel – helpful
Hi Alberto,
posting this as a second answer as I cant' add images to a comment.
In addition to the filter Pieter suggested, you can add a second filter wildcard or regular expression condition on the value for the Visio file name like below.
This will indeed only be possible during the time window that information events are stored.
Thanks, Pieter – super helpful!
As for the Info events, is there a way to retrieve just the last edit value of a given VDX if the date range is unknown? Also, if I keep only the last year of history in the DMS, does it mean I lose the info about when a Visio was added/edited?