AFAdmin.ClearChangeTables Method
- Last UpdatedNov 18, 2025
- 2 minute read
- PI System
- AF SDK 2024 R2
- Developer
Clears the tables in the PI AF SQL database which record information on changes to the system.
Namespace: OSIsoft.AF.Diagnostics
Assembly: OSIsoft.AFSDK (in OSIsoft.AFSDK.dll) Version: 3.1.1.1182
Syntax
public static void ClearChangeTables( PISystem system )
Public Shared Sub ClearChangeTables ( system As PISystem ) Dim system As PISystem AFAdmin.ClearChangeTables(system)
public: static void ClearChangeTables( PISystem^ system )
static member ClearChangeTables : system : PISystem -> unit
Parameters
- system
- Type: OSIsoft.AFPISystem
The operation will be performed on the specified PISystem.
Exceptions
| Exception | Condition |
|---|---|
| SecurityException | This exception is thrown when attempting to execute without Admin security rights. |
| ArgumentNullException | This exception is thrown when attempting to execute on a PISystem that is null or deleted. |
| NotSupportedException | This exception is thrown when attempting to execute on a PISystem that does not support the AdminFunctionality feature. |
Remarks
This method will clear the findChanges and afdiag tables in the PI AF SQL database which record information on changes to the system.
Use the PISystem.Supports method to check if the PISystem supports the AdminFunctionality feature.
 Security Note |
|---|
| Requires the Admin right to execute. |
 Notes to Callers |
|---|
| This method will error on servers before AF 2018 R2 (2.10.5). |