Notification

Icon
Error

vCenter: VMware Guest Snapshots (Built-in)

Posted: Tuesday, March 5, 2019 11:52:12 AM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,982
0
Like
The report below gives back a list of vCenter Vmware guests snapshot data.

The report will only list assets when the following criteria are met:
  • You have Lansweeper 7.0 or higher.
  • There is VMware guest data scanned.
  • The assets must be active.

Code:
Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tblAssets1.AssetName As Host,
  tblVmwareGuestSnapShots.Name,
  tblVmwareGuestSnapShots.InternalKey,
  tblVmwareGuestSnapShots.CreateTime,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tblVmwareInfo On tblVmwareGuest.HostID = tblVmwareInfo.VmwareID
  Left Join tblAssets tblAssets1 On tblAssets1.AssetID = tblVmwareInfo.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tblVmwareGuestSnapShots On tblVmwareGuest.GuestID =
    tblVmwareGuestSnapShots.GuestID
Where tblState.Statename = 'Active'
Order By tblAssets.AssetName,
  tblVmwareGuestSnapShots.CreateTime
ConfuzedTech
#1ConfuzedTech Member Posts: 1  
posted: 11/1/2019 7:59:16 AM(UTC)
Hi

I'd like to run a report listing OLD snapshots, say 3 days or older.

I'd appreciate some help with customizing this report. I did do a little SQL a LONG time ago so understand the concepts but maybe it's the functions or syntax im having a hard time with, anyhow .............


I have tried things like:

Where tblVmwareGuestSnapShots.CreateTime <= (tblVmwareGuestSnapShots.CreateTime - 3) AND tblState.Statename = 'Active'

also tried variations using today() but can't get it to work.

Any suggestions ?
tnx

Active Discussions

Installer Windows 10 Upgrade
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:07:47 AM(UTC)
Lansweeper Only 1 Basic Action not working?
by  DotWAD  
Go to last post Go to first unread
Last post: Yesterday at 6:17:05 PM(UTC)
Lansweeper Mapped Drives Incorrect
by  cycleheat   Go to last post Go to first unread
Last post: Yesterday at 5:21:32 PM(UTC)
Lansweeper Help on creating report list from security groups
by  sc00bs  
Go to last post Go to first unread
Last post: Yesterday at 4:52:39 PM(UTC)
Lansweeper Will someone at Lansweeper please take my money?
by  sbAYVdQu   Go to last post Go to first unread
Last post: Yesterday at 3:31:33 PM(UTC)
Lansweeper Monitor open process
by  Renato  
Go to last post Go to first unread
Last post: Yesterday at 3:10:48 PM(UTC)
Lansweeper Duplicate assets (Servers)
by  kjstech   Go to last post Go to first unread
Last post: Yesterday at 2:34:14 PM(UTC)
Lansweeper All USB devices connected
by  earmor  
Go to last post Go to first unread
Last post: Yesterday at 1:35:37 PM(UTC)