[Asset reporting: where is the history of an asset held please?]

Also interested in this so had a play around.

assetID appears to be stored in the id column of h_sys_audit_trail, but it's not just asset ID's in that column.
So I stripped away some data by adding a couple of filters:

filter the column "table" for h_cmdb_assets
filter the column "column" for h_owned_by_name
Then I had a filter for user prompted value for "id"

Run the report, enter asset ID and on the example I ran that gave me 9 records returned, there were 3 different usernames listed in the new value, and old value columns.

[Unable to save asset records]

+1 also have this issue.

 

However we have some fields set to appear in the summary, and editing here seems fine.

[Error with CSV asset upload]

Hi @ArmandoDM, yes it's for computer peripheral.

Thanks for the swift response.

[Error with CSV asset upload]

Good afternoon,

I am being given the following error when trying to upload some new assets via csv.

Normally when the upload has failed it's easy to correct the issue as the problematic field is stated, however it seems to be pointing to a field called h_static and I can't find this on the template.

 

"EspMethodCall::invoke: Operation[data::entityAddRecord] The text size provided (9 characters) is greater than the maximum allowable size of 4 characters for column h_static"

 

I checked my data, and there are no columns where I'm entering exactly 9 characters either.

 

Thanks

[Multiple Ticket on-hold option?]

+1

[Additional Properties per Asset Type]

+1 interested in adding new fields to asset types/classes

[Assets - dealing with ex-assets]

+1 Interested in asset views.

[Duplicate Asset Report Filter]

Hi @ArmandoDM,

Thanks for your response. Were the queries in the attached thread ran from Database Direct?

I don't believe I have access but I'll see if a colleague can help.

Thanks for the information

 

 

 

 

[Duplicate Asset Report Filter]

Hi,

When reviewing asset information, I've been coming across duplicate assets.

We generally use the csv import tool for new assets and assets in the computer system class have some fields automatically populated via SCCM. The duplicates seem to have been created via SCCM.

I'd like to create a report in Service Manager to help me identify all duplicate entries so they can be identified and analysed further.

 

For most of our assets the "Name" field should be unique, as well as "Asset Tag".

The "name" field matches the "Asset Tag" but has a prefix.

 

e.g.

Asset Tag: 12345

Name: DC012345

 

Any advice on what criteria to use for the report would be greatly appreciated.

Thanks

 

 

[Updating Existing Assets]

Hi @armandoDM

Thanks for your prompt response.

I'll be sure to bear this in mind going forward.

Thanks

[Updating Existing Assets]

Hi,

We have around 160 devices that have been added into the Service Manager asset database automatically via SCCM.

We have other information to add to all of these assets that SCCM doesn't populate such as; order number, supplier ID, room, order date, received date, warranty expires.

Just wondering if anyone can help advise if there is an easy way to add this information into existing records without going into each asset and manually changing it?

I'm guessing the asset upload feature is for new assets only and can't be used to add more information to existing assets?

Thanks