Hi,
While not easily found in the GUI (yet), you can indeed get this detail from either the CLI or API.
It depends how you want to see it.
For example, in the CLI to see the list of snapshots and which container(DB) they belong to:
delphix> /snapshot list
NAME CONTAINER LATESTCHANGEPOINT.LOCATION LATESTCHANGEPOINT.TIMESTAMP
'@2020-04-21T10:32:25.597Z' R2PDB1 71732974 2020-04-22T10:33:03.000Z
'@2020-04-21T10:31:40.978Z' monterey 71732195 2020-04-22T10:32:04.000Z
...
'@2020-04-20T10:30:08.102Z' vdb 29984581 2020-04-21T10:30:49.000Z
'@2020-04-20T10:30:08.657Z' vvdb 29902981 2020-04-21T10:30:49.000Z
or to find the owner of a particular snapshot:
delphix> /snapshot select '@2020-04-21T10:31:40.978Z'
delphix snapshot ''@2020-04-21T10:31:40.978Z''> get container
monterey
or to get all the snapshots for one particular container(DB):
delphix> /snapshot list database=ASE_VDB1
NAME CONTAINER LATESTCHANGEPOINT.LOCATION LATESTCHANGEPOINT.TIMESTAMP
'@2020-04-15T03:29:37.593' ASE_VDB1 - 2020-04-15T10:29:37.593Z
'@2020-04-16T03:29:30.190' ASE_VDB1 - 2020-04-16T10:29:30.190Z
'@2020-04-17T03:29:30.816' ASE_VDB1 - 2020-04-17T10:29:30.816Z
'@2020-04-18T03:29:30.130' ASE_VDB1 - 2020-04-18T10:29:30.130Z
'@2020-04-19T03:29:30.206' ASE_VDB1 - 2020-04-19T10:29:30.206Z
'@2020-04-20T03:29:28.503' ASE_VDB1 - 2020-04-20T10:29:28.503Z
'@2020-04-21T03:29:25.493' ASE_VDB1 - 2020-04-21T10:29:25.493Z
'@2020-04-22T03:29:25.426' ASE_VDB1 - 2020-04-22T10:29:25.426Z
see also the "
snapshot" endpoint in the API, which should provide the same info.
If you mean you want to see which VDBs are pinning or holding which snapshots (and so are not getting deleted by retention), then you can do this via the "
timeflow" endpoint, for example (sources obviously have no parent snapshot):
delphix> timeflow list display=container,parentSnapshot
CONTAINER PARENTSNAPSHOT
marina -
monterey -
R2PDB1 -
vcdb '@2020-04-20T10:31:51.048Z'
vdb '@2020-03-02T15:27:05.325Z'
vvdb '@2020-03-10T12:09:48.294Z'
vmask '@2020-03-02T15:27:05.325Z'
vpdb '@2020-04-20T10:32:50.193Z'
SQL1 '@2020-03-28T07:00:00.000'
SQLmask '@2020-03-05T04:00:00.000'
Macaroon -
Soda -
ASE_VDB1 '@2020-02-22T03:50:40.063'
clippers -
Vfiles -
Vfile_vdb '@2020-02-21T03:15:13.042'
delphix>
Hope that helps,
Scott.
------------------------------
Scott MacDonald
Senior Member Technical Staff
Delphix
------------------------------
Original Message:
Sent: 04-20-2020 05:55:31 AM
From: Rahim Cetinel
Subject: Delphix Storage Usage Details: Snapshots and vDBs
Hi everyone,
Is there anyway to get information about which snapshot is being used by which vDB or vDBs, from CLI, API, GUI?
The above information could be quite useful specially when storage usage is going up to 70+ percents, vDBs are not refreshed for more than a month.
------------------------------
BR,
Rahim Cetinel
Solution Architect | Delphix Blackbelt
Accuras DMCC, Turkey
------------------------------