Jump to content


Hornbill Users
  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

MikeW's Achievements


Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. I am trying to change/update the names of a bunch of assets in one go. I figured doing it via the CSV Import Utility would be a straight forward way as I don't want to change any other fields other than the name. I want to identify the asset via the asset tag and change the name so added the "h_asset_tag" and "assetTag" to the "AssetIdentifier" and "CSVAssetIdentifier" fields on the JSON - see attached pic. I assumed this would pick up the Asset Tag as the identifier and update the name to whatever I wanted. All this does is create a new asset with the new specified name from the CSV. When I change the JSON data to "h_name" (AssetIdentifier) and "name" (CSVAssetIdentifier), it picks up the correct asset and updates it but of course I can't change the asset name that way. But could change the asset tag and add other info if needed. Any ideas of a way to bulk change/update asset names? We use SCCM to sync our assets in to Hornbill. This name update would be something that will only be done a few times and will only effect assets that are no longer in SCCM so they would remain with the name change and not sync again with SCCM if that makes sense. Thanks
  2. @Steve G Thanks for the help, worked a treat! I now have my missing assets.
  3. Has anyone seen this or know how to solve - I have setup and successfully imported/synced assets from SCCM directly in to Hornbill but now realise I am missing some data - data that has neither a primary user or a last logged on user. It would appear that my SQL code/query will not import/sync an asset if it has neither a primary user or last logged on user. We do have a number of devices with this and would like them imported/syncing. I have tested my code on SQL Server Management Studio. The code is correct but it misses assets that don't have a primary or last logged on user so would appear to be a SQL issue rather than Hornbill. I remove the primary user and last logged on user code then the 'missing' assets appear and can then be imported/synced. Does anyone have any ideas how to import/query asset data that doesn't have a primary or last logged on user? I could do an import without the user code then another with it but don't really want to be doing this. I presume there must be a way to still query the data if these fields are blank. Sadly by SQL knowledge is limited. My query code is - select dbo.System_DISC.Netbios_Name0 AS [MachineName], dbo.System_DISC.User_Name0 AS [LastUserName], dbo.User_DISC.employeeID AS [LastLogged], dbo.Operating_System_DATA.Caption00 AS [OperatingSystem], dbo.Operating_System_DATA.Version00 AS [OperatingSystemVersion], dbo.Computer_System_DATA.Manufacturer00 AS [SystemManufacturer], dbo.Computer_System_DATA.Model00 AS [SystemModel], dbo.PC_BIOS_DATA.SerialNumber00 AS [ServiceTag], dbo.PC_Memory_DATA.TotalPhysicalMemory00 / (1000) / (1000) AS [MemoryGB], dbo.disk_data.Size00 * (1024) * (1024) / (1000000000) AS [HDDGB], dbo.System_Enclosure_DATA.ChassisTypes00, dbo.PC_BIOS_DATA.SMBIOSBIOSVersion00 AS [SMBIOSVersion], dbo.Logical_Disk_DATA.DriveType00, dbo.disk_data.MediaType00, (select Top 1 dbo.v_R_User.employeeID from dbo.v_UsersPrimaryMachines, dbo.v_R_User, dbo.v_R_System, dbo.User_DISC WHERE dbo.v_UsersPrimaryMachines.UserResourceID = dbo.v_R_User.ResourceID and dbo.v_UsersPrimaryMachines.MachineID = dbo.v_R_System.ResourceID and dbo.v_R_System.Name0 = dbo.System_DISC.Netbios_Name0 and dbo.v_R_User.Name0 = dbo.User_DISC.Name0) AS [PrimaryUser] from dbo.System_DISC, dbo.User_DISC, dbo.Operating_System_DATA, dbo.System_Enclosure_DATA, dbo.PC_BIOS_DATA, dbo.PC_Memory_DATA, dbo.Disk_DATA, dbo.Logical_Disk_DATA, dbo.Computer_System_DATA WHERE 1=1AND dbo.System_Enclosure_DATA.ChassisTypes00 IN (8, 9, 10, 14, 32) and dbo.Logical_Disk_DATA.DriveType00 = 3 and dbo.disk_data.MediaType00 = 'Fixed hard disk media' and dbo.system_disc.ItemKey = dbo.Operating_System_DATA.MachineID and dbo.System_DISC.User_Name0 = dbo.User_DISC.User_Name0 and dbo.system_disc.ItemKey = dbo.Computer_System_DATA.MachineID and dbo.system_disc.ItemKey = dbo.PC_Memory_DATA.MachineID and dbo.system_disc.ItemKey = dbo.PC_BIOS_DATA.MachineID and dbo.system_disc.ItemKey = dbo.Logical_Disk_DATA.MachineID and dbo.system_disc.ItemKey = dbo.Disk_DATA.MachineID and dbo.system_disc.ItemKey = dbo.System_Enclosure_DATA.MachineID
  4. On testing asset importing from SCCM I have been having some problems with missing/blank fields. I am starting with a very basic SQL query which I have tested in the SQL Server Management Studio directly on the server that SCCM sits and have been able to query/return the desired data. The basic data I want to test with is just pulling the MachineName. I am also limiting the amount of data to import to one record (as you will see below). I have added the query in to the JSON file and ran a test - it runs without errors. I have done a live import but it doesn't populate the MachineName field in Hornbill. I have also tried added a few more fields to the query in case the data is too small but nothing imports apart from a blank record. Here is the data - "Query": "SELECT sys.Netbios_Name0 AS [MachineName] FROM cm_int.dbo.System_DISC sys"},"AssetTypes": [{"AssetType": "Laptop - TEST ONLY","Query": "where sys.Netbios_Name0 = 'laptop name'","AssetIdentifier": {"DBColumn": "MachineName","Entity": "Asset","EntityColumn": "h_name"}}],"AssetGenericFieldMapping": {"h_name": "[MachineName]","h_site": "","h_asset_tag": "","h_acq_method": "","h_actual_retired_date": "","h_beneficiary": "","h_building": "","h_cost": "","h_cost_center": "","h_country": "","h_created_date": "","h_deprec_method": "","h_deprec_start": "","h_description": "","h_disposal_price": "","h_disposal_reason": "","h_floor": "","h_geo_location": "","h_invoice_number": "","h_location": "","h_location_type": "","h_maintenance_cost": "","h_maintenance_ref": "","h_notes": "","h_operational_state": "","h_order_date": "","h_order_number": "","h_owned_by": "","h_product_id": "","h_received_date": "","h_residual_value": "","h_room": "","h_scheduled_retire_date": "","h_supplier_id": "","h_supported_by": "","h_used_by": "","h_version": "","h_warranty_expires": "","h_warranty_start": ""},"AssetTypeFieldMapping": {"h_name": "[MachineName]","h_mac_address": "","h_net_ip_address": "","h_net_computer_name": "","h_net_win_domain": "","h_model": "","h_manufacturer": "","h_cpu_info": "","h_description": "","h_last_logged_on": "","h_last_logged_on_user": "","h_memory_info": "","h_net_win_dom_role": "","h_optical_drive": "","h_os_description": "","h_os_registered_to": "","h_os_serial_number": "","h_os_service_pack": "","h_os_type": "","h_os_version": "","h_physical_disk_size": "","h_serial_number": "","h_cpu_clock_speed": "","h_physical_cpus": "","h_logical_cpus": "","h_bios_name": "","h_bios_manufacturer": "","h_bios_serial_number": "","h_bios_release_date": "","h_bios_version": "","h_max_memory_capacity": "","h_number_memory_slots": "","h_net_name": "","h_subnet_mask": ""}}
  5. @Jeremy We just ran a Service Manager update and it fixed this problem
  6. Am experiencing this here as well. Be great to know when the next release will be live.
  7. @James Ainsworth Thanks, be a great feature if possible. Mike
  8. @James Ainsworth any ideas on this? Or is it by design?
  9. @James Ainsworth Have tried searching via co-workers at the top as well as via asset using name as the search. Neither returns the 'shared' asset.
  10. Hi @James Ainsworth When you search for a user who has a shared asset, the asset does not show as one of their assets (My Assets). Presume this is by design? How would I track an asset assigned to a user that is shared without going in to the asset? Thanks Mike
  11. @Steve G Thanks for this, am going to check out the Powershell now. Will let you know how it goes. Will find out from a colleague who knows more about InTune and get back to you about other integrations. Mike
  12. I understand that we can import mobile phones and tablets from Intune. Does anyone have any experience of doing this? Do we use a JSON file in the same way we would from SCCM? If so what information would we need to input for the APIKey, Instance ID, Driver, Server etc as this is a cloud-based system and doesn't have a specific SQL server to connect to. These particular details don't exist. Any help would be great to get me started.
  13. Thanks @James Ainsworth am looking at the CSV asset import utility now
  14. Hi @James Ainsworth Yes that will be another tool that I will likely test before we do a full import. Does basic Upload Assets not have an update function I presume then? Mike
  • Create New...