SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to get sql server machine serial


How to get sql server machine serial

Author
Message
Sarikonda Kunam Raju
Sarikonda Kunam Raju
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 128
Dear Sir,

 
I need a script to find Sql Server Physical Machine Serial. I will be thank ful to the suggession. This is Sql Server 2005.

 
Thanks and Regards

Raju
Arjun Sivadasan
Arjun Sivadasan
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1992 Visits: 976
Do you mean version? Please be more specific in your questions. Otherwise you will find that your questions remain unanswered for a long time.

If you mean version, use the following query.
select serverproperty('productversion')

-arjun
Sarikonda Kunam Raju
Sarikonda Kunam Raju
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 128
Sir,

Sorry for the confusion if my posting was not clear.

Every computer ( here I am looking at Sql Server) will have a locking code unique. I would like to know is there a way to find the locking code of sql server ( physical server) locking code information through a script.

You may visit the site
http://www.quantumwise.com/documents/manuals/Sentinel_RMS/man_files/echoid_and_Wechoid_-_Get_a_Computer_s_Locking_Code.htm

Thanks again for the pains taken.

Thanks
Raju
Arjun Sivadasan
Arjun Sivadasan
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1992 Visits: 976
Well it sounds greek to me Raju. Someone who has better exposure will help you soon. Stick around.

- arjun
Lowell
Lowell
SSC Guru
SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)SSC Guru (121K reputation)

Group: General Forum Members
Points: 121521 Visits: 41403
never heard of this locking code before today. it looks like a calculated value created by the program ecoid.exe.

the program echoid.exe is not a Windows included executable, so of course it does not exist on all machines; you could only use it if it is installed, and also that the program exists int he PATH variables on the server...also note that the page you directed us to requires a .dat file to be in place as well.

Tip: The file echoid.dat must be in the same directory as the echoid program file. This file defines what criteria will make up the fingerprint and is shipped along with echoid.exe.



with that in mind, here is how you would use xp_cmdshell to call the program and get it's results in a table...you'd then need to parse the results.

create table #Results (
TheOutput varchar(1000))

insert into #Results (TheOutput)
exec master..xp_cmdshell 'echoid -d'

select * from #Results



and my results:

'echoid' is not recognized as an internal or external command,
operable program or batch file.
NULL



Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Arjun Sivadasan
Arjun Sivadasan
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1992 Visits: 976
with that in mind, here is how you would use xp_cmdshell to call the program and get it's results in a table...you'd then need to parse the results.

create table #Results (
TheOutput varchar(1000))

insert into #Results (TheOutput)
exec master..xp_cmdshell 'echoid -d'

select * from #Results



Wow!! I wonder how many years away I am from that. It sure is one small step at a time. Thanks a lot.

- arjun
Sarikonda Kunam Raju
Sarikonda Kunam Raju
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 128
Dear Sirs,

Thanks a lot to all. I shall try it and update you.

Regards
Raju
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search