Hi danzopa85,
Yes, it is possible to track the status of ISE (Identity Services Engine) and the enabled/disabled state of switch ports. This can be accomplished through various means such as using network monitoring tools, querying network devices via command-line interfaces (CLI), or utilizing network management platforms.
To store and update this information into an Excel sheet, you can follow these steps:
-
Choose a method to retrieve the required information: Depending on your network infrastructure and available tools, you can use SNMP (Simple Network Management Protocol) to query the devices, use API calls to retrieve the data, or utilize network management software that provides reporting capabilities.
-
Write a script or use a network management tool: Develop a script or utilize a network management tool that can retrieve the necessary information. The script or tool should be capable of extracting the status of ISE and switch port configurations.
-
Export the data to an Excel sheet: Once you have collected the required information, you can export it to an Excel sheet. Most scripting languages, such as Python, offer libraries to interact with Excel files and write data to specific cells or columns.
-
Schedule regular updates: To keep the Excel sheet up-to-date, set up a schedule or trigger the script or network management tool periodically to retrieve the latest information and update the Excel sheet accordingly.
-----------------------------------------
If you find my reply solved your question or issue, kindly click the 'Accept as Solution' button and vote it as helpful.
You can also learn more about Secure Network Analytics (formerly known as Stealthwatch) through our live Ask the Experts (ATXs) session. Check out Cisco Network Security ATXs Resources [https://community.cisco.com/t5/security-knowledge-base/cisco-network-security-ask-the-experts-resources/ta-p/4416493] to view the latest schedule for upcoming sessions, as well as the useful references, e.g. online guides, FAQs.
-----------------------------------------
Best Regards,
Henry
