paulIT_1 Super Contributor.
Super Contributor.
754 views

Finding duplicates in AssetManger

Jump to solution

Hello, I want to find the duplicates in AM (amAsset table) which has the same SerialNo. Could someone please help me.

 

Thankyou

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
RobC_TR Absent Member.
Absent Member.

Re: Finding duplicates in AssetManger

Jump to solution
Run a query filter with a subquery something like this:

((SerialNo IN (SELECT SerialNo FROM amAsset GROUP BY SerialNo HAVING count(SerialNo.) > 1))

This will return all counts of serial numbers > 1 for a start and from there you can drill in to details as needed.

View solution in original post

2 Replies
Highlighted
RobC_TR Absent Member.
Absent Member.

Re: Finding duplicates in AssetManger

Jump to solution
Run a query filter with a subquery something like this:

((SerialNo IN (SELECT SerialNo FROM amAsset GROUP BY SerialNo HAVING count(SerialNo.) > 1))

This will return all counts of serial numbers > 1 for a start and from there you can drill in to details as needed.

View solution in original post

paulIT_1 Super Contributor.
Super Contributor.

Re: Finding duplicates in AssetManger

Jump to solution

Hi Rob,

 

Thanks alot for your quick response and solution which was really helpful.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.