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

Started by Luis

Luis

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

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

Reply Quote

Andrew

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

Admin
Registered: 18 years ago
Posts: 3 519

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.

Reply Quote

Luis

Re: Changing/updating the names of old computers and/or usernames 17 March 2017, 11:28

Thanks Andrew - it worked perfectly.

Reply Quote

Print view of this page

Reply to this topic

Sometimes you can find a solution faster if you try the forum search, have a look at the knowledge base, or check the software user manual to see if your question has already been answered.

Our forum rules are simple:

Be polite.
Do not spam.
Write in English. If possible, check your spelling and grammar.

Author:

Email:

Subject

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

Disable BBcode in this message Disable smileys in this message

Help information

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

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

Enter the code:

Message:

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

Reply to this topic

Software Products

Online Store

Help & Support

Download

SoftPerfect