Safend Auditor Graphic Report Procedure for MS Excel
Bei diesem Knowledge Base Artikel handelt es sich um einen Archiveintrag, der 1:1 aus den FAQv1 Beiträgen übernommen wurde. Er dient dazu, auch Lösungen für ältere Versionen nach wie vor anzubieten und durchsuchbar zu machen.
Archiv
Presenting the Safend Auditor reports in Excel worksheets with queries and graphic representations - charts etc.
Ursache
The Safend Auditor can export reports to MS Excel files that are pre-configured with the most commonly used queries.
It is also possible to add graphic reports of the audit results using the following procedure:
Lösung
Note MS Excel 2003 or above must be installed
- Execute the Safend Auditor
- Select the OU or IP range you wish to audit
- Click Run to perform the Audit
- Wait for Audit to complete
- Click Create Excel
- MS Excel will then open automatically with the Auditor results
- In Excel select and highlight the entire devices or computers data table (DO NOT select the Audit status table) including the Column Titles.
- Go to the Data menu and select Pivot Table and Pivot Chart report.
- The Pivot Table wizard will than start. Leave the settings as they appear by default and click next.
- The Pivot Table and Pivot Chart window (Step 2 of 3) will than appear. Click next.
- In the following window (Step 3 of 3) click Finish.
- A window with the fields you have chosen will be displayed.
- From the Pivot Table Field List window select "PORT", drag it into the "Drop Row Fields Here" area.
- Perform step 13 for the "Types", and "Device Info" fields as well as placing them beside the port field performed in step 13 in succession.
Note the order of the fields: Port, Type, and than Device Info. - Next you will need to drag the "Description" field into the "Drop Data Items Here" area.
- In the "Device info Column" click the drop down arrow, and deselect (uncheck) any unwanted devices, such as PCI devices.
Make sure to uncheck the "Blank" items at the bottom of the list. - You can now use the Chart wizard button to generate Bar or Pie charts as needed.
See "<samp>Safend Auditor Graphic Report Procedure for MS Excel"</samp> ( Datei faq161.pdf im Anhang ) for instructions, accompanied by screenshots of the entire process.
Quelle: Safend FAQ KB00000041 - Safend Auditor Graphic Report Procedure for MS Excel