You can use the mof edit that sherry has posted in the past. http://myitforum.com/myitforumwp/2012/02/21/installed-sql-05-sql08-and-sql12-version-information-via-configmgr-hardware-inventory/
I am using BDNA for it which works great. [cid:[email protected]] ________________________________ John Marcum Lead Desktop Engineer Bradley Arant Boult Cummings LLP ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Eric Morrison Sent: Wednesday, February 05, 2014 2:11 PM To: [email protected] Subject: [mssms] MSFT True-Up Queries for SQL Versions Hello Everyone, We're trying to wrap up our MSFT true-up and I'm trying to find all full installs of SQL and what version, like enterprise or standard. I've tried to use the AI report, License 01A, but it's definitely not accurate from what I've checked already. I'm trying to create some stuff on my own, but can't figure out how to find the version installed. I've searched online, but still no luck. Does anyone have any suggestions? Thanks! Eric Morrison ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.
<<inline: image001.png>>
