Backup Report and 2 small Problems

[C1Hol]

I've created some Custom Fields to fill in backup related data and a Report for every department.

1. I don't get any Linux Servers in this Report. When i open the Asset Groups every Asset is shown.
2. Is it possible to re-arrange the custom fields in the Asset Overview. Like moving the data from Custom13 to Custom8 for every Asset

Are there any plans to integrate Custom Drop-downs or Checkboxes?

Select Top 1000000 web40repIPLocationlist.IPLocation As [IP Location],
  tblAssetCustom.AssetID,
  tblAssets.AssetUnique,
  Case When tblAssetCustom.Model Like '%virtual%' Then 'Virtual' Else 'Physical'
  End As Hardware,
  tblAssets.IPAddress As [IP Address],
  tblOperatingsystem.Caption As [Operating System],
  tblAssetCustom.Custom12 As [Responsible for backup],
  tblAssetCustom.Custom6 As [Backup to Disk],
  tblAssetCustom.Custom7 As [Retention Time],
  tblAssetCustom.Custom8 As [Backup to Tape]
From tblAssetCustom
  Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
  Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
    tblAssetGroupLink.AssetGroupID
  Inner Join web40repIPLocationlist On web40repIPLocationlist.AssetID =
    tblAssets.AssetID
Where tblAssetGroups.AssetGroup Like '%All Server%'
Order By [IP Address]

[Hemoco · Accepted solution]

C1Hol wrote:
I don't get any Linux Servers in this Report. When i open the Asset Groups every Asset is shown.

Use the report below instead.

Select Top 1000000 tsysIPLocations.IPLocation,
tblAssetCustom.AssetID,
tblAssets.AssetName,
Case When tblAssetCustom.Model Like '%virtual%' Then 'Virtual' Else 'Physical'
End As Hardware,
tblAssets.IPAddress As [IP Address],
tblOperatingsystem.Caption As [Operating System],
tblAssetCustom.Custom12 As [Responsible for backup],
tblAssetCustom.Custom6 As [Backup to Disk],
tblAssetCustom.Custom7 As [Retention Time],
tblAssetCustom.Custom8 As [Backup to Tape]
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssetGroups.AssetGroup Like '%all server%'
Order By [IP Address]

C1Hol wrote:
Is it possible to re-arrange the custom fields in the Asset Overview. Like moving the data from Custom13 to Custom8 for every Asset

If you are using SQL Server as your database server, you can execute the script below in the Lansweeper web console under Configuration/Scanning Setup/Database Scripts to copy values from tblAssetCustom.Custom13 to tblAssetCustom.Custom8. (The Custom8 values will be overwritten.) Copy and paste the code and hit the Execute SQL Code button. We recommend performing a database backup before executing any scripts, just to be safe.

UPDATE tblAssetCustom
SET Custom8 = tblAssetCustom.Custom13
FROM tblAssetCustom

C1Hol wrote:
Are there any plans to integrate Custom Drop-downs or Checkboxes?

This feature is on our customer wish list, but we do not yet have a release date for it.