Changing/updating the names of old computers and/or usernames

Started by Luis

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 "SQLite Spy", but the schema indexing prevents the SQL statement from executing.
Any suggestions?

Thanks,
Luis
SoftPerfect Support forum - Andrew avatar image

Re: Changing/updating the names of old computers and/or usernames   16 March 2017, 16:50

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.
Thanks Andrew - it worked perfectly.

Sometimes you can get the answer faster if you try the forum search and/or have a look at the software user manual to see if your question has already been answered.

Our forum rules are simple:

  • Be polite.
  • Do not spam.
  • If possible, check your spelling and grammar.

Author:

Email:

Subject

A brief and informative title for your message, approximately 4–8 words:

     

Spam prevention: please enter the following code in the input field below.

 ********   **     **  ********   **     **  **      ** 
 **     **  **     **  **     **  ***   ***  **  **  ** 
 **     **  **     **  **     **  **** ****  **  **  ** 
 ********   *********  **     **  ** *** **  **  **  ** 
 **     **  **     **  **     **  **     **  **  **  ** 
 **     **  **     **  **     **  **     **  **  **  ** 
 ********   **     **  ********   **     **   ***  ***  

Message: