Does Cisco recommend a software application that can be used to do reporting on accounting logs available in ACS?
A. The ACS accounting logs are recorded in one of two formats: • CSV files—The comma-separated value (CSV) format records data in columns separated by commas. This format is easily imported into a variety of third-party applications, such as Microsoft Excel or Microsoft Access. After data from a CSV file is imported into such applications, prepare charts or perform queries, such as to determine how many hours a user is logged in to the network during a given period. • ODBC-compliant database tables—Open database connectivity (ODBC) logging allows you to configure ACS to log directly into an ODBC-compliant relational database, where information is stored in tables, one table per log. After the data is exported to the relational database, use the data in any way you need. With either method, software used to parse logs is widely available. However, Cisco does not recommend a particular vendor.
