Reporting on Status changed to "Used"

Ralphr

From within Report Writer or directly againsy the DB I can create SQL queries against the IPAM Event log that shows me when auto scans (user=SYSTEM) have changed the status of an IP Address to Transient or to Available but not Used.  If I edit the query so that it does not specify user =SYSTEM I do see results where the status has manually been set to "Used"  I assume I'm missing something obvious here but can't figure out what it is.  Here is the basic SQL query

Select Top 1000 *

From IPAM_Events

WHERE

IPAM_Events.Message LIKE '%Status to _Used_%'

AND

IPAM_Events.UserName = 'SYSTEM'

As I said if I change status to Transient or Available I get results.  If I have status = Used and delete the username = system I see results from manually setting the status.  It's as if no auto scan has ever changed the status to used.   What am I missing?

Ralphr

Noticed that the Message column is set as Text with a size of 16 ...(bytes ???)  is it possible that when a scan has to change status to used that there are other fields it also has to change (DNS, Location, etc) that the Status changed to used part of the message is just outside of the size limitation ??   Is there some way for me to manually change that size limit without mucking up my DB ?