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.

False alerts for snapshots more than 15 days old

We had a lot of trouble getting support to help with this.. After a couple months I finally dove into the Orion database and fixed the issue. I wanted to share the cause and the fix in case anyone else is search this. I have found a lot of data over the years in these tables that should have been deleted, but wasn't. Support never has an answer.

The table is vim_virtualmachines

Look for the affected VM,

select * from vim_virtualmachines
where name = 'vm-name'

If the VM has no snapshots, look for these values,

SnapshotStorageSize should be 0
snapshotsummarycount should be 0
snapshotdatemodifed should be NULL
oldestnsapshotdate should be NULL

You can fix the issue by running this.

UPDATE vim_virtualmachines
SET SnapshotStorageSize = 0, snapshotsummarycount = 0, snapshotdatemodifed = NULL, oldestnsapshotdate = NULL
where name = 'vm-name'

Parents Reply Children
No Data