Randomly overwritten computer_names ID

Jul 1, 2015 at 7:18 AM
Edited Jul 1, 2015 at 7:20 AM
I made a full clean after previous thread, and started 1 by 1, use different db for different domains. After 4 PC's audit the next overwrite an existing computer_name. Here are the logs
2015-06-30 12:03:19 Information Alkalmazás  0           Odbc::ExecDirect: 'SELECT * FROM Audit_Data WHERE 1 = 2'
2015-06-30 12:03:19 Information Alkalmazás  0           Odbc::ExecDirect: 'UPDATE Computer_Master SET Last_Audit_ID=2 WHERE Computer_ID=2'
2015-06-30 12:03:19 Information Alkalmazás  0           Records inserted: 76, error count: 0, time taken: 219ms
2015-06-30 12:03:19 Information Alkalmazás  0           Disconnecting from database.
2015-06-30 12:16:50 Information Alkalmazás  0           Odbc::ExecDirect: 'SELECT * FROM Audit_Data WHERE 1 = 2'
2015-06-30 12:16:50 Information Alkalmazás  0           Odbc::ExecDirect: 'UPDATE Computer_Master SET Last_Audit_ID=3 WHERE Computer_ID=3'
2015-06-30 12:16:50 Information Alkalmazás  0           Records inserted: 39, error count: 0, time taken: 62ms
2015-06-30 12:16:50 Information Alkalmazás  0           Disconnecting from database.
2015-06-30 12:29:24 Information Alkalmazás  0           Odbc::ExecDirect: 'SELECT * FROM Audit_Data WHERE 1 = 2'
2015-06-30 12:29:24 Information Alkalmazás  0           Odbc::ExecDirect: 'UPDATE Computer_Master SET Last_Audit_ID=4 WHERE Computer_ID=4'
2015-06-30 12:29:24 Information Alkalmazás  0           Records inserted: 58, error count: 0, time taken: 94ms
2015-06-30 12:29:24 Information Alkalmazás  0           Disconnecting from database.
2015-06-30 12:52:48 Error       Alkalmazás  0x20000007  Error logged by function 'WinMain'. A database operation failed.  [...] [SQL_ERROR].
2015-06-30 12:52:48 Error       Alkalmazás  0           Application exiting with error 536870919.
2015-06-30 13:02:29 Information Alkalmazás  0           Odbc::ExecDirect: 'SELECT * FROM Audit_Data WHERE 1 = 2'
2015-06-30 13:02:29 Information Alkalmazás  0           Odbc::ExecDirect: 'UPDATE Computer_Master SET Last_Audit_ID=5 WHERE Computer_ID=5'
2015-06-30 13:02:29 Information Alkalmazás  0           Records inserted: 64, error count: 0, time taken: 78ms
2015-06-30 13:49:26 Information Alkalmazás  0           Odbc::ExecDirect: 'SELECT * FROM Audit_Data WHERE 1 = 2'
2015-06-30 13:49:26 Information Alkalmazás  0           Odbc::ExecDirect: 'UPDATE Computer_Master SET Last_Audit_ID=8 WHERE Computer_ID=5'
2015-06-30 13:49:26 Information Alkalmazás  0           Records inserted: 61, error count: 0, time taken: 47ms
The last overwrite the previous before it. It was two different PC, so i guess it should be Computer_ID=6, but 6 not even created in the table.
Coordinator
Jul 14, 2015 at 1:09 PM
Hi Kaoraku,

It sounds like a harware identifier such as the Univerally Unique IDentifier in the System Management BIOS is the same for more than one machine. As its name suggests, no two computers should ever have the same value. Doing so runs counter to the SMBIOS. Anyway, You have two options:

1) On the menu select Help - > Create GUID and follow the instructions. Note, as WinAudit is not installed in the traditional setup/msi sense it does not write to the registy. Doing so would be against Microsoft's guidelines for not-installed programmes. So this is a manual process that you have to do for each computer. If you have a lot of machines this may not be convenient. When you send the data to the database, WinAudit will first check for the WinAudit_Guid. All should work fine.

2) As the System Management BIOS specification became more widely adopted this problem more or less went away. For some reason reports of this to us are on the increase. An update to WinAudit will cross check the SMBIOS UUID, MAC address and other machines identifiers. Download it here www.parmavex.co.uk/winaudit/WinAudit_3_0_17.zip. Note, its has not been released yet as things always require a lot of testing. E.g. hardware gets swapped from machine to machine etc.

I'd prefer if you go for option 2 be interested in how you get on.

Steven
Jul 16, 2015 at 7:05 AM
Thank you for the answer!

We have more then totally 200 (at me there is 120+) PC, so I am sure we would prefer the second solution :)

I downloaded that version, what you wrote, and give a try for it. Now it audited 50 pc (from the log), but again i have only 13 pc in comupter_master.
They run it from the network, is it count? Couse i can modify the script then to copy to the local disk before execute it.

Gergely
Coordinator
Jul 16, 2015 at 1:09 PM
Hi Kaoraku,

I need more information to find out what is happening. Send me a copy of the data in the Computer_Master table and a log file from a computer that is not present in the Computer_Master table. Send it to w i n a u d i t @ p a r m a v e x . c o . u k , there is no private/personla data in it.

Yes, of course you can copy the executable to the local disk. But it seems to me that doing so will create extra administrative work for you. When WinAudit is updated, you will need to keep all copies synchronised etc.

Steven
Jul 17, 2015 at 8:16 AM
Hello Steven!

Updating it on a local PC only an xcopy line, so this is not a big deal i think.

Anyway, i sent you what you asked in email.

Kaoraku
Sep 2, 2015 at 6:06 PM
I wrote 2 emails for you. The answer always a '>'. Do you read it?