pluginsocsinventory-ng / officepack Goto Github PK
View Code? Open in Web Editor NEWRetrieve microsoft office keys
License: GNU General Public License v2.0
Retrieve microsoft office keys
License: GNU General Public License v2.0
I don't know if this is a real issue but I dont view the office license keys for product Office homeBusinessRetal .
Hi,
I'm using OCS Server v2.6 on Debian 9.9
Officepack is installed this way:
aptitude install python3-pip -y
pip3 install scp
cd /usr/share/ocsinventory-reports/ocsreports/extensions
wget https://github.com/PluginsOCSInventory-NG/officepack/releases/download/3.0/officepack.zip
unzip officepack.zip
rm -f officepack.zip
# Go to http://server/ocsreports and install the plugin
cd /usr/share/ocsinventory-reports/ocsreports/tools
python3 install_plugin.py
So far, so good.
Now, I'm trying to inventory 2 PC:
When I launch the inventory, none of the computers shows up in OCS interface.
If I delete msofficekey.vbs and relaunch the inventory, both computers shows up in OCS interface.
When I launch msofficekey.vbs manually, I can see MS Office version and key correctly.
Any advice? Thanks in advance
Hi all,
Im sorry but i try to found a solution but is not posible, i installed the plugins, and i can see in Mysql DB and log of agent the data is send to server.
but when i access to ocs inventory ad the software option that this pc, i have this
i don't know what i have bad.
sorry for my english i speak spanish.
Thanks
Greetings,
you have wrong syntax in file ms_officepack on line 38:
$sql['SQL'] .= "FROM officepack WHERE 1";
should be
$sql['SQL'] .= "FROM officepack WHERE install=1";
Also are you planning on adding all the features from previous officepack version for version 2.1?
Summary of licences was awesome feature which is missing here.
Best Regards.
Hey,
I have a problem with the 2016 office keys reporting, with the last 5 characters. The OCS agent will send 3 keys and the server will receive them, but after a while the key with the correct last octet will be removed from the server. Does anyone know why he is removed?
Améliorer le plugin Office afin :
I have updated OCS Server from 2.6 to 2.7 version. After the installation can't install officepack plugin.
I have deleted every element of old officepack installation even I dropped the tables in MySQL, but when I click Install in extensionmanager page produces the next message:
"Extension successfull installed !
Please, logout and re-log to finish the console installation."
Later I logout and re-log but the table in the same webpage(extensionmanager) where plugin must show is empty and if I look for the tables in MySQL I only find officepack, the first table that script creates.
I have corrected MySQL credentials in z-ocsinventory-server.conf and zz-ocsinventory-restapi.conf but same trouble.
I have been looking for ocs, apache and MySQL logs but doesn't show any error about this.
Can you help me?
I have followed all the instructions and launched scripted installation after I created all the tables structure from .sql files and the data of Office is coming to the server. I can see data in "officepack" table, but OCS web doesn't show me the Officepack details ...
Note: Sorry for my english, I'm from Spain.
Officepack displays only one entry for office 2016.
The problem is if we have both Office 2016 and Visio 2016 installed on one station. The agent only downloads/display the latest entry.
Another problem - all the time automatically does not find keys from Office 2013 (Office 15). I have to manually modify the vbs script and change the path to OSPP.VBS.
WARNING *** EXECUTABLE PLUGIN => Executable plugin <C:\Program Files (x86)\OCS Inventory Agent\plugins\msofficekey.vbs> output is not UTF-8 encoded or an XML document, trying to UTF-8 encode
Hi
I just updated OCS Server to ver.2.4.1 (from 2.4) and my all available plugins and packages to teledeploy has gone.
I can install again all plugins it's not a big problem, but all my packages to teledeploy... Any hint to restore my all packagaes?
Hi,
Error message when accessing licence details
Regards
When I try to force the license to the inclusion within ocsinventory, often it takes a long time before it is incorporated.
Is there any way to speed it?
Also advise me whether or not to enable SSL using this plugin?
Thx for support
Plugin oficepack successfully installed, but when viewing computer data (hardware, software, devices, etc ...) could not find the office of the license information. Generating the XML file with the data from the computer, the office of the license information is there.
I would like to know what procedures to properly configure OCS to download the Office keys. I followed some tutorials and I can not get the information.
I would also like to know how to view this information.
I'm using CentOS 7 and testing the agent on a Windows 10 computer.
Hello.
Is it possible to retrieve office key in Office Click-To-Run install?
Hy,
Is there any possibility to list the license status? With the older version we can set the count of the licenses and the plugin show the percentage.
Hello,
i become no Data from the Agent.
Version 2.0 anybody can Help?
Hi, again
Sorry, but at line #116, in " oVer = aOffID (a, 0) " I did not find the variable a in the script.
Is it a mistake?
If I want to make a contribution, how should I do it?
Best regards
PS. Ups, MY mistake. I will close the issue.
Hello I installed officepack on my Centos server, I used this instructions:
http://ask.ocsinventory-ng.org/8236/plugin-officepack-for-ocsserver2-3-1-ubuntu16-04
and
http://ask.ocsinventory-ng.org/4289/officepack-in-ocs-server-2-2-problem-and-solution
I have permission to my file and folder:
File: /etc/ocsinventory-server/perl/Apache/Ocsinventory/Plugins/Officepack/Map.pm
Permission: -rw-rw-rw-. 1 apache root 1064 08-02 11:19 Map.pm
File: /etc/ocsinventory-server/plugins/Officepack.conf
Permission: -rw-rw-rw-. 1 apache root 58 08-02 11:17 officepack.conf
Folder: /usr/share/ocsinventory-reports/ocsreports/plugins/computer_detail
Permission: drwxr-xr-x. 33 apache root 4096 07-19 09:48 computer_detail
I extort get new data from computer to OCS, but still I have empty "Office Key Manager"
My server:
PHP: 5.6.36
Server WWW: httpd
MYSQL: Ver 14.14 Distrib 5.6.10
OCS: ver 2.5
OfficePack: ver 2.0
WindowsAgentOCS: ver 2.3
The key of MS Office 2013 Home and Business can not be read, only version 2016 Home and Business.
I use Windows 10 Pro 64 bit. The MS Office version is 32 Bit, both 2013 and 2016.
If I start the VBS script manually, I see the output only on the computer with 2016 version. The 2013 version has neither issue nor error.
I use last version of OCS Inventory 2.3.1, Agent 2.30, and Officepack 1.1.1
Please, can someone tell me what I'm doing wrong?
Thanks in advance
Good afternoon.
I write these lines in relation to the Office plugin that you have developed for OCS. I would like to know if there is a version of your plugin to know the features of Office and that it is compatible with the latest version of OCS 2.4 Server released in December 2017.
I installed the released version 2.0 of the plugin from September 2017 (before the release of the latest version of OCS) and I have two problems:
Hello.
Can you update officepack release? You guys made changes but release is old.
I've installed the plugin and I can see it at the plugins tab, but when I try to see the information about office license, no data is showed.
I've alrun the .vbs at the windows computer and it works.
Officepack: https://github.com/PluginsOCSInventory-NG/officepack/releases/download/1.1.1/officepack.zip
PHP Version :7.0.15
Web Server :Apache/2.4.18 (Ubuntu)
Database Server :Ubuntu) version 5.7.17-0ubuntu0.16.04.1
Version OCSReports: 2.3.1
Please, can someone tell me what I'm doing wrong?
Thanks in advance
Hey,
i don´t know if the function is not available or if i only don´t know how to get it.
Is there a possibility to get a list of all office Keys? With the Windows license this is possible over search with various criteria but i didn´t get it for the office license.
OCS 2.3
officepack 1.1
It occurred to me, that when I have a windows client that has two different MS product installations (like Visio 2010 AND Office 2013) then this script will only detect one key (Visio in my case) and that's it, never reporting the other key. I assume the script is quiting to early. I can't really read vbs but I will try again but any help on this issue would be appreciated, because for now it is not collecting all available key data as if it assumes to detect only one "officepack" and not regarding the possibility that you could have two versions installed - or just one program from an older office version (like with Visio). Can someone confirm this issue?
Hello,
we use Server OCS 2.3 on Ubuntu 16.04, Agent 2.3.0.0. on Win 10.
First i tried to install the plugin with the old howto (cause i didn´t found this) but this didn´t worked.
Now i imported the plugin, but when i want to install it i get two red bars with: MySQL error: Installation aborted !
The plugin is not listed in database table plugins
i also removed all old things from teh plugin in:
/etc/ocsinventory-server/plugins/
/etc/ocsinventory-server/perl/Apache/Ocsinventory/Plugins/
/usr/share/ocsinventory-reports/ocsreports/plugins/computer_detail/
I didn´t get an error in the apache error.log also no error in the ocs log.
Bonjour, j'ai aussi voulu installé le plugin Officepack toujours erreur MySQL error: Installation aborted !
Avez vous une solution ? Je suis sur une debian 9 avec Apache2 et php7 avec un OCS 2.0.
Hello, I also wanted to install the Officepack plugin always error MySQL error: Installation aborted!
Do you have a solution ? I am on a debian 9 with Apache2 and php7 with an OCS 2.0.
I'm sorry for my english I'm french.
Hi,
I tried to install this officepack plugin, but I get an error message, it's contains the following:
ERROR: officepack-master is an invalid plugin, check your sources.
Installation aborted !
This plugin updated 15 days ago, so I think this is the latest version.
Can somebody help me how can I install this plugin?
Regards.
Hi i ve an issue with the plugin the data about office 16 are showed only if i lunch the OCSInventory.exe /force from command prompt in a windows client. All the versions server client plugin are the last i found. Thanks
Hi,
when trying to install the plugin I receive the following error:
"MySQL error: Installation aborted !"
Hi
I do not know if this is the appropriate place for this message, I did not find another place to do this.
In a quick review, I noticed that at line #39 where " aOffID (5.1) ="16.0" " should be " aOffID (5,1) ="16.0" ".
There is a dot where there should be a comma, probably causing a failure to interpret the value of the last key of the array.
I'm wrong?
Excuse me for my bad English.
Salut
Je ne sais pas si c'est l'endroit approprié pour ce message, je n'ai pas trouvé d'autre endroit pour le faire.
Dans une revue rapide, j'ai remarqué qu'à la ligne # 39 où " aOffID (5.1) ="16.0" " devrait être " aOffID (5,1) ="16.0" ".
Il y a un point où il devrait y avoir une virgule, causant probablement un échec pour interpréter la valeur de la dernière clé du tableau.
J'ai tort?
Excusez-moi pour mon pauvre Français.
Hello!
I'm trying to install office plugin on my server, but i got error: MySQL error: Installation aborted !
apache logs:
Scalar value @part_query[...] better written as $part_query[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53.
Scalar value @Args[...] better written as $args[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53.
ocsinventory-server: Can't load SOAP::Transport::HTTP* - Web service will be unavailable
[Fri Sep 14 00:07:08.871228 2018] [mpm_prefork:notice] [pid 739] AH00163: Apache/2.4.25 (Debian) mod_perl/2.0.10 Perl/v5.24.1 configured -- resuming normal operations
[Fri Sep 14 00:07:08.871244 2018] [core:notice] [pid 739] AH00094: Command line: '/usr/sbin/apache2'
[Fri Sep 14 06:54:30.315484 2018] [:error] [pid 3828] [client 192.168.2.102:1168] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/
[Fri Sep 14 06:54:30.315563 2018] [:error] [pid 3828] [client 192.168.2.102:1168] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/
[Fri Sep 14 06:54:49.358776 2018] [:error] [pid 3830] [client 192.168.2.102:1175] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /usr/share/ocsinventory-reports/ocsreports/require/search/Search.php on line 661, referer: http://ocsinventory/ocsreports/?function=show_ipdiscover
[Fri Sep 14 07:16:28.095493 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=visu_computers
[Fri Sep 14 07:16:28.095584 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=visu_computers
[Fri Sep 14 07:16:39.294166 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?first
[Fri Sep 14 07:16:39.294224 2018] [:error] [pid 2914] [client 192.168.2.102:1579] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?first
[Fri Sep 14 07:18:45.711131 2018] [:error] [pid 2915] [client 192.168.2.102:1606] PHP Warning: array_key_exists() expects parameter 2 to be array, null given in /usr/share/ocsinventory-reports/ocsreports/require/search/Search.php on line 650, referer: http://ocsinventory/ocsreports/index.php?function=visu_all_soft
[Fri Sep 14 07:21:31.675855 2018] [:error] [pid 2914] [client 192.168.2.102:1643] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=8&cat=software
[Fri Sep 14 07:21:31.675913 2018] [:error] [pid 2914] [client 192.168.2.102:1643] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=8&cat=software
[Fri Sep 14 07:21:45.219407 2018] [:error] [pid 2916] [client 192.168.2.102:1645] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74
[Fri Sep 14 07:21:45.219495 2018] [:error] [pid 2916] [client 192.168.2.102:1645] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103
[Fri Sep 14 07:51:35.259413 2018] [:error] [pid 2918] [client 192.168.2.102:2063] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=ipdiscover_info&prov=no_inv&head=1&value=192.168.2.0
[Fri Sep 14 07:51:35.259551 2018] [:error] [pid 2918] [client 192.168.2.102:2063] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=ipdiscover_info&prov=no_inv&head=1&value=192.168.2.0
[Fri Sep 14 08:11:14.594163 2018] [:error] [pid 3828] [client 192.168.2.102:2242] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=37&cat=software
[Fri Sep 14 08:11:14.594218 2018] [:error] [pid 3828] [client 192.168.2.102:2242] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=computer&head=1&systemid=37&cat=software
[Fri Sep 14 08:15:28.426949 2018] [:error] [pid 3829] [client 192.168.2.102:2275] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?first
[Fri Sep 14 08:15:28.427054 2018] [:error] [pid 3829] [client 192.168.2.102:2275] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?first
[Fri Sep 14 08:39:49.742937 2018] [mpm_prefork:notice] [pid 739] AH00169: caught SIGTERM, shutting down
Scalar value @part_query[...] better written as $part_query[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53.
Scalar value @Args[...] better written as $args[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53.
ocsinventory-server: Can't load SOAP::Transport::HTTP* - Web service will be unavailable
Scalar value @part_query[...] better written as $part_query[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53.
Scalar value @Args[...] better written as $args[...] at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Interface/AssetCategory.pm line 53.
ocsinventory-server: Can't load SOAP::Transport::HTTP* - Web service will be unavailable
[Fri Sep 14 08:40:05.334042 2018] [mpm_prefork:notice] [pid 944] AH00163: Apache/2.4.25 (Debian) mod_perl/2.0.10 Perl/v5.24.1 configured -- resuming normal operations
[Fri Sep 14 08:40:05.334116 2018] [core:notice] [pid 944] AH00094: Command line: '/usr/sbin/apache2'
[Fri Sep 14 08:41:20.074465 2018] [:error] [pid 979] [client 192.168.2.102:2717] PHP Warning: vsprintf(): Too few arguments in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 74, referer: http://ocsinventory/ocsreports/index.php?function=pluginsmanager
[Fri Sep 14 08:41:20.074530 2018] [:error] [pid 979] [client 192.168.2.102:2717] PHP Warning: mysqli_query(): Empty query in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 103, referer: http://ocsinventory/ocsreports/index.php?function=pluginsmanager
Debian 9.5
Apache/2.4.25 (Debian)
mysql Ver 15.1 Distrib 10.1.26-MariaDB
OCS Inventory Server 2.5
Hi,
The installation of the plugin is ok, on my agent too
But when I want see result, OCS told me "ACCESS DENIED" , same result with different version
/index.php?function=officepack&value=2016
/index.php?function=officepack&value=2013
/index.php?function=officepack&value=2007
If I clic on a computer, software, at the bottom I can the the licence detail of this computer
Thanks
The version of Office 2016 is counted as Office 2013.
you can fix the problem?
Thank you
Helooo....
I use pluging officepack-3.0
ocsinventoryng repo fedora OCS Inventory 2.6
Windows agent v2.6.0.0
If the agent is automatic, office 365 and 2016 are deleted from the ocsreport.
I´m running
"OCSInventory.exe / NP / Debug = 2 / xml = c: \ temp"
and then importing "archive.xml" to the server
Office 365 and Office 2016 appear in the database.
Some help ...
I have also observed that the officepack-3.0 plugin only creation the officepack database.
in the install.php I see
// Officepark tables creation
include sql/officepack-php
include sql/officepacl-guid-fr.php
//
but officepacl-guid-fr.php not ejecuted
I have manually created all the databases in the officepack-guid-fr.sql, with all its data.
The result is the same office 365 and 2016, when it runs automatically they are deleted.
Please help ,
Thank you
Sorry for my English I use a translator.
My configuration is OCS Server v2.6 and OfficePack v3. When I install officepack my clients can't send their inventories. Looking for the problem I have found the issue.
The offipack installation package doesn't create 2 filelds in 'officepack' table. The fields are:
I have created them and plugin works correctly.
I hope I can help some other people with my find.
While installing Office plugin I got the error:
ERROR: check if Map.pm and [pluginName].conf exist
Please help me how do I solve it?
Hi all,
When I put the officepack or other plugin in the correct download folder, it appears in the web GUI for installation. But when I hit the Install button, it goes to a blank page and it doesnt install.
I have a fresh installation of OCS 2.2 in ubuntu server 16.04
Thanks in advance
Regards
Hugo Serras
No detection of Office 2016 and Office 2019. OS is Windows 10 Pro. Offices are 64 bit version.
I did download and extract to /usr/share/ocsinventory-reports/ocsreports/plugins
But i dont see in http://server/ocsreports/index.php?function=pluginsmanager
Hi,
I have Newest OCS Inventory 2.4 server installed.
Wanted to mention that others (up to date plugins are working) and can be uninstalled fast and easy.
My Servers parameters:
Ubuntu 16.04.3 LTS
PHP Version :7.0.22
Web Server : Apache/2.4.18 (Ubuntu)
Database Server: (Ubuntu) version 5.7.20-0ubuntu0.16.04.1
Version OCSReports: 2.4
If you are interested in this issue I could give you more intel.
Probably could make another server clone to experiment on.
P.S. Sorry for bad English.
HI,
I installed and configured officepack plugin for OCS. However I do not see any keys being managed under the plugin.
I started debugging with running the .vbs locally and I received the correct information.
Then I run the ocs agent and I noticed that although it finds the .vbs script and it runs it, it doesn’t produce any output to send it to the server:
EXECUTABLE PLUGIN => Searching for VBS script(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
EXECUTABLE PLUGIN => Found executable plugin <msofficekey.vbs>
================= TRACE START ===============
================= TRACE STOP ===============
EXECUTABLE PLUGIN => Plugin <msofficekey.vbs> executed successfully
EXECUTABLE PLUGIN => Searching for PS1 script(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
AGENT => Sending Inventory
Could someone give me an idea on how I could fix this? Or what else should I check?
The ocs server is the 2.5 version installed on a debian stretch with the latest officepack plugin (2.0.0)
Thank you in advance for your help.
Best regards,
Dana
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.