====== Advanced Reporting with Web Services ======
----

**Xcalibur W** provides a Web Service in **REST** format for data collection over the network. The Web Service enables the use of requests that can be used by third-party software applications, including Microsoft Excel.

{{ advanced_reporting:verifying_proper_installation.png }}

When exporting a file using Custom Exports, the corresponding Web Service request is automatically displayed in the URL field. The request can be used "as-is" or modified.

|{{:warning.png }} Web Services must be properly configured on the IIS Server to be functional within **Xcalibur W**. Refer to [[installation_guide:server_software_installation:manual_installation:setting_up_webservices|Setting Up WebServices]] for more details|

The Web Service syntax is described below.

> **https: / /<manager-ip> : <webservice-port> /ws/ <entity> . <export-format> ?projections= <projections-list> &orders= <orders-list> &groups= <groups-list> & <criteria-list>**

^ ^ ^
|manager-ip|**Xcalibur W** IP adress or DNS name|
|webservice-port|Port used by the web service in **Xcalibur W** Server|
|entity|Request's entry point|
|export-format|Export format of the request|
|projections-list|Projections list, separated by commas|
|orders-list|order-by list, separated by commas|
|groups-list|group-by list, separated by commas|
|criteria-list|criteria list, where a criteria = an URL parameter|


|{{:tip.png }} Requests can be directly modified in the URL field. See below for an example changing the value of the filter for the Last Pulse date.|

Example :

  * **Original**: the output list will only feature the Devices that __have not contacted__ **Xcalibur W** since 14/06/2013 (Last Pulse Date):

> https: / /wpms1.chippc.com:444/ws/agents.csv?projections=IsOnline,MachineName,Networks.MacAddress,Inventory.Computer.Model,Inventory.OperatingSystem.OsName,DeviceAgentVersion,Networks.IpAddress,Networks.NetworkAddress,WriteFilter,IsInPersistance,LastPulse&LastPulse=LessThan(**14/06/2013** 21:54:45)&EnrollementState=1

  * **Modified**, the output list will only feature the Devices that __have contacted__ **Xcalibur W** since 14/06/2013 (Last Pulse Date):

> https: / /wpms1.chippc.com:444/ws/agents.csv?projections=IsOnline,MachineName,Networks.MacAddress,Inventory.Computer.Model,Inventory.OperatingSystem.OsName,DeviceAgentVersion,Networks.IpAddress,Networks.NetworkAddress,WriteFilter,IsInPersistance,LastPulse&LastPulse=GreaterThan(**15/06/2013** 21:54:45)&EnrollementState=1