Notification

Icon
Error

Update existing Billing Report - Looking for String

Posted: Tuesday, September 15, 2020 8:12:25 AM(UTC)
Jose Da Silva

Jose Da Silva

Member Original PosterPosts: 2
0
Like
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'
Jose Da Silva
#1Jose Da Silva Member Original PosterPosts: 2  
posted: 9/16/2020 12:41:42 PM(UTC)
*BUMP

Active Discussions

Lansweeper Lansweeper Not Opening After Update
by  Terry1337   Go to last post Go to first unread
Last post: Yesterday at 7:36:40 PM(UTC)
Lansweeper different outgoing email-address for different teams
by  Brandon  
Go to last post Go to first unread
Last post: Yesterday at 7:10:53 PM(UTC)
Lansweeper List all admin accounts with their last logon for all computers
by  LawGar   Go to last post Go to first unread
Last post: Yesterday at 3:36:22 PM(UTC)
Lansweeper Limit Assets for users
by  Maikel Vanroelen  
Go to last post Go to first unread
Last post: Yesterday at 2:23:37 PM(UTC)
Lansweeper Help Desk not disabling for regular users?
by  EVKazantcev   Go to last post Go to first unread
Last post: Yesterday at 9:24:25 AM(UTC)
Lansweeper LSPUSH and Group Policy
by  HurricaneDave  
Go to last post Go to first unread
Last post: 9/21/2020 10:15:12 PM(UTC)
Lansweeper How to see additional info columns on Asset Groups
by  virtualnik8   Go to last post Go to first unread
Last post: 9/21/2020 7:40:41 PM(UTC)
Lansweeper Certificate status & end dates
by  doone128  
Go to last post Go to first unread
Last post: 9/21/2020 11:43:46 AM(UTC)