No detection of Office 2016 and Office 2019 about officepack

[nExNihilo]

Same problem with a computer win 7 64bit and office 2013. No detection but ok for office 2007

[bajlek]

Hi, guys...I have fresh install Ubuntu 18.04.2 + OCSNG 2.6RC and a lot of plugins. Everythiong seems to work, but Office plugin (last version, branch: rework) is not showing me Office 365. Office 2010 works fine.

Office 365

Office 2013

MySQL ocs tables

I have everything in last versions...

VBS script
'---------------------------------------------------------- ' Plugin for OCS Inventory NG 2.x ' Script : Retrieve Microsoft Office informations ' Version : 2.24 ' Date : 14/06/2017 ' Author : Creative Commons BY-NC-SA 3.0 ' Author : Nicolas DEROUET (nicolas.derouet[gmail]com) ' Contributor : Stéphane PAUTREL (acb78.com) '---------------------------------------------------------- ' OS checked [X] on 32b 64b (Professionnal edition) ' Windows XP [X] ' Windows Vista [X] [X] ' Windows 7 [X] [X] ' Windows 8.1 [X] [X] ' Windows 10 [X] [X] ' Windows 2k8R2 [X] ' Windows 2k12R2 [X] ' Windows 2k16 [X] ' --------------------------------------------------------- ' NOTE : No checked on Windows 8 ' Included : Office 2016 and 365 versions

How can I fix it?

[gehasia]

Hi guys,
may i ask you to try my patched version here :
https://github.com/PluginsOCSInventory-NG/officepack/blob/5fe18ee62fcc388117ea930a6a2f08e00377039e/agent/msofficekey.vbs

There is a PR rotting for months, it doesn't seems it will be merged soon, but if people say it resolves their issues maybe it will
#41

[bajlek]

Maybe it is problem with different architecture between OS and OFFICE? Windows x64 X Office x86?

MACHINE 1 - OS Windows 10 x64 + Office 2013 x86 (wrong patch to OSPP.vbs)
Issue still there....I have VBS script from you, but the script maybe incorrectly detect path to OSPP.VBS

Output from VBS script

Output.txt

My version is Office 2013 and If I run OSPP.VBS with correct path...

It works on machine with Office 2013 installed only if I edit VBS script (delete Office 2016 version)

Dim aOffID(4,1) aOffID(0,0) = "XP" aOffID(0,1) = "10.0" aOffID(1,0) = "2003" aOffID(1,1) = "11.0" aOffID(2,0) = "2007" aOffID(2,1) = "12.0" aOffID(3,0) = "2010" aOffID(3,1) = "14.0" aOffID(4,0) = "2013" aOffID(4,1) = "15.0"

MACHINE 2 - OS Windows 10 x64 + Office 365 x64 (correct path to OSPP.vbs)
If I have Office 365 installed, everything works fine (even if it is trial version), so I have output.txt with all data, last VBS script, but still - no information in OCSNG server for the machine (pictures below)

Data from OCSNG from this machine with Office 365 trial (not activated)

And list of plugins (all works corretly I think - I have data in OCSNG)

MACHINE 2 (the same machine as above) - OS Windows 10 x64 + Office 365 x86 (correct patch to OSPP.vbs)

