Duplicate Asset Report Filter

[DC-BEN]

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

 

 

[ArmandoDM]

Hi @DC-BEN,

one way of identifying duplicates would be running a query as described in this thread

 

This way you will have the IDS of the duplicated Assets

Hope this helps

Armando

 

[DC-BEN]

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

 

 

 

 

[ArmandoDM]

Hi @DC-BEN,

no problem.

Yes, the queries are run from Database Direct;  hope your colleague can help.

Regards

Armando