Skip to main content

Office365 SharePoint

Pack assets​

Templates​

The Monitoring Connector Office365 SharePoint brings a host template:

  • Cloud-Microsoft-Office365-Sharepoint-Api-custom

The connector brings the following service templates (sorted by the host template they are attached to):

Service AliasService TemplateService Description
Site-UsageCloud-Microsoft-Office365-Sharepoint-Site-Usage-Api-customCheck SharePoint sites usage
Users-ActivityCloud-Microsoft-Office365-Sharepoint-Users-Activity-Api-customCheck user activity

The services listed above are created automatically when the Cloud-Microsoft-Office365-Sharepoint-Api-custom host template is used.

Collected metrics & status​

Here is the list of services for this connector, detailing all metrics linked to each service.

Metric nameUnit
active-sitesN/A
sharepoint.sites.active.usage.total.bytesB
sharepoint.sites.inactive.usage.total.bytesB
sharepoint.sites.active.files.total.countcount
sharepoint.sites.inactive.files.total.countcount
sharepoint.sites.files.active.total.countcount
sharepoint.sites.pages.visited.total.countcount
sharepoint.sites.pages.viewed.total.countcount
sites#usageN/A
sites#sharepoint.sites.files.countcount
sites#sharepoint.sites.files.active.countcount
sites#sharepoint.sites.pages.visited.countcount
sites#sharepoint.sites.pages.viewed.countcount

To obtain this new metric format, include --use-new-perfdata in the EXTRAOPTIONS service macro.

Prerequisites​

Refer to the official documentation of Office365 Management or follow the link in the 'More information' section to create an Office365 account and get help about the management features.

Register an application​

