April 22, 2008 at 5:56 pm
Has anyone come across a way to do this ?
The problem is that when the audit log is exported to Excel the items
that are audited appear with their item id rather than with a meaningful name, I don't have sufficient access myself to determine the following but apparently both the item and the role group information are shown as ids.
Is their a way of using RS to gouge this information out or is it strictly
a coding solution ?
Ref: http://msdn2.microsoft.com/en-us/library/bb466223.aspx
thanks
April 28, 2008 at 9:41 pm
Just got back to looking into this issue.
More detail:
The report in question is accessed via Site Actions|Site Settings|
under Site Collection Administration|Audit log reports|Security And Site Settings Reports|Security settings with a URL that looks like this:
SubmitFormToRunReport(' ','Security_settings.xml','');
When run the Excel spreadsheet has a column called 'Event Data' withni the worksheet 'Report Data 1' . This column will contain somethnig like this:
What is required is to turn this garbage into something useful, i.e. return the name of the group and the user who has been added/deleted to/from the group.
If I find an answer I'll post it here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply