
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2019 11:52 AM
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:
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.
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
Labels:
- Labels:
-
Built-In Reports
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-01-2019 07:59 AM
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
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