The Office365 Management API use Azure AD to authenticate against Office365. To access the Office365 Management API, you need to register your application in Azure AD. Application is here used by Microsoft as a conceptual term, referring not only to the application software, but also to the Azure AD registration and role in authentication/authorization "conversations" at runtime. (https://docs.microsoft.com/en-us/azure/active-directory/develop/app-objects-and-service-principals)

Office365 Management API authorization​

To collect data from Sharepoint Online, you need to specify the following authorization:

  • Microsoft Graph :
    • Reports.Read.All (Type : Application)
    • User.Read (Type : Delegated)
  • Office365 Management APIs :
    • ServiceHealth.Read (Type : Application)
    • ActivityFeed.Read (Type : Application)

More information​

You can access to the official documentation to register your application, get your client ID, secret ID and your tenant ID by following this link: https://docs.microsoft.com/en-us/office/office-365-management-api/get-started-with-office-365-management-apis

Installing the monitoring connector​

Pack​

  1. If the platform uses an online license, you can skip the package installation instruction below as it is not required to have the connector displayed within the Configuration > Monitoring Connector Manager menu. If the platform uses an offline license, install the package on the central server with the command corresponding to the operating system's package manager:
dnf install centreon-pack-cloud-microsoft-office365-sharepoint
  1. Whatever the license type (online or offline), install the Office365 SharePoint connector through the Configuration > Monitoring Connector Manager menu.

Plugin​

Since Centreon 22.04, you can benefit from the 'Automatic plugin installation' feature. When this feature is enabled, you can skip the installation part below.

You still have to manually install the plugin on the poller(s) when:

  • Automatic plugin installation is turned off
  • You want to run a discovery job from a poller that doesn't monitor any resource of this kind yet

More information in the Installing the plugin section.

Use the commands below according to your operating system's package manager:

dnf install centreon-plugin-Cloud-Microsoft-Office365-Sharepoint-Api

Using the monitoring connector​

Using a host template provided by the connector​

  1. Log into Centreon and add a new host through Configuration > Hosts.
  2. Fill in the Name, Alias & IP Address/DNS fields according to your resource's settings.
  3. Apply the Cloud-Microsoft-Office365-Sharepoint-Api-custom template to the host. A list of macros appears. Macros allow you to define how the connector will connect to the resource, and to customize the connector's behavior.
  4. Fill in the macros you want. Some macros are mandatory.
MacroDescriptionDefault valueMandatory
OFFICE365CLIENTIDSet Office 365 client IDX
OFFICE365CLIENTSECRETSet Office 365 client secretX
OFFICE365TENANTSet Office 365 tenant IDX
OFFICE365EXTRAOPTIONSAny extra option you may want to add to every command (a --verbose flag for example). All options are listed here.
  1. Deploy the configuration. The host appears in the list of hosts, and on the Resources Status page. The command that is sent by the connector is displayed in the details panel of the host: it shows the values of the macros.

Using a service template provided by the connector​

  1. If you have used a host template and checked Create Services linked to the Template too, the services linked to the template have been created automatically, using the corresponding service templates. Otherwise, create manually the services you want and apply a service template to them.
  2. Fill in the macros you want (e.g. to change the thresholds for the alerts). Some macros are mandatory (see the table below).
MacroDescriptionDefault valueMandatory
UNITSUnit of thresholds ('%', 'count')%
FILTERCOUNTERSOnly display some counters (regexp can be used). Example to hide per user counters: --filter-counters='active-sites| total'active-sites|total
FILTERURLFilter sites
FILTERIDFilter sites
WARNINGACTIVEFILECOUNTThresholds
CRITICALACTIVEFILECOUNTThresholds
WARNINGACTIVESITESThresholds
CRITICALACTIVESITESThresholds
WARNINGFILECOUNTThresholds
CRITICALFILECOUNTThresholds
WARNINGPAGEVIEWCOUNTThresholds
CRITICALPAGEVIEWCOUNTThresholds
WARNINGTOTALACTIVEFILECOUNTThresholds
CRITICALTOTALACTIVEFILECOUNTThresholds
WARNINGTOTALFILECOUNTACTIVEThresholds
CRITICALTOTALFILECOUNTACTIVEThresholds
WARNINGTOTALFILECOUNTINACTIVEThresholds
CRITICALTOTALFILECOUNTINACTIVEThresholds
WARNINGTOTALPAGEVIEWCOUNTThresholds
CRITICALTOTALPAGEVIEWCOUNTThresholds
WARNINGTOTALUSAGEACTIVEThresholds
CRITICALTOTALUSAGEACTIVEThresholds
WARNINGTOTALUSAGEINACTIVEThresholds
CRITICALTOTALUSAGEINACTIVEThresholds
WARNINGTOTALVISITEDPAGECOUNTThresholds
CRITICALTOTALVISITEDPAGECOUNTThresholds
WARNINGUSAGEThresholds
CRITICALUSAGEThresholds
WARNINGVISITEDPAGECOUNTThresholds
CRITICALVISITEDPAGECOUNTThresholds
EXTRAOPTIONSAny extra option you may want to add to the command (a --verbose flag for example). All options are listed here.
  1. Deploy the configuration. The service appears in the list of services, and on the Resources Status page. The command that is sent by the connector is displayed in the details panel of the service: it shows the values of the macros.

How to check in the CLI that the configuration is OK and what are the main options for?​

Once the plugin is installed, log into your Centreon poller's CLI using the centreon-engine user account (su - centreon-engine). Test that the connector is able to monitor a resource using a command like this one (replace the sample values by yours):

/usr/lib/centreon/plugins/centreon_office365_sharepoint_api.pl \
	--plugin=cloud::microsoft::office365::sharepoint::plugin \
	--mode=site-usage \
	--tenant='' \
	--client-id='' \
	--client-secret=''  \
	--filter-url='' \
	--filter-id='' \
	--warning-usage='' \
	--critical-usage='' \
	--warning-file-count='' \
	--critical-file-count='' \
	--warning-active-file-count='' \
	--critical-active-file-count='' \
	--warning-visited-page-count='' \
	--critical-visited-page-count='' \
	--warning-page-view-count='' \
	--critical-page-view-count='' \
	--warning-total-usage-active='' \
	--critical-total-usage-active='' \
	--warning-total-usage-inactive='' \
	--critical-total-usage-inactive='' \
	--warning-total-file-count-active='' \
	--critical-total-file-count-active='' \
	--warning-total-file-count-inactive='' \
	--critical-total-file-count-inactive='' \
	--warning-total-active-file-count='' \
	--critical-total-active-file-count='' \
	--warning-total-visited-page-count='' \
	--critical-total-visited-page-count='' \
	--warning-total-page-view-count='' \
	--critical-total-page-view-count='' \
	--warning-active-sites='' \
	--critical-active-sites='' \
	--units=% \
	--filter-counters='active-sites|total'

The expected command output is shown below:

OK: Usage (active sites): 27 27 Usage (inactive sites): 44 44 File Count (active sites): 12 File Count (inactive sites): 12 Active File Count (active sites): 42 Visited Page Count (active sites): 52 Page View Count (active sites): 7 All sites usage are ok | 'active-sites'=22;;;;'sharepoint.sites.active.usage.total.bytes'=27B;;;0;'sharepoint.sites.inactive.usage.total.bytes'=44B;;;0;'sharepoint.sites.active.files.total.count'=12;;;0;'sharepoint.sites.inactive.files.total.count'=12;;;0;'sharepoint.sites.files.active.total.count'=42;;;0;'sharepoint.sites.pages.visited.total.count'=52;;;0;'sharepoint.sites.pages.viewed.total.count'=7;;;0;'*sites*#usage'=;;;;'*sites*#sharepoint.sites.files.count'=;;;0;'*sites*#sharepoint.sites.files.active.count'=;;;0;'*sites*#sharepoint.sites.pages.visited.count'=;;;0;'*sites*#sharepoint.sites.pages.viewed.count'=;;;0;

Troubleshooting​

Please find the troubleshooting documentation for Centreon Plugins typical issues.

Available modes​

In most cases, a mode corresponds to a service template. The mode appears in the execution command for the connector. In the Centreon interface, you don't need to specify a mode explicitly: its use is implied when you apply a service template. However, you will need to specify the correct mode for the template if you want to test the execution command for the connector in your terminal.

All available modes can be displayed by adding the --list-mode parameter to the command:

/usr/lib/centreon/plugins/centreon_office365_sharepoint_api.pl \
	--plugin=cloud::microsoft::office365::sharepoint::plugin \
	--list-mode

The plugin brings the following modes:

ModeLinked service template
list-sites [code]Not used in this Monitoring Connector
site-usage [code]Cloud-Microsoft-Office365-Sharepoint-Site-Usage-Api-custom
users-activity [code]Cloud-Microsoft-Office365-Sharepoint-Users-Activity-Api-custom

Available options​

Generic options​

All generic options are listed here:

OptionDescription
--modeDefine the mode in which you want the plugin to be executed (see--list-mode).
--dyn-modeSpecify a mode with the module's path (advanced).
--list-modeList all available modes.
--mode-versionCheck minimal version of mode. If not, unknown error.
--versionReturn the version of the plugin.
--custommodeWhen a plugin offers several ways (CLI, library, etc.) to get information the desired one must be defined with this option.
--list-custommodeList all available custom modes.
--multipleMultiple custom mode objects. This may be required by some specific modes (advanced).
--pass-managerDefine the password manager you want to use. Supported managers are: environment, file, keepass, hashicorpvault and teampass.
--verboseDisplay extended status information (long output).
--debugDisplay debug messages.
--filter-perfdataFilter perfdata that match the regexp. Example: adding --filter-perfdata='avg' will remove all metrics that do not contain 'avg' from performance data.
--filter-perfdata-advFilter perfdata based on a "if" condition using the following variables: label, value, unit, warning, critical, min, max. Variables must be written either %{variable} or %(variable). Example: adding --filter-perfdata-adv='not (%(value) == 0 and %(max) eq "")' will remove all metrics whose value equals 0 and that don't have a maximum value.
--explode-perfdata-maxCreate a new metric for each metric that comes with a maximum limit. The new metric will be named identically with a '_max' suffix). Example: it will split 'used_prct'=26.93%;0:80;0:90;0;100 into 'used_prct'=26.93%;0:80;0:90;0;100 'used_prct_max'=100%;;;;
--change-perfdata --extend-perfdataChange or extend perfdata. Syntax: --extend-perfdata=searchlabel,newlabel,target[,[newuom],[min],[m ax]] Common examples: Convert storage free perfdata into used: --change-perfdata='free,used,invert()' Convert storage free perfdata into used: --change-perfdata='used,free,invert()' Scale traffic values automatically: --change-perfdata='traffic,,scale(auto)' Scale traffic values in Mbps: --change-perfdata='traffic_in,,scale(Mbps),mbps' Change traffic values in percent: --change-perfdata='traffic_in,,percent()'
--extend-perfdata-groupAdd new aggregated metrics (min, max, average or sum) for groups of metrics defined by a regex match on the metrics' names. Syntax: --extend-perfdata-group=regex,namesofnewmetrics,calculation[,[ne wuom],[min],[max]] regex: regular expression namesofnewmetrics: how the new metrics' names are composed (can use $1, $2... for groups defined by () in regex). calculation: how the values of the new metrics should be calculated newuom (optional): unit of measure for the new metrics min (optional): lowest value the metrics can reach max (optional): highest value the metrics can reach Common examples: Sum wrong packets from all interfaces (with interface need --units-errors=absolute): --extend-perfdata-group=',packets_wrong,sum(packets_(discard |error)_(in|out))' Sum traffic by interface: --extend-perfdata-group='traffic_in_(.*),traffic_$1,sum(traf fic_(in|out)_$1)'
--change-short-output --change-long-outputModify the short/long output that is returned by the plugin. Syntax: --change-short-output=patternreplacementmodifier Most commonly used modifiers are i (case insensitive) and g (replace all occurrences). Example: adding --change-short-output='OKUpgi' will replace all occurrences of 'OK', 'ok', 'Ok' or 'oK' with 'Up'
--change-exitReplace an exit code with one of your choice. Example: adding --change-exit=unknown=critical will result in a CRITICAL state instead of an UNKNOWN state.
--range-perfdataRewrite the ranges displayed in the perfdata. Accepted values: 0: nothing is changed. 1: if the lower value of the range is equal to 0, it is removed. 2: remove the thresholds from the perfdata.
--filter-uomMask the units when they don't match the given regular expression.
--opt-exitReplace the exit code in case of an execution error (i.e. wrong option provided, SSH connection refused, timeout, etc). Default: unknown.
--output-ignore-perfdataRemove all the metrics from the service. The service will still have a status and an output.
--output-ignore-labelRemove the status label ("OK:", "WARNING:", "UNKNOWN:", CRITICAL:") from the beginning of the output. Example: 'OK: Ram Total:...' will become 'Ram Total:...'
--output-xmlReturn the output in XML format (to send to an XML API).
--output-jsonReturn the output in JSON format (to send to a JSON API).
--output-openmetricsReturn the output in OpenMetrics format (to send to a tool expecting this format).
--output-fileWrite output in file (can be combined with json, xml and openmetrics options). E.g.: --output-file=/tmp/output.txt will write the output in /tmp/output.txt.
--disco-formatApplies only to modes beginning with 'list-'. Returns the list of available macros to configure a service discovery rule (formatted in XML).
--disco-showApplies only to modes beginning with 'list-'. Returns the list of discovered objects (formatted in XML) for service discovery.
--float-precisionDefine the float precision for thresholds (default: 8).
--source-encodingDefine the character encoding of the response sent by the monitored resource Default: 'UTF-8'. Microsoft Office 365 Graph API To connect to the Office 365 Graph API, you must register an application. Follow the 'How-to guide' at https://docs.microsoft.com/en-us/graph/auth-register-app-v2?view=graph-r est-1.0 This custom mode is using the 'OAuth 2.0 Client Credentials Grant Flow'.
--tenantSet Office 365 tenant ID.
--client-idSet Office 365 client ID.
--client-secretSet Office 365 client secret.
--login-endpointSet Office 365 login endpoint URL (default: 'https://login.microsoftonline.com')
--graph-endpointSet Office 365 graph endpoint URL (default: 'https://graph.microsoft.com')
--timeoutSet timeout in seconds (default: 10).
--http-peer-addrSet the address you want to connect to. Useful if hostname is only a vhost, to avoid IP resolution.
--proxyurlProxy URL. Example: http://my.proxy:3128
--proxypacProxy pac file (can be a URL or a local file).
--insecureAccept insecure SSL connections.
--http-backendPerl library to use for HTTP transactions. Possible values are: lwp (default) and curl.
--ssl-optSet SSL Options (--ssl-opt="SSL_version => TLSv1" --ssl-opt="SSL_verify_mode => SSL_VERIFY_NONE").
--curl-optSet CURL Options (--curl-opt="CURLOPT_SSL_VERIFYPEER => 0" --curl-opt="CURLOPT_SSLVERSION => CURL_SSLVERSION_TLSv1_1" ).
--memcachedMemcached server to use (only one server).
--redis-serverRedis server to use (only one server). Syntax: address[:port]
--redis-attributeSet Redis Options (--redis-attribute="cnx_timeout=5").
--redis-dbSet Redis database index.
--failback-fileFailback on a local file if Redis connection fails.
--memexpirationTime to keep data in seconds (default: 86400).
--statefile-dirDefine the cache directory (default: '/var/lib/centreon/centplugins').
--statefile-suffixDefine a suffix to customize the statefile name (default: '').
--statefile-concat-cwdIf used with the '--statefile-dir' option, the latter's value will be used as a sub-directory of the current working directory. Useful on Windows when the plugin is compiled, as the file system and permissions are different from Linux.
--statefile-formatDefine the format used to store the cache. Available formats: 'dumper', 'storable', 'json' (default).
--statefile-keyDefine the key to encrypt/decrypt the cache.
--statefile-cipherDefine the cipher algorithm to encrypt the cache (default: 'AES').

Modes options​

All available options for each service template are listed below:

OptionDescription
--filter-countersOnly display some counters (regexp can be used). Example to hide per user counters: --filter-counters='active-sites|total' (default: 'active-sites|total')
--filter-*Filter sites. Can be: 'url', 'id' (can be a regexp).
--use-pseudonymizeUse pseudonymize user-level information.
--warning-* --critical-*Thresholds. Can be: 'active-sites', 'total-usage-active' (count), 'total-usage-inactive' (count), 'total-file-count-active' (count), 'total-file-count-inactive' (count), 'total-active-file-count' (count), 'total-visited-page-count' (count), 'total-page-view-count' (count), 'usage' (count), 'file-count' (count), 'active-file-count' (count), 'visited-page-count' (count), 'page-view-count' (count).
--unitsUnit of thresholds (default: '%') ('%', 'count').

All available options for a given mode can be displayed by adding the --help parameter to the command:

/usr/lib/centreon/plugins/centreon_office365_sharepoint_api.pl \
	--plugin=cloud::microsoft::office365::sharepoint::plugin \
	--mode=site-usage \
	--help