DC-BEN Posted January 16, 2018 Share Posted January 16, 2018 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 Link to comment Share on other sites More sharing options...
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 account
Already have an account? Sign in here.Sign In Now