Update or change names of old computers and users
3 posts · Closed
Luis Guest
Hi,
Is there a way to update/change the names of old computers and/or users? I want to retain the usage data, but merge it into new computer/usernames.
I've tried to update the USAGE and PEER_USAGE DB tables using "SQLiteSpy", but the schema indexing prevents the SQL statement from executing.
Any suggestions?
Thanks,
Luis
Andrew SoftPerfect
That probably means it would create duplicates, i.e. you already have some records for the hour and day with the new computer/user name.
You can perhaps run UPDATE OR IGNORE or UPDATE OR REPLACE statement to disregard those duplicates.
Luis Guest
Thanks Andrew - it worked perfectly.
This topic is closed.
It has had no new posts for over a year, so the software versions it talks about may be out of date.
Start a new topic in NetWorx if you have a similar question.