[Last Updated time in Asset Management is 1 hour Ahead]

That's great - thanks 

[asset import from Microsoft Intune]

Useful thanks, I am looking at Laptop/Desktops/Tablets in the first instance, but this looks like a good start point

[Last Updated time in Asset Management is 1 hour Ahead]

Some further evidence has emerged:

Looks like this issue is related to asset_import.exe ... (i.e. not the Asset management screen)
When I manually change an Asset, the Last Updated time is correct.
Assets created or updated by asset_import.exe have the Last Updated time set one hour ahead (of BST)

 

[Last Updated time in Asset Management is 1 hour Ahead]

I have been using asset_import.exe to load and update Mobile Device Asset types,
Interestingly the Last Updated time in Asset Management is 1 hour Ahead of current time (I hour ahead of BST) see below:

As a spot check I ran a HB report and checked the run time shown (see below) which is correct, 
so the symptoms are that the Asset management list screen shows the Last updated time as 1 hour ahead,
other parts of HB display the time correctly.

 

 

 

[asset import from Microsoft Intune]

+1

We also want to set-up regular Asset imports from Intune > Hornbill

[What is the Data Processing Record Asset Class intended for?]

There is an Asset Class call Data Processing Record, what is this intended for?
Is anyone using it?  What Asset Types have you created within it?

 

 
 

[Can Audit History be switched on for the Notes field?]

When I update the Description of an asset (a Laptop in this case) I see the change in Audit History (below)
However when I change the Notes field on the same Asset, the change is not logged.
I that behaviour configurable? Can auditing be switched-on for the Notes field, such that we can see any changes in Audit History?

 

 

[How to change the Asset Type for a given asset(s)]

Hi Jim. Thanks for the response.

>> I was able to change some computer to servers as they had uploaded incorrectly by using the csv import 

Did you achieve this using the  asset_import.exe  tool? 

[How to change the Asset Type for a given asset(s)]

We have a 3 Smart Phone Assets in our Hornbill CMDB, these assets are linked to Service Request tickets. The tickets are closed.

We want to change the Asset Type of these devices from Smart Phone to Andriod Phone,  while maintaining the existing links to the Tickets. 

i.e. we want the change the Asset Type for a given asset(s)

How do we do this?
 

[Options for storing Server Software on the CMDB]

We want to store Server Software in the CMDB, so we can drill down from server to see what software is installed,
and also to answer the question; How many servers on the estate are running  XYZ Software?

There appears to be 2 ways to do this,
first by linking the Server Asset to the Server Software Asset, see below:
 

Second, there is the Installed Software Information  (below) 
which I have not figured out... (how to populate the 'software records').

My question is: What is the difference between these features and  Which is best practice for associating Server Software to a Server?  

 

[How to import missing fields for Mobile device > Smart Phone]

That's useful  -thanks

[How to import missing fields for Mobile device > Smart Phone]

I am using the asset import tool, importing Mobile Device > Smart Phone assets.
I want to populate the the 4 fields below, however these are not in the default Mobile device .json file.

Can I add extra fields into the .json?
What are the internal Hornbill field names for these fields?
 

[asset_import.exe [ERROR] Unable to run Query [getUserAccountsList] You need the right 'sys.a.manageUsers' ...]

Log file attached

Asset_Import_20231012162728_0.log

[asset_import.exe [ERROR] Unable to run Query [getUserAccountsList] You need the right 'sys.a.manageUsers' ...]

I am running asset_import.exe, it is 'working' (uploading the assets correctly) - no errors on screen,

BUT I am seeing an error in the .log file:
2023/10/12 16:27:31 [ERROR] Unable to run Query [getUserAccountsList] You need the right 'sys.a.manageUsers' in order to invoke the query: getUserAccountsList

I am importing a CSV,

C:\Asset_Import> asset_import.exe  -file=conf_example_csv2.json
---- XMLMC Database Asset Import Asset_Import_20231012162728_0.logv4.1.1 ----
[DEBUG] Flag - Config File conf_example_csv2.json
[DEBUG] Flag - Dry Run false
[DEBUG] Flag - Concurrent 1
[MESSAGE] Successfully decrypted Hornbill instance authentication information
Current binary is the latest version: 4.1.1
Caching User Records from Hornbill...
 0 / ? [---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------=] 0s
Accounts LoadedAsset_Import_20231012162728_0.log
[ See Attached full transcript and Log]

Do I need an extra permissions on my login account?

 

[asset_import.exe: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport]

Thank you

[asset_import.exe: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport]

So the getAssetsListForImport Stored Query exists, what permissions do I need to run/execute it?

 

 

[asset_import.exe: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport]

I am using asset_import.exe for the first time, I am testing with a small CSV file.

I couple of questions;
An API key has been created on the Hornbill Instance, However I don't have the KeySafeKeyID number
i.e. for use in the json file  "KeysafeKeyID": 1,

I have guessed, and put a "1" in there and it seems to work,
how can I confirm what the KeysafeKeyID number is

I received this error message on the first run:
[ERROR] Unable to count asset records: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport

Is this telling me my user permissions are wrong?
 

C:\Asset_Import>asset_import.exe -file=conf_example_csv2.json
---- XMLMC Database Asset Import Utility v4.1.1 ----
[DEBUG] Flag - Config File conf_example_csv2.json
[DEBUG] Flag - Dry Run false
[DEBUG] Flag - Concurrent 1
[INPUT] Enter your Instance ID:
aXXXXXXX
[INPUT] Enter the API Key:
API Key: ded**************************c75
[MESSAGE] Successfully encrypted Hornbill instance authentication details against the local user and computer
Current binary is the latest version: 4.1.1
Caching Application Records from Hornbill...
Running CSV query for Desktop assets. Please wait...
2 of 3 returned assets successfully retrieved ready for processing.
Caching Desktop Asset Records from Hornbill...
[ERROR] Unable to count asset records: You need the right 'app.h.executeQueries' in order to invoke the query: getAssetsListForImport

-=-=-= Summary =-=-=-
Created: 0
Create Skipped: 0
Create Failed: 0
Updated: 0
Update Skipped: 0
Update Failed: 0
Update Extended Record Skipped: 0
Update Extended Record Failed: 0
Assets Software Inventory Skipped: 0
Software Records Created: 0
Software Records Create Failed: 0
Software Records Removed: 0
Software Records Removal Failed: 0
Asset Supplier Associations Success: 0
Asset Supplier Associations Failed: 0
Asset Supplier Associations Skipped: 0
Asset Supplier Contract Associations Success: 0
Asset Supplier Contract Associations Failed: 0
Asset Supplier Contract Associations Skipped: 0
Time Taken: 56s
---- XMLMC Database Asset Import Complete ----