DC-BEN Posted January 16, 2018 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
ArmandoDM Posted January 16, 2018 Posted January 16, 2018 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 1
DC-BEN Posted January 16, 2018 Author Posted January 16, 2018 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 Posted January 16, 2018 Posted January 16, 2018 Hi @DC-BEN, no problem. Yes, the queries are run from Database Direct; hope your colleague can help. Regards Armando 1
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