I have a problem regarding installed/activated office products.

We're using a KACE1000 to gather information for license complience

For example, MS Project is included in our main image that deploys on all machines, but are only activated on a handfull.

The KACE1000 cannot separate the installed versions from the ones that are installed and activated.

Does anyone know an easy way to count only the activated versions?

Answer Summary:
cd C:\Program Files (x86)\Microsoft Office\Office14 cscript ospp.vbs /dstatusall >> c:\temp\test.txt Then have Kace inventory test.txt. ShellCommandTextReturn(cmd.exe /c type c:\temp\test.txt)
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

4

Based on the link that SMal provided you can run this in a script.

cd C:\Program Files (x86)\Microsoft Office\Office14

cscript ospp.vbs /dstatusall >> c:\temp\test.txt

Then have Kace inventory test.txt.

ShellCommandTextReturn(cmd.exe /c type  c:\temp\test.txt)

 

There are many switches to choose from that should help. 

cscript ospp.vbs ?

 will give you the available switches.


  

Answered 08/14/2012 by: dugullett
Red Belt

  • Thanks for putting it together, shouldn't you dump the file to c:\windows\temp? there is no c:\temp by default
    • Just an example. You can dump it anywhere as long as the custom inventory matches. I always use "%ProgramData%\Dell\Cust_Logs" for all of my custom inventory. That way I know where to find everything. It's also hidden from the user. Of course you'll have to mkdir that one as well.
      • thanks, they may not realize that.
  • I can confirm that this works very well. Thnx!
Please log in to comment

Answers

2

The K1000 looks at a set of registry keys for the installed software, it does not care if it is activated or not, just installed.

If you are using KMS and office 2010 you can look on the KMS server for that info.  Otherwise you will have to dig into the registry keys to see if it is activated.

http://blogs.technet.com/b/office2010/archive/2009/12/18/volume-activation-tips-and-tricks.aspx

 

 

Answered 08/14/2012 by: SMal.tmcc
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity