Client Support
cancel

Searching in HP TRIM / HP RM8.1 - User with largest number of created records

Highlighted
PerthRM8
Outstanding Contributor.

Searching in HP TRIM / HP RM8.1 - User with largest number of created records

Hi,

how can we find out in HP TRIM / HP RM which user created the most records in the database...

WHo is the recorder?

what that search would look like...

Thanks.

 

2 REPLIES
Rich_Kid
Outstanding Contributor.

Re: Searching in HP TRIM / HP RM8.1 - User with largest number of created records

In the HP Trim client Record Statistics can get your there :-

 

Go - Tools | Reports | Record Statistics Report

 

Create a new Report

 

Name = Records Created by Year by Creator

Record Selection method = Date Registered

Start of period = 1/1/2000 (or from whenever you started registering records)

End of period (today)

(Do not select the “Include parts” option)

Period Type = years

Grouped By = Creator

Filter=Choose the record types you consider as "Records" (for example deselect any Box types)

Click Ok

 

Then right mouse click on the report and choose "Generate Statistics" and after a few seconds Trim will (hopefully!) report statistics generated.

 

Then right mouse click on the report and choose export to excel

 

Open in Excel

 

You get one row per user with each year from 2000 to 2015 as columns and a Total Records column for that user.

 

 

 

PerthRM8
Outstanding Contributor.

Re: Searching in HP TRIM / HP RM8.1 - User with largest number of created records

Once again, Richie helped!

I've done it exactly as you instructed, worked fine.

 

Report made and statistic run (I was afraid that it will take so much time, but it actually went pretty quick, 5-10 minutes (I was away from my desk)

 

I just need to figure out how to make PIVOT table to add totals for each year per each user and voila, sort them out by highest to lowest and we have a winner!

 

Fantastic work, thanks again.

Regards