Some users have parameters that contain sensitive data and they don't want others to be able to see this in the executionlog2 view. How to I modify the view so the "Parameters" column doesn't exist or is hidden and not reportable?

Hi, You can do this by modifing the view defination by just changing the line SELECT InstanceName, COALESCE(C.Path, 'Unknown') AS ItemPath, UserName, ExecutionId, CASE(RequestType) WHEN 0 THEN 'Interactive' WHEN 1 THEN 'Subscription' WHEN 2 THEN 'Refresh Cache' ELSE 'Unknown' END AS RequestType, -- SubscriptionId, Format, <strong> '' as Parameters, </strong> Also, You need to ensure that users cannot directly query underling table ExecutionLogStorage by just giving the read permission to view and not table. Not recommanded, but still if you want you can disable execution log on whole server by, Steps: 1. Connect to Reporting services server via SSMS 2. Right click on Server Name -> Properties -> Logging and you should see the checkboxes to turn off/on execution Logging. - Chintak (My Blog)

Can you explain the select query you posted above. I just want to make the Parameters field not visible or reportable. I think I found the solution. I opened the 'design' of the view and just unchecked the 'parameters' column to remove it from the statement. Will this cause any problems with SRS?

Hi, What I have done above is similer thing..In pace of removing column from view, i have made it a blank so that if some process queries the view with column name, it does not break...added the full query below..I don't see any issue in doing this... SELECT InstanceName, COALESCE(C.Path, 'Unknown') AS ReportPath, UserName, ExecutionId, CASE(RequestType) WHEN 0 THEN 'Interactive' WHEN 1 THEN 'Subscription' ELSE 'Unknown' END AS RequestType, --SubscriptionId, Format, '' as Parameters, CASE(ReportAction) WHEN 1 THEN 'Render' WHEN 2 THEN 'BookmarkNavigation' WHEN 3 THEN 'DocumentMapNavigation' WHEN 4 THEN 'DrillThrough' WHEN 5 THEN 'FindString' WHEN 6 THEN 'GetDocumentMap' WHEN 7 THEN 'Toggle' WHEN 8 THEN 'Sort' ELSE 'Unknown' END AS ReportAction, TimeStart, TimeEnd, TimeDataRetrieval, TimeProcessing, TimeRendering, CASE(Source) WHEN 1 THEN 'Live' WHEN 2 THEN 'Cache' WHEN 3 THEN 'Snapshot' WHEN 4 THEN 'History' WHEN 5 THEN 'AdHoc' WHEN 6 THEN 'Session' WHEN 7 THEN 'Rdce' ELSE 'Unknown' END AS Source, Status, ByteCount, [RowCount], AdditionalInfo FROM ExecutionLogStorage EL WITH(NOLOCK) LEFT OUTER JOIN Catalog C WITH(NOLOCK) ON (EL.ReportID = C.ItemID) But after doing this you need to make sure that users does not have select permission on ExecutionLogStorage table, just select permission on the view, othervise some smart user can query the table and get parameter information..- Chintak (My Blog)