MACHINE 2 debug OCSNG (see row with officepack)
_
Starting OCS Inventory NG Agent on Friday, March 29, 2019 09:33:48.
AGENT => Running OCS Inventory NG Agent Version 2.4.0.0
AGENT => Using OCS Inventory NG FrameWork Version 2.4.0.0
AGENT => Loading plug-in(s)
DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
DLL PLUGIN => 0 DLL Plug-in(s) successfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
COM PROVIDER => Loading Communication Provider <C:\Program Files (x86)\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider Version <2.4.0.0>
AGENT => Sending Prolog
DID_CHECK => Read DeviceID and MACs <00:50:56:AA:95:5F> in file <ocsinventory.dat>
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <cacert.pem>
COM SERVER => Sending HTTP Post request to URL http://ocsng.XXX.XX/ocsinventory
COM SERVER => HTTP Post response received <HTTP Status Code #200>
COM SERVER => Cleaning cURL library
AGENT => Prolog successfully sent
AGENT => Prolog Frequency set to 12 hour(s)
AGENT => Inventory on startup option set to 1
AGENT => Inventory required
AGENT => Launching hardware and software checks
INVENTORY => Loading Download history
INVENTORY => Logged on user ID is <jan.XXXX>
INVENTORY => Operating System is <Microsoft Windows 10 Pro 10.0.17763 >, description <>
INVENTORY => Operating System uses 64 bits memory address width
INVENTORY => Computer domain or workgroup is <XXXX.cz>
INVENTORY => User domain is <>
INVENTORY => System Manufacturer <VMware, Inc.>, System Model , System S/N <VMware-42 2a 74 37 0d d0 da 70-1f 23 68 ef 93 5d 60 c2>, Bios Manufacturer , Bios Date <09/21/2015>, Bios Version <6.00>, Motherboard Manufacturer , Motherboard Model <440BX Desktop Reference Platform>, Motherboard S/N
INVENTORY => 2 processor(s) Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz [1 core(s) x86_64] at 2397 MHz
INVENTORY => OS Memory 4096 MB, OS Swap size 4800 MB
INVENTORY => 64 memory slot(s) found
INVENTORY => 2 input device(s) found
INVENTORY => 4 system port(s) found
INVENTORY => 7 system slot(s) found
INVENTORY => 5 system controller(s) found
INVENTORY => 2 storage peripheral(s) found
WARNING *** INVENTORY => Failed to retrieve sound devices
WARNING *** INVENTORY => Failed to retrieve modems
INVENTORY => 1 network adapter(s) found
INVENTORY => 4 system printer(s) found
INVENTORY => 1 video adapter(s) found
INVENTORY => 1 system monitor(s) found
INVENTORY => Default IPv4 address is <192.168.141.84>
INVENTORY => Registered company <>, registered owner , Product ID <00330-80...>
INVENTORY => Product key <VK7JG-NP...>
INVENTORY => 35 software found
INVENTORY => Computer/VM UUID is <37742A42-D00D-70DA-1F23-68EF935D60C2>
INVENTORY => Computer seems to be VMware virtual host
INVENTORY => System Memory set to 4096 (instead of 4096)
INVENTORY => Reading last inventory state
EXECUTABLE PLUGIN => Searching for VBS script(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
EXECUTABLE PLUGIN => Found executable plugin <bitlockerstatus.vbs>
EXECUTABLE PLUGIN => Plugin <bitlockerstatus.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <checkFiles.vbs>
EXECUTABLE PLUGIN => Plugin <checkFiles.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <driverslist.vbs>
EXECUTABLE PLUGIN => Plugin <driverslist.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <Hpmgmt.vbs>
EXECUTABLE PLUGIN => Plugin <Hpmgmt.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <listprinters.vbs>
EXECUTABLE PLUGIN => Plugin <listprinters.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <msofficekey.vbs>
WARNING *** EXECUTABLE PLUGIN => Plugin <C:\Program Files (x86)\OCS Inventory Agent\plugins\msofficekey.vbs> does not produce any output
EXECUTABLE PLUGIN => Found executable plugin <networkshare.vbs>
WARNING *** EXECUTABLE PLUGIN => Plugin <C:\Program Files (x86)\OCS Inventory Agent\plugins\networkshare.vbs> does not produce any output
EXECUTABLE PLUGIN => Found executable plugin <oracle.vbs>
WARNING *** EXECUTABLE PLUGIN => Plugin <C:\Program Files (x86)\OCS Inventory Agent\plugins\oracle.vbs> does not produce any output
EXECUTABLE PLUGIN => Found executable plugin <osinstall.vbs>
EXECUTABLE PLUGIN => Plugin <osinstall.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <pluginslist.vbs>
EXECUTABLE PLUGIN => Plugin <pluginslist.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <runningDatabaseInstances.vbs>
EXECUTABLE PLUGIN => Plugin <runningDatabaseInstances.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <scheduledtasks.vbs>
EXECUTABLE PLUGIN => Plugin <scheduledtasks.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <security.vbs>
EXECUTABLE PLUGIN => Plugin <security.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <sharedfolders.vbs>
EXECUTABLE PLUGIN => Plugin <sharedfolders.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <uptime.vbs>
EXECUTABLE PLUGIN => Plugin <uptime.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <winupdate.vbs>
EXECUTABLE PLUGIN => Plugin <winupdate.vbs> executed successfully
EXECUTABLE PLUGIN => Found executable plugin <winusers.vbs>
EXECUTABLE PLUGIN => Plugin <winusers.vbs> executed successfully
EXECUTABLE PLUGIN => Searching for PS1 script(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
EXECUTABLE PLUGIN => Found executable plugin <services.ps1>
EXECUTABLE PLUGIN => Plugin <services.ps1> executed successfully
AGENT => Sending Inventory
INVENTORY => Checking last inventory state
INVENTORY => Logical drives inventory state changed
INVENTORY => Printers inventory state changed
INVENTORY => Software inventory state changed
INVENTORY => Inventory changed since last run
INVENTORY => Generating XML document with Device properties
INVENTORY => XML Update BIOS
INVENTORY => XML Update 2 CPU(s)
INVENTORY => XML Update 64 Memory Slot(s)
INVENTORY => XML Update 2 Input Device(s)
INVENTORY => XML Update 4 System Port(s)
INVENTORY => XML Update 5 System Controller(s)
INVENTORY => XML Update 7 System Slot(s)
INVENTORY => XML Update 0 Sound Device(s)
INVENTORY => XML Update 2 Storage Peripheral(s)
INVENTORY => XML Update 2 Logical Drive(s)
INVENTORY => XML Update 0 Modem(s)
INVENTORY => XML Update 1 Network Adapter(s)
INVENTORY => XML Update 1 Video Adapter(s)
INVENTORY => XML Update 1 Monitor(s)
INVENTORY => XML Update 4 Printer(s)
INVENTORY => XML Update 36 Software
INVENTORY => XML Update 0 Registry Value(s)
INVENTORY => XML Update Administrative Information(s)
INVENTORY => XML Update common Device properties
COM SERVER => Initializing cURL library for sendRequest
COM SERVER => Using cURL without server authentication
COM SERVER => Disabling cURL proxy support
COM SERVER => Enabling cURL SSL server validation support using CA Bundle <cacert.pem>
COM SERVER => Sending HTTP Post request to URL http://ocsng.XXX.XX/ocsinventory
COM SERVER => HTTP Post response received <HTTP Status Code #200>
COM SERVER => Cleaning cURL library
AGENT => Inventory successfully sent
INVENTORY => Writing new inventory state
AGENT => Communication Server asked for Package Download
DOWNLOAD => Found OCS Inventory Agent Setup result file <C:\ProgramData\OCS Inventory NG\Agent\download\OCSNG-Windows-Agent-Setup_done>
ERROR *** DOWNLOAD => Found result code for OCS Inventory Agent Setup package but no package ID specified, so remove all packages to avoid running Agent setup in loop !
DOWNLOAD => Package history file successfully cleaned for duplicate IDs
DOWNLOAD => Download disabled by server
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:02:24.
_

How to continue?

[gehasia]

Hi @bajlek :

I did a little patch on my modified script to rely on SKU ID to write output to XML.
I was previously only relying on PRODUCT ID but after some checks (hopefully i have some 2013 licences at my company !), there is no PRODUCT ID on the Office 2013 OSPP.VBS output... so it could not work.

https://raw.githubusercontent.com/PluginsOCSInventory-NG/officepack/0e0b07fac670769a94f1d076793bc9ae06774cad/agent/msofficekey.vbs

It would have work in certain cases (both 2013 and 365 or 2016 installed, or the presence of a more recent OSPP file).

To explains how it works, the script try to execute the OSPP.vbs in every path it should be present, at each execution, it will output an output.txt file even if there is no OSPP.vbs present (because path does not exists), that's why you're having an output.txt with an invalid path.
Each time it generate an output.txt, it tries to read this file and get office informations from it, if it's the case it's outputting to the xml, and then it continues to next version.

So if you have an office 2013, it will try the Office15 directory at some points, output to ouput.txt and output to xml then continue to next version, Office16 path, which is maybe invalid, output to output.txt, no xml (because there was no OSPP.vbs on that path) and then stop because it's the last version to check.

This last output.txt is "Invalid path (this is the one from Office16), that does not mean it didn't find any good informations before. And it will remains in your user directory.

The only thing to rely on to check if it's working is : "Do you have an XML output when i run the script manually".
If this is the case, the plugin works, if not, i need to do some more debug !

So please, try the new one i've put above and tell me if there is any case you don't have XML output to the screen.
If it's working here, you may have another inconsistency elsewhere (Database, server, etc.)

[ajavor]

@gehasia

In fact, your Office 2013 search did not work in your previous script.
Now I downloaded the script with your last fixes (from the link above) and it works perfectly - Office 2013 is detected again.

Thanks a lot for your work in correct operation and improvement of the plugin!
I do not understand why your corrections are not included in the official version, it's a shame.

[bajlek]

I must admit, that all is fully functional now, but it is strange because I dont update all computers by GPO, only testing one, and now...suddenly all computers and office versions being detected. But as my father says..if it functional, don't touch it

[ajavor]

@gehasia
I have noticed another problem in your latest script that was not before. Office 2010 is detected as Office 14 and only the last part of the key is displayed (second entry), and yet it is possible to draw the entire key for Office 2010 from the Windows registry (the first entry).

[charleneauger]

Hi,

A new release is available for officepack. The detection has been fixed.

Best regards,
Charlene Auger