Mapping Audit Report
In FDM we used to have custom reports for audit mappings. How do we create custom reports in FCCS? The standard mapping audit report in data management is formatted in a way that is unusable. The data needs to be in a table format to allow for analysis. I have attached a file with the report script that we used to have in FDM that produced the following:
- Output was table format by log event
- User selectable starting and ending date for changes
- User selectable location. It could be all (including both active and inactive location), a specific location only, or a custom view that was called "All Active Locations". We would rename locations to have a leading "zzz_" when a location became inactive and this report would exclude querying anything starting with" zzz_" if we pulled on only all active. Even if that is not possible the main goal is to get a table format output since the current standard report layout is unusable.
0