Scan Workstation Audit issue
Hi,
I've found an issues with the way SDP identifies a workstation for audit proposes.
The issue appears if you use a VPN client and audit the Workstation when the NORTEL VPN client is active. If you scan a machine with the VPN Active the MAC address reported is the "virtual/fake" MAC address of the Nortel client.
The problem is that this MAC address is the same for all machines. Thus using the MAC address as the unique indentifier is not a good process. Unfortunatly MAC address can be duplicated and are in the case of Virtual Network Adapters.
Therefore on a subsequent audit the workstation id is selected using the MAC address (log entry -- new WS ID for macAddress ==> NUMBER_HERE ).
That number is normally wrong but the scan continues using a wrong WorkstaionID as reference. (ie deletes all the SW add all the new software against a different worksation)
However it crashes the process when updating the Resources.
SQLException while updating the Row <Resources RESOURCEID=NUMBER_HERE RESOURCENAME= "MACHINE_NAME" ACQUISITIONDATE="null" WARRANTYEXPIRY="null" EXPIRYDATE="null" COMPONENTID="47" ASSETTAG="null" SERIALNO="null" BARCODE="null" PURCHASELOTID="null" VENDORID="null" RESOURCESTATEID="2" />
Reason the Workstation ID and the Resource name do not match and there is another resourcename equals to "MACHINE_NAME" in the resource table therefore the Key constraint Resource_UK1 gives the error.
I've reported this error already but I've not recevied any solution.
Regards,
Nuno
I've found an issues with the way SDP identifies a workstation for audit proposes.
The issue appears if you use a VPN client and audit the Workstation when the NORTEL VPN client is active. If you scan a machine with the VPN Active the MAC address reported is the "virtual/fake" MAC address of the Nortel client.
The problem is that this MAC address is the same for all machines. Thus using the MAC address as the unique indentifier is not a good process. Unfortunatly MAC address can be duplicated and are in the case of Virtual Network Adapters.
Therefore on a subsequent audit the workstation id is selected using the MAC address (log entry -- new WS ID for macAddress ==> NUMBER_HERE ).
That number is normally wrong but the scan continues using a wrong WorkstaionID as reference. (ie deletes all the SW add all the new software against a different worksation)
However it crashes the process when updating the Resources.
SQLException while updating the Row <Resources RESOURCEID=NUMBER_HERE RESOURCENAME= "MACHINE_NAME" ACQUISITIONDATE="null" WARRANTYEXPIRY="null" EXPIRYDATE="null" COMPONENTID="47" ASSETTAG="null" SERIALNO="null" BARCODE="null" PURCHASELOTID="null" VENDORID="null" RESOURCESTATEID="2" />
Reason the Workstation ID and the Resource name do not match and there is another resourcename equals to "MACHINE_NAME" in the resource table therefore the Key constraint Resource_UK1 gives the error.
I've reported this error already but I've not recevied any solution.
Regards,
Nuno