Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Development » How to get sql server machine serial
Add to briefcase

How to get sql server machine serial Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Sarikonda Kunam Raju
Posted Tuesday, May 11, 2010 7:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:22 AM
Points: 20, Visits: 125
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
Post #919701
Arjun Sivadasan
Posted Wednesday, May 12, 2010 3:52 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:29 AM
Points: 365, Visits: 697
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
Post #920302
Sarikonda Kunam Raju
Posted Wednesday, May 12, 2010 4:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:22 AM
Points: 20, Visits: 125
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
Post #920310
Arjun Sivadasan
Posted Wednesday, May 12, 2010 5:02 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:29 AM
Points: 365, Visits: 697
Well it sounds greek to me Raju. Someone who has better exposure will help you soon. Stick around.

- arjun
Post #920331
Lowell
Posted Wednesday, May 12, 2010 6:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:56 PM
Points: 11,613, Visits: 27,669
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #920375
Arjun Sivadasan
Posted Wednesday, May 12, 2010 6:14 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 09, 2013 3:29 AM
Points: 365, Visits: 697
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
Post #920381
Sarikonda Kunam Raju
Posted Wednesday, May 12, 2010 6:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:22 AM
Points: 20, Visits: 125
Dear Sirs,

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

Regards
Raju
Post #920384
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.