CODEWITHSUNDEEP
c#sql-server-2008wmicpu
Arto Uusikangas
Arto Uusikangas

Reputation: 1909

Howto access WMI in SQL CLR Projects

I have a project i've been working on that requires me to retrieve the CPU ID of the computer to create a software licence and check it against the current licens registered.

So, said and done i made 2 programs to make this happen. Then i need to implement this solution into my CLR project.

I notice that i can't add System.Management reference in an SQL Project.

So therefor i can't access the said controls to retrieve the CPU ID as i did in my other .NET programs.

Please ive been searching for a solution for this for a week now and any hints would really help. Ive seen people including the System.Management.dll at creation of the SQL Assembly but i really cant grasp how its done.

Upvotes: 2

Views: 810

Answers (2)

GrahamMoore
GrahamMoore

Reputation: 61

I think you need to enable the 'unsafe' option in your CLR project to be able to add a reference to System.Management.dll. The System.Management.dll will then need adding to the datbase using CREATE ASSEMBLY.

Upvotes: 0

Coding Flow
Coding Flow

Reputation: 21881

Your best bet would probably be to create a web service that does the WMI stuff and returns the cpu id.

Alternatively if you want to go over to the dark side you could you could look at xp_cmdshel and OLE Automation Objects to access external resources.

Upvotes: 2

Related Questions