Jump to content

Duplicate Asset Report Filter


Recommended Posts

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 post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...