Kelvin Posted September 5, 2017 Share Posted September 5, 2017 I have been looking at our Asset DB and noticed that there are duplicates. 1. How does the Asset management side validate assets? 2. Which is the unique field? Link to comment Share on other sites More sharing options...
James Ainsworth Posted September 5, 2017 Share Posted September 5, 2017 Hi @Kelvin Could you let us know which method you are using to import your assets into Service Manager? This can be done using the Asset Import tool or by using the simple CSV asset import which is available within the client. If you are using the Asset Import Tool, the instructions can be found here. There is an option under the SQLConf section called "AssetID" which lets you specify the unique field that you wish to use. Regards, James Link to comment Share on other sites More sharing options...
Kelvin Posted September 6, 2017 Author Share Posted September 6, 2017 Hi @James Ainsworth I was using the upload CSV through "Upload new Assets", I was concerned as before I imported 500 assets I would try 1 to see which fields I needed to populate. When I uploaded it for a second time I was expecting to see a message like "Asset already in DB" instead it uploaded a second time. Link to comment Share on other sites More sharing options...
Kelvin Posted September 6, 2017 Author Share Posted September 6, 2017 @James Ainsworth I think I have found the answer If I upload to Computer System - there is a Validation button However under Computer Peripherals there is not. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now