Notification

Icon
Error

Asset custom field values of your assets

Posted: Wednesday, April 11, 2018 9:52:32 AM(UTC)
Susan.A

Susan.A

Member Administration Original PosterPosts: 1,535
0
Like
The report below lists your assets and their asset custom field values. Info on configuring and adding data to asset custom fields can be found in this knowledge base article.

Keep in mind that:
  • Asset custom fields retain their original Custom1-Custom20 names within the Lansweeper database, regardless of what you set their display names to in the web console. To assign your preferred display names within the report, use aliases. Do not rename the fields within the database itself, as this will break your installation.
  • Asset custom fields retain their original field type (i.e. text) within the Lansweeper database, regardless of what you set their display type to in the web console. If you want to process custom field data in certain ways, to perform calculations for instance, convert the field values within the report.

The report will only list assets that meet the following requirement:
  • The asset state is set to "active".

Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.SystemVersion)
  As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetCustom.Custom1,
  tblAssetCustom.Custom2,
  tblAssetCustom.Custom3,
  tblAssetCustom.Custom4,
  tblAssetCustom.Custom5,
  tblAssetCustom.Custom6,
  tblAssetCustom.Custom7,
  tblAssetCustom.Custom8,
  tblAssetCustom.Custom9,
  tblAssetCustom.Custom10,
  tblAssetCustom.Custom11,
  tblAssetCustom.Custom12,
  tblAssetCustom.Custom13,
  tblAssetCustom.Custom14,
  tblAssetCustom.Custom15,
  tblAssetCustom.Custom16,
  tblAssetCustom.Custom17,
  tblAssetCustom.Custom18,
  tblAssetCustom.Custom19,
  tblAssetCustom.Custom20
From tblAssets
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  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 tblState On tblState.State = tblAssetCustom.State
  Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
  Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Where tblState.Statename = 'Active'
Order By tblAssets.IPNumeric,
  tblAssets.Domain,
  tblAssets.AssetName

Active Discussions

Installer Windows 10 Upgrade
by  CyberCitizen  
Go to last post Go to first unread
Last post: 12/2/2019 12:20:57 AM(UTC)
Installer Team Viewer Host update / install
by  BastiOn   Go to last post Go to first unread
Last post: 11/27/2019 2:09:10 PM(UTC)
Installer Office 2016 Update
by  Cem Serdar  
Go to last post Go to first unread
Last post: 11/7/2019 12:05:50 PM(UTC)
Installer Mozilla FireFox 70.0 Install
by  CyberCitizen   Go to last post Go to first unread
Last post: 11/7/2019 12:09:14 AM(UTC)
Installer Update Chrome browser with GoogleUpdate.exe ?
by  Mike Carey  
Go to last post Go to first unread
Last post: 11/6/2019 10:35:43 PM(UTC)
Installer CutePDF and Ghostscript install (Print to PDF)
by  Ruben1  
Go to last post Go to first unread
Last post: 10/15/2019 10:35:05 AM(UTC)