Thanks for the reply Daniel. I did search off that field with no hits.
Here what I have tried so far:
SELECT
*
FROM [CM_SMS].[dbo].[v_R_System]
Where [Previous_SMS_UUID0] = 'GUID:B3D62BD4-D238-4365-9323-647083B11C1E'
or
[SMS_Unique_Identifier0] =
'GUID:B3D62BD4-D238-4365-9323-647083B11C1E'
or
[SMBIOS_GUID0] = 'B3D62BD4-D238-4365-9323-647083B11C1E'I have also tried like '%B3D62BD4%' in the where clauses instead of equals(=). Thanks, Ken ... From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Thursday, July 18, 2013 10:45 AM To: [email protected] Subject: [mssms] RE: Error in MP ClientAuth.log file That might be the UUID/SMBIOS GUID not the SMS GUID? That info is still listed on the v_R_System view under SMBIOS_GUID0. Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Lutz, Ken Sent: Thursday, July 18, 2013 1:25 PM To: SMS List Subject: [mssms] Error in MP ClientAuth.log file I'm getting a repeating error in the MP Clientauth.log file. This error gives the GUID of the machine in question. I can't seem to find the machine in the database. I have looked in the v_R_System view at the fields with GUIDs and cannot find this machine. Where do I have to go to find this GUID? Here are the fields that I have looked at for the GUID: Previous_SMS_UUID0 SMS_Unique_Identifier0 SMBIOS_GUID0 Here is the error messages from the MP CleintAuth.log: Encountered database error while verifying headers for client 'GUID:B3D62BD4-D238-4365-9323-647083B11C1E' (0x87d00238). ClientAuth 7/18/2013 10:15:40 AM 4408 (0x1138) Error verifying message from client 'GUID:B3D62BD4-D238-4365-9323-647083B11C1E' (0x87d00238). ClientAuth 7/18/2013 10:15:40 AM 4408 (0x1138) Thanks, [cid:[email protected]] Ken Lutz Senior Systems Administrator Information Systems Department Spokane County 815 N. Jefferson Spokane, Washington 99260 The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
<<inline: image001.png>>
