Documentation

    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

Configuration Example - Lansweeper 7.1

The following is an example of the SourceConfig, AssetTypes and data mapping configuration that could be used to import computer-type assets from a Lansweeper 7.1 database. This means that the Keysafe Key that holds the credentials to authenticate requests to the database should be of type Database Authentication.

In this example, asset records found against all defined asset types will be verified using the AssetName column from the DB query, and the h_name column within the Asset entity in your Hornbill instance.

Important

The configuration example is provided as-is, and may not be suitable to import your organization’s LanSweeper asset data. We highly recommend that a DBA review the SQL clauses against your LanSweeper database before using this in a production environment.

{
  "KeysafeKeyID": 0,
  "LogSizeBytes": 1000000,
  "HornbillUserIDColumn": "h_user_id",
  "SourceConfig": {
    "Source": "mssql",
    "Database": {
      "Authentication": "SQL",
      "Encrypt": false,
      "Query": "SELECT  at.AssetType AS AssetTypeID,  at.AssetTypename AS AssetTypeName,  a.AssetID,  a.AssetUnique,  a.Domain, a.Username AS ADUserID,  a.FQDN,  a.IPAddress,  a.SiteID,  CASE WHEN at.AssetTypename = 'Windows' THEN os.Caption WHEN at.AssetTypename = 'Apple Mac' THEN mos.SystemVersion END AS OperatingSystem,  a.SP,  convert(varchar, a.Firstseen, 20) as FirstSeen,  a.Description,  a.AssetName,  a.Mac,  a.Uptime,  a.Memory,  a.NrProcessors,  a.Processor,  convert(varchar, a.LastChanged, 20) as LastChanged,  os.Caption,  os.ProductType,  convert(varchar, ac.PurchaseDate, 20) as PurchaseDate,  convert(varchar, ac.Warrantydate, 20) as Warrantydate,  ac.Manufacturer,  ac.Model,  ac.Serialnumber,  u.Displayname AS ADUserName  FROM dbo.tblAssets AS a  LEFT JOIN dbo.tsysAssetTypes at ON a.Assettype = at.AssetType  LEFT JOIN dbo.tblOperatingsystem os ON a.AssetID = os.AssetID  LEFT JOIN dbo.tblMacOSInfo mos ON a.AssetID = mos.AssetID LEFT JOIN dbo.tblAssetCustom ac ON a.AssetID = ac.AssetID  LEFT JOIN lansweeperdb.dbo.tblADusers u ON a.Username = u.Username"
    }
  },
  "AssetTypes": [
    {
      "AssetType": "Laptop",
      "OperationType": "Both",
      "Query": "WHERE at.AssetTypename = 'Windows' AND os.ProductType = 1 AND ac.Model = 'Latitude E6320'",
      "AssetIdentifier": {
        "SourceColumn": "AssetName",
        "Entity": "Asset",
        "EntityColumn": "h_name",
        "SourceContractColumn": "",
        "SourceSupplierColumn": ""
      }
    },
    {
      "AssetType": "Desktop",
      "OperationType": "Both",
      "Query": "WHERE (at.AssetTypename = 'Windows' AND os.ProductType = 1 AND ac.Model = 'Precision WorkStation T5500') OR at.AssetTypename = 'Apple Mac'",
      "AssetIdentifier": {
        "SourceColumn": "AssetName",
        "Entity": "Asset",
        "EntityColumn": "h_name"
      }
    },
    {
      "AssetType": "Server",
      "OperationType": "Both",
      "Query": "WHERE os.ProductType IN (2, 3)",
      "AssetIdentifier": {
        "SourceColumn": "AssetName",
        "Entity": "Asset",
        "EntityColumn": "h_name"
      }
    }
  ],
  "AssetGenericFieldMapping": {
    "h_name": "{{.AssetName}}",
    "h_asset_tag": "{{.AssetName}}",
    "h_created_date": "{{.Firstseen}}",
    "h_description": "{{.Description}}",
    "h_owned_by": "{{.ADUserID}}",
    "h_owned_by_name": "{{.ADUserName}}",
    "h_used_by": "{{.ADUserID}}",
    "h_used_by_name": "{{.ADUserName}}",
    "h_warranty_expires": "{{.Warrantydate}}",
    "h_warranty_start": "{{.PurchaseDate}}"
  },
  "AssetTypeFieldMapping": {
    "h_name": "{{.AssetName}}",
    "h_mac_address": "{{.Mac}}",
    "h_net_ip_address": "{{.IPAddress}}",
    "h_net_computer_name": "{{.FQDN}}",
    "h_net_win_domain": "{{.Domain}}",
    "h_model": "{{.Model}}",
    "h_manufacturer": "{{.Manufacturer}}",
    "h_cpu_info": "{{.Processor}}",
    "h_description": "{{.Description}}",
    "h_memory_info": "{{.Memory}}",
    "h_os_description": "{{.OperatingSystem}}",
    "h_os_service_pack": "{{.ServicePackVersion}}",
    "h_os_version": "{{.OSCode}}",
    "h_serial_number": "{{.Serialnumber}}",
    "h_physical_cpus": "{{.NrProcessors}}",
    "h_net_name": "{{.FQDN}}"
  }
}
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document