Discover what’s new in Lansweeper – Explore our 2024 Summer Launch! 🚀 Learn more

TRY NOW

Windows Server Custom Fields Audit

Miscellaneous

List Windows Servers and Their Custom Fields

Report on custom data you’ve entered into Lansweeper and gain additional insights by utilizing custom fields to store additional asset data that helps improve classification like the environment of your assets, the contact person, Application Family and whatever else you would like to add to your assets. You can read all about this use case and how to improve your asset classification in the Pro Tips 48 blog post.

The custom field numbers and names might need to be adjusted depending on your setup.

Windows Server Custom Field audit e1701180368106

Windows Server Custom Fields Lansweeper On-Prem Query

Select Top (1000000) tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.custom1 As [Custom1 Field Name],
tblAssetCustom.custom2 As [Custom2 Field Name],
tblAssetCustom.custom3 As [Custom3 Field Name],
tblAssetCustom.custom4 As [Custom4 Field Name],
tblAssetCustom.custom5 As [Custom5 Field Name],
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Firstseen As [Created at],
tblAssets.Lastseen As [Last successful scan]
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Where tblComputersystem.Domainrole > 1
And tblAssetCustom.State = 1
Order By tblAssets.AssetName

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.