→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
Hello, I've looked all over and can't find this...

Can you give the SQL for a report to show for all computers in domain: computer name, software name, and product key? Specifically, I'm looking for MS office product keys, to show any duplicates across computers names.

Also, what would the code be to display computer name, OS, and OS product key? Again, to show duplicate product keys across computer names (i'm aware of the Dell, HP issue having duplicate keys due to volume imaging)

Software licensing audit coming up and need to know which computers have duplicate keys.

Lansweeper Alumni
I suggest you try the version 4.0 beta.
These 2 reports are included by default.