cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JoseDaSilva
Engaged Sweeper
Morning All

I have an existing report setup on lansweeper but i see any new vms added to the infrastructure does not reflect up on this report.
- does lansweeper have a string for me that will auto update my report on any new vms?
or is it static and requires me to manually enter them in?

here is the existing string on my report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Location,
tblAssetCustom.Manufacturer,
tblAssetCustom.Custom16 As BU,
tblAssetCustom.Custom2 As SLAOS,
tblAssetCustom.Custom1 As 'SLA Category',
tblAssets.NrProcessors,
tblAssets.Memory,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetGroups.AssetGroup,
tblAssetCustom.Custom3 As Billable,
tblAssets.Lastseen,
tblAssetCustom.Custom19 As [App Service],
tblAssetCustom.Custom20 As [Service Owner]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssets.AssetName Not Like ('%-AP-%') And
tblAssetCustom.Location In ('EL') And tblAssetCustom.Custom2 In ('Windows')
And tblAssetCustom.Custom1 In ('Bronze', 'Gold', 'Silver', 'Platinum') And
tblAssetGroups.AssetGroup Not Like ('%SQL%') And tblAssetCustom.Custom3 =
'Yes'
1 REPLY 1
JoseDaSilva
Engaged Sweeper
*BUMP