I'm not sure if this is a T-SQL question, or a Linked Server question, but I thought I would start here.

I have an ADSI linked server that has been working for what I've needed up until now.  Now I want to retrieve Bitlocker recovery passwords via this same mechanism, but it's not going so well.  I'm not sure it's even possible.

It's my understanding that the Bitlocker information is not a property of the computer object in AD, but is a child object of the computer object.  Is there any way to query THAT through the linked server?

I can create a script that can retrieve the information I want, and write it to file, but I'd rather do it via SQL.

http://blogs.technet.com/b/askcore/archive/2011/08/04/how-to-verify-bitlocker-recovery-keys-in-sql-db-using-mbam.aspx