The only way to change the Response Time data to reflect a different availability number, you will need to delete the records from the database associated to the NodeID.
Warning: Please backup the database before making any changes in the database. There is no undo function in SQL.
The Nodes Table will show you the Node Name under Caption, IP under IP_Address, and NodeID is the key to identifying which device the data belongs to.
How to find the NodeID based on IP Address
Select NodeID, Caption, IP_Address, DNS From Nodes where IP_Address='10.10.10.10'
How to find the NodeID based on the System Name
Select NodeID, Caption, IP_Address, DNS From Nodes where Caption='SystemName'
Availability is recorded in the Response Time Tables will display as 100 or 0 in the Detail table. So if you wanted to find a device and find all records, you would run the following to find the records:
Find all records where Availability is 0 (Down) and NodeID is 99999
Select * from ResponseTime_Detail where Availability<>'100' and NodeID='99999'
Now that we found the Records, we can remove them from the database.
Delete all Records where Availability is down and NodeID is 99999.
Delete from ResponseTime_Detail where Availability<>'100' and NodeID='99999'
Note: Data Tables are Stored in Detail, Hourly, and Daily Tables. This is based on the retention of data collection. For defaults, Response Time tables only stores data for short periods of time. Detail is in the last 7 days, Hourly from day 8-30, and Daily from day 31-365.