Hello, can I search and replace all values with a criteria on my database over PI System Management Tools?
??????? to Inacrtive;
?1 to Active
This would requiring editing the SYSTEM state table, which is not recommended.
First of all, the SYSTEM state table is for ERROR codes for bad values. An entry such as Active suggests it should be a good value. This suggests then that you should create your own PIStateSet with digital state entries such as 0=Inactive and 1=Active for good values.
Note that if you go against recommended advice and change the SYSTEM state table anyway, that your state names will not function in Asset Analytics or some other tools. You would have to refer to states by their integer values or codes.
Retrieving data ...