SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am working on a DWH-solution for the WSS RequestUsage log and I need to uniquely identify each row in the RequestUsage view. There is a RowId with guid, but it does not seem to be unique, as you can see in the excerpt below.

RowId                                   LogTime
40274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:19.703
3F274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:09.597
3E274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:00.643
3D274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:00.563
3C274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:00.533
3B274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:00.517
3A274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:00.487
39274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:00.440
38274C00-7D6B-E211-93F5-00155D454A60    2013-01-31 08:00:00.313

Can anyone suggest for me what combination of columns I can use to identify each row.

Thanks in advance

share|improve this question
Somehow, I got to your question here. For new readers, the rows in the RequestUsage log are uniquely identified by the RowId field. Cheers! Antonio – user17645 Jun 17 '13 at 9:29
Doen't look like it in the log extract above! – Robert Lindgren Jun 17 '13 at 9:45

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.