Jump to content

Search the Community

Showing results for tags 'asset import'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Hornbill Platform and Applications
    • OpenForWork
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Employee Portal
    • Service Manager
    • IT Operations Management
    • Project Manager
    • Supplier Manager
    • Customer Manager
    • Document Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
  • About the Forum
    • Announcements
    • Suggestions and Feedback
    • Problems and Questions
  • Gamers Club's Games
  • Gamers Club's LFT

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Organisation


Location


Interests


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype

Found 2 results

  1. We are importing/updating assets using the asset import tool and SCCM. We use the managedBy attribute in AD to store the asset's assigned owner, and can easily import this into Service Manager. Before I do, my question is; will Service Manager recognise that the CN stored in that field is a user, or will it blindly try and shove the whole CN in there, probably returning a "too long" type error? The Wiki states "h_owned_by":"[UserName]" - when a valid Hornbill User ID (for a Full or Basic User) is passed to this field, the user is verified on your Hornbill instance, and the tool will complete the h_owned_by and h_owned_by_name columns appropriately. however the User ID is the sAMAccountName, not the full CN.
  2. The Asset Import does not appear to be completing consistently, so not all assets are being updated from SCCM. The log file just stops: no errors or warnings. Running at the command line the results are inconsistent, sometimes it goes through and completes, others it just stops and returns to the prompt. There's no obvious reason - it doesn't run for a certain amount of time, or stop on a certain asset, or even in a certain section. An example of the output where there's been a failure followed by a success would be: C:\sw_tools\Assets>db_asset_import_w32.exe -file=conf_sccm_assetscomputer.json [DEBUG] ---- XMLMC Database Asset Import Utility V1.2.1 ---- [DEBUG] Flag - Config File conf_sccm_assetscomputer.json [DEBUG] Flag - Zone eur [DEBUG] Flag - Dry Run false [DEBUG] Connecting to Database Server: DC-HVSQL-01\SCCM [DATABASE] Connection Successful [DATABASE] Running database query for Server assets. Please wait... 21 / 24 [===================================================>-------] 87.50 % 0 C:\sw_tools\Assets>db_asset_import_w32.exe -file=conf_sccm_assetscomputer.json [DEBUG] ---- XMLMC Database Asset Import Utility V1.2.1 ---- [DEBUG] Flag - Config File conf_sccm_assetscomputer.json [DEBUG] Flag - Zone eur [DEBUG] Flag - Dry Run false [DEBUG] Connecting to Database Server: DC-HVSQL-01\SCCM [DATABASE] Connection Successful [DATABASE] Running database query for Server assets. Please wait... 24 / 24 [=========================================================] 100.00 % 6s Processing Complete! [DEBUG] Connecting to Database Server: DC-HVSQL-01\SCCM [DATABASE] Connection Successful [DATABASE] Running database query for Laptop assets. Please wait... 963 / 963 [====================================================] 100.00 % 4m48s Processing Complete! [DEBUG] Connecting to Database Server: DC-HVSQL-01\SCCM [DATABASE] Connection Successful [DATABASE] Running database query for Desktop assets. Please wait... 1850 / 1850 [=================================================] 100.00 % 15m44s Processing Complete! [DEBUG] Connecting to Database Server: DC-HVSQL-01\SCCM [DATABASE] Connection Successful [DATABASE] Running database query for Virtual Machine assets. Please wait... 438 / 438 [====================================================] 100.00 % 4m16s Processing Complete! [DEBUG] Updated: 1892 [DEBUG] Updated Skipped: 1380 [DEBUG] Created: 1 [DEBUG] Created Skipped: 2 [DEBUG] Time Taken: 24m58.6625914s [DEBUG] ---- XMLMC Database Asset Import Complete ---- C:\sw_tools\Assets> As you can see, the first run just halts shortly into the first stage, the second run sails through. When it does complete the results are as expected. I've attached the config file in case that's causing a problem. All suggestions gratefully received!
×
×
  • Create New...