Hi,

I am unable to connect and below is the error message and my code .

my code. import requests import pyodata

urllink = 'http://citrixdc.bluepedia.com/Citrix/Monitor/OData/v3/Data/' client = pyodata.Client(urllink,requests.Session()

and below is the error message

Traceback (most recent call last): File "C:/Users/administrator/PycharmProjects/citrixodata/citrixodata.py", line 5, in client = pyodata.Client(urllink,requests.Session()) File "C:\Users\administrator\PycharmProjects\citrixodata\venv\lib\site-packages\pyodata\client.py", line 37, in new 'Metadata request failed, status code: {}, body:\n{}'.format(resp.status_code, resp.content), resp) pyodata.exceptions.HttpError: Metadata request failed, status code: 401, body: b''

and the url preview is as below.

-

atom:titleDefault</atom:title>

-

atom:titleApplicationActivitySummaries</atom:title>

-

atom:titleApplications</atom:title>

-

atom:titleApplicationInstances</atom:title>

-

atom:titleSessions</atom:title>

-

atom:titleApplicationErrors</atom:title>

-

atom:titleMachines</atom:title>

-

atom:titleApplicationFaults</atom:title>

-

atom:titleCatalogs</atom:title>

-

atom:titleLoadIndexes</atom:title>

-

atom:titleDesktopGroups</atom:title>

-

atom:titleResourceUtilization</atom:title>

-

atom:titleResourceUtilizationSummary</atom:title>

-

atom:titleHypervisors</atom:title>

-

atom:titleMachineFailureLogs</atom:title>

-

atom:titleMachineHotfixLogs</atom:title>

-

atom:titleHotfixes</atom:title>

-

atom:titleMachineMetric</atom:title>

-

atom:titleMachineMetricSummary</atom:title>

-

atom:titleProcesses</atom:title>

-

atom:titleProcessUtilization</atom:title>

-

atom:titleProcessUtilizationDaySummary</atom:title>

-

atom:titleProcessUtilizationHourSummary</atom:title>

-

atom:titleProcessUtilizationMinuteSummary</atom:title>

-

atom:titleConnectionFailureLogs</atom:title>

-

atom:titleConnections</atom:title>

-

atom:titleConnectionFailureCategories</atom:title>

-

atom:titleSessionMetrics</atom:title>

-

atom:titleUsers</atom:title>

-

atom:titleDesktopOSDesktopSummaries</atom:title>

-

atom:titleFailureLogSummaries</atom:title>

-

atom:titleLoadIndexSummaries</atom:title>

-

atom:titleNotificationActionEmails</atom:title>

-

atom:titleNotificationRuleActions</atom:title>

-

atom:titleNotificationRules</atom:title>

-

atom:titleNotificationRuleGroups</atom:title>

-

atom:titleNotificationRuleParameters</atom:title>

-

atom:titleNotificationRuleParameterChangeLogs</atom:title>

-

atom:titleNotificationRuleTargets</atom:title>

-

atom:titleNotificationRuleTargetValues</atom:title>

-

atom:titleNotificationEmailAddresses</atom:title>

-

atom:titleNotificationEmailServerConfigurations</atom:title>

-

atom:titleNotifications</atom:title>

-

atom:titleNotificationsLogs</atom:title>

-

atom:titleNotificationTargets</atom:title>

-

atom:titleNotificationTargetValues</atom:title>

-

atom:titleNotificationSnmpConfigurations</atom:title>

-

atom:titleServerOSDesktopSummaries</atom:title>

-

atom:titleSessionActivitySummaries</atom:title>

-

atom:titleTaskLogs</atom:title>

May 01 '19 10:05 chinnaphani

i am getting error like this.

pyodata.exceptions.HttpError: Metadata request failed, status code: 401, body:

May 02 '19 02:05 chinnaphani

If you try to open the URL in your browser, you will see some advertising suggesting you to buy that domain. Are you sure you use the right domain?

May 02 '19 07:05 jfilak

its a internal sever, not public server

May 02 '19 08:05 chinnaphani

Could you please run the following command and send me the output:

curl -vvv 'http://citrixdc.bluepedia.com/Citrix/Monitor/OData/v3/Data/$metadata'

May 02 '19 08:05 jfilak

Sorry for delay message.

I am out of station,

here is the output of curl -vvv

C:\Users\administrator\Downloads\curl-7.64.1_1-win64-mingw\curl-7.64.1-win64-mingw\bin>curl.exe -vvv http://citrixdc.bluepedia.com/Citrix/Monitor/OData/v3/Data/$metadata

Trying fe80::1800:b92e:d77d:4c78...
TCP_NODELAY set
Connected to citrixdc.bluepedia.com (fe80::1800:b92e:d77d:4c78) port 80 (#0)

GET /Citrix/Monitor/OData/v3/Data/$metadata HTTP/1.1 Host: citrixdc.bluepedia.com User-Agent: curl/7.64.1 Accept: /

< HTTP/1.1 401 Unauthorized < Content-Length: 0 < Server: Microsoft-HTTPAPI/2.0 < WWW-Authenticate: Negotiate < WWW-Authenticate: NTLM < Date: Tue, 07 May 2019 09:44:15 GMT <

Connection #0 to host citrixdc.bluepedia.com left intact
Closing connection 0

May 07 '19 09:05 chinnaphani

here is the my code.

`import requests import pyodata

url = "http://citrixdc.bluepedia.com/Citrix/Monitor/OData/v3/Data/"

mys = requests.Session()

import pdb; pdb.set_trace()

mys.auth = ("Bluepedia\administrator", 'Vihaan@2016') import pdb; pdb.set_trace() client = pyodata.Client(url,requests.Session())`

May 07 '19 09:05 chinnaphani

We are making great progress, you need to authorize your request.

Start curl with additional parameter '-u YOURUSE' and curl should ask you for password and eventually download metadata.

May 07 '19 09:05 jfilak

In your python code, you need to do this: https://github.com/SAP/python-pyodata/blob/master/USAGE.md#get-the-service-proxy-client-for-an-odata-service-requiring-authentication

May 07 '19 09:05 jfilak

Oh, sorry, didn't notice the code comment.

May 07 '19 09:05 jfilak

here is the result with -u

C:\Users\administrator\Downloads\curl-7.64.1_1-win64-mingw\curl-7.64.1-win64-mingw\bin>curl.exe -vvv http://citrixdc.bluepedia.com/Citrix/Monitor/OData/v3/Data/$metadata -u bluepedia\administrator:Vihaan@2016

Trying fe80::1800:b92e:d77d:4c78...
TCP_NODELAY set
Connected to citrixdc.bluepedia.com (fe80::1800:b92e:d77d:4c78) port 80 (#0)
Server auth using Basic with user 'bluepedia\administrator'

GET /Citrix/Monitor/OData/v3/Data/$metadata HTTP/1.1 Host: citrixdc.bluepedia.com Authorization: Basic Ymx1ZXBlZGlhXGFkbWluaXN0cmF0b3I6VmloYWFuQDIwMTY= User-Agent: curl/7.64.1 Accept: /

< HTTP/1.1 401 Unauthorized < Content-Length: 0 < Server: Microsoft-HTTPAPI/2.0 < WWW-Authenticate: Negotiate < WWW-Authenticate: NTLM < Date: Tue, 07 May 2019 10:05:42 GMT <

Connection #0 to host citrixdc.bluepedia.com left intact
Closing connection 0

May 07 '19 10:05 chinnaphani

Hi any update for me plz

May 08 '19 08:05 chinnaphani

Unfortunately, you are still not authorized and I am not sure how can I help you getting credentials for this particular service. Please, reach out to the service vendor for further assistance and get back to us when you manage to run the curl command with the HTTP status code 200.

May 08 '19 09:05 jfilak

Hi,

when i use the url in Internet Explorer i am getting the page opened and it showing as below.

Default
Catalogs
Machines
LoadIndexes
DesktopGroups
Hypervisors
MachineFailureLogs

also below is vendor product documentation, request you to help me on this plzzzzzz.

https://developer-docs.citrix.com/projects/monitor-service-odata-api/en/latest/

May 21 '19 11:05 chinnaphani

@chinnaphani I cannot do more than reporting the issue to the API provider: https://github.com/citrix/monitoring-api/issues/10

This time, I have reported the issue on behalves of you but I would like make clear that I might not have enough free time to do so next time.

May 21 '19 12:05 filak-sap

Hi,

Sorry to trouble you again, but i got some good progress and i get exit code 0, when i process below code. hope it connected to odata url, but i am getting EntitySet not defined in.

`import requests import requests.auth from requests_ntlm import HttpNtlmAuth import pyodata

username = "userid" password = 'password'

directorURL = 'http://servername/Citrix/Monitor/OData/v2/data'

directorSession = requests.session() directorSession.auth= HttpNtlmAuth(username,password) directorReqData = pyodata.Client(directorURL,directorSession)`

C:\Users\pxksa\PycharmProjects\testodata\venv\Scripts\python.exe C:/Users/pxksa/PycharmProjects/testodata/direct.py

Process finished with exit code 0

now the problem is, it says the entity is not found, as below and the code is :

test = directorReqData.entity_sets.Application.get_entity(1).execute() print(test.Name)

Traceback (most recent call last): File "C:\Users\pxksa\PycharmProjects\testodata\venv\lib\site-packages\pyodata\v2\service.py", line 1148, in getattr return self._entity_sets[name] KeyError: 'Application'

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "C:/Users/pxksa/PycharmProjects/testodata/direct.py", line 17, in test = directorReqData.entity_sets.Application.get_entity(1).execute() File "C:\Users\pxksa\PycharmProjects\testodata\venv\lib\site-packages\pyodata\v2\service.py", line 1151, in getattr 'EntitySet {0} not defined in {1}.'.format(name, ','.join(list(self._entity_sets.keys())))) AttributeError: EntitySet Application not defined in

Jun 10 '19 12:06 chinnaphani

here is metadata file.

- <service xml:base="http://server.example.com/Citrix/Monitor/OData/v2/Data/" xmlns="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom">
- <workspace>
  <atom:title>Default</atom:title> 
- <collection href="ApplicationActivitySummaries">
  <atom:title>ApplicationActivitySummaries</atom:title> 
  </collection>
- <collection href="Applications">
  <atom:title>Applications</atom:title> 
  </collection>
- <collection href="ApplicationInstances">
  <atom:title>ApplicationInstances</atom:title> 
  </collection>
- <collection href="Sessions">
  <atom:title>Sessions</atom:title> 
  </collection>
- <collection href="Connections">
  <atom:title>Connections</atom:title> 
  </collection>
- <collection href="ConnectionFailureCategories">
  <atom:title>ConnectionFailureCategories</atom:title> 
  </collection>
- <collection href="Machines">
  <atom:title>Machines</atom:title> 
  </collection>
- <collection href="Catalogs">
  <atom:title>Catalogs</atom:title> 
  </collection>
- <collection href="LoadIndexes">
  <atom:title>LoadIndexes</atom:title> 
  </collection>
- <collection href="DesktopGroups">
  <atom:title>DesktopGroups</atom:title> 
  </collection>
- <collection href="Hypervisors">
  <atom:title>Hypervisors</atom:title> 
  </collection>
- <collection href="MachineFailureLogs">
  <atom:title>MachineFailureLogs</atom:title> 
  </collection>
- <collection href="MachineHotfixLogs">
  <atom:title>MachineHotfixLogs</atom:title> 
  </collection>
- <collection href="Hotfixes">
  <atom:title>Hotfixes</atom:title> 
  </collection>
- <collection href="Users">
  <atom:title>Users</atom:title> 
  </collection>
- <collection href="ConnectionFailureLogs">
  <atom:title>ConnectionFailureLogs</atom:title> 
  </collection>
- <collection href="FailureLogSummaries">
  <atom:title>FailureLogSummaries</atom:title> 
  </collection>
- <collection href="LoadIndexSummaries">
  <atom:title>LoadIndexSummaries</atom:title> 
  </collection>
- <collection href="SessionActivitySummaries">
  <atom:title>SessionActivitySummaries</atom:title> 
  </collection>
- <collection href="TaskLogs">
  <atom:title>TaskLogs</atom:title> 
  </collection>
  </workspace>
  </service>```

Jun 10 '19 13:06 chinnaphani

I am terribly sorry but pyodata does not support queriable $metadata as described at: https://www.odata.org/blog/queryable-odata-metadata/

but we need the corresponding service metadata document: https://www.odata.org/documentation/odata-version-2-0/overview/#ServiceMetadataDocument

If you don't have such a document, we would need to implement the support for the queriable format which will be too much time expensive for us.

Jun 11 '19 08:06 filak-sap

here is the postmen data and $metadata, does it helps :(

now a I am getting below error. if i run below code.

``applist = directorReqData.entity_sets.Applications.get_entities().select('Name').execute()

for app in applist: print(app.Name)``

Traceback (most recent call last): File "C:/Users/pxksa/PycharmProjects/testodata/direct.py", line 27, in applist = directorReqData.entity_sets.Applications.get_entities().select('Name').execute() File "C:\Users\pxksa\PycharmProjects\testodata\venv\lib\site-packages\pyodata\v2\service.py", line 306, in execute return self._handler(response) File "C:\Users\pxksa\PycharmProjects\testodata\venv\lib\site-packages\pyodata\v2\service.py", line 1083, in get_entities_handler entities = content['d']['results'] KeyError: 'd'

postman data:

- <service xml:base="http://server.example.com/Citrix/Monitor/OData/v2/Data/" xmlns="http://www.w3.org/2007/app" xmlns:atom="http://www.w3.org/2005/Atom">
- <workspace>
  <atom:title>Default</atom:title> 
- <collection href="ApplicationActivitySummaries">
  <atom:title>ApplicationActivitySummaries</atom:title> 
  </collection>
- <collection href="Applications">
  <atom:title>Applications</atom:title> 
  </collection>
- <collection href="ApplicationInstances">
  <atom:title>ApplicationInstances</atom:title> 
  </collection>
- <collection href="Sessions">
  <atom:title>Sessions</atom:title> 
  </collection>
- <collection href="Connections">
  <atom:title>Connections</atom:title> 
  </collection>
- <collection href="ConnectionFailureCategories">
  <atom:title>ConnectionFailureCategories</atom:title> 
  </collection>
- <collection href="Machines">
  <atom:title>Machines</atom:title> 
  </collection>
- <collection href="Catalogs">
  <atom:title>Catalogs</atom:title> 
  </collection>
- <collection href="LoadIndexes">
  <atom:title>LoadIndexes</atom:title> 
  </collection>
- <collection href="DesktopGroups">
  <atom:title>DesktopGroups</atom:title> 
  </collection>
- <collection href="Hypervisors">
  <atom:title>Hypervisors</atom:title> 
  </collection>
- <collection href="MachineFailureLogs">
  <atom:title>MachineFailureLogs</atom:title> 
  </collection>
- <collection href="MachineHotfixLogs">
  <atom:title>MachineHotfixLogs</atom:title> 
  </collection>
- <collection href="Hotfixes">
  <atom:title>Hotfixes</atom:title> 
  </collection>
- <collection href="Users">
  <atom:title>Users</atom:title> 
  </collection>
- <collection href="ConnectionFailureLogs">
  <atom:title>ConnectionFailureLogs</atom:title> 
  </collection>
- <collection href="FailureLogSummaries">
  <atom:title>FailureLogSummaries</atom:title> 
  </collection>
- <collection href="LoadIndexSummaries">
  <atom:title>LoadIndexSummaries</atom:title> 
  </collection>
- <collection href="SessionActivitySummaries">
  <atom:title>SessionActivitySummaries</atom:title> 
  </collection>
- <collection href="TaskLogs">
  <atom:title>TaskLogs</atom:title> 
  </collection>
  </workspace>
  </service>````

Jun 11 '19 08:06 chinnaphani

here is the $metadata

- <edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
- <edmx:DataServices m:DataServiceVersion="1.0" m:MaxDataServiceVersion="3.0" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
- <Schema Namespace="Citrix.Monitor.Repository" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
- <EntityType Name="ApplicationInstanceSummary">
+ <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="SummaryDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ApplicationId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="DesktopGroupId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="PeakConcurrentInstanceCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="TotalUsageDuration" Type="Edm.Double" Nullable="false" /> 
  <Property Name="TotalLaunchesCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="StartingInstanceCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Granularity" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Application" Relationship="Citrix.Monitor.Repository.ApplicationInstanceSummary_Application" ToRole="Application" FromRole="ApplicationInstanceSummary" /> 
  <NavigationProperty Name="DesktopGroup" Relationship="Citrix.Monitor.Repository.ApplicationInstanceSummary_DesktopGroup" ToRole="DesktopGroup" FromRole="ApplicationInstanceSummary" /> 
  </EntityType>
- <EntityType Name="Application">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="Name" Type="Edm.String" /> 
  <Property Name="PublishedName" Type="Edm.String" /> 
  <Property Name="ApplicationType" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Enabled" Type="Edm.Boolean" Nullable="false" /> 
  <Property Name="AdminFolder" Type="Edm.String" /> 
  <Property Name="LifecycleState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="ApplicationInstances" Relationship="Citrix.Monitor.Repository.Application_ApplicationInstances_ApplicationInstance_Application" ToRole="ApplicationInstance_Application" FromRole="Application_ApplicationInstances" /> 
  <NavigationProperty Name="DesktopGroups" Relationship="Citrix.Monitor.Repository.Application_DesktopGroups_DesktopGroup_Applications" ToRole="DesktopGroup_Applications" FromRole="Application_DesktopGroups" /> 
  </EntityType>
+ <EntityType Name="ApplicationInstance">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="ApplicationId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="SessionKey" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="StartDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="EndDate" Type="Edm.DateTime" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Application" Relationship="Citrix.Monitor.Repository.Application_ApplicationInstances_ApplicationInstance_Application" ToRole="Application_ApplicationInstances" FromRole="ApplicationInstance_Application" /> 
  <NavigationProperty Name="Session" Relationship="Citrix.Monitor.Repository.ApplicationInstance_Session_Session_ApplicationInstances" ToRole="Session_ApplicationInstances" FromRole="ApplicationInstance_Session" /> 
  </EntityType>
+ <EntityType Name="Session">
- <Key>
  <PropertyRef Name="SessionKey" /> 
  </Key>
  <Property Name="SessionKey" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="StartDate" Type="Edm.DateTime" /> 
  <Property Name="LogOnDuration" Type="Edm.Int32" /> 
  <Property Name="EndDate" Type="Edm.DateTime" /> 
  <Property Name="ExitCode" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="FailureDate" Type="Edm.DateTime" /> 
  <Property Name="ConnectionState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="ConnectionStateChangeDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="LifecycleState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CurrentConnectionId" Type="Edm.Int64" /> 
  <Property Name="UserId" Type="Edm.Int64" /> 
  <Property Name="MachineId" Type="Edm.Guid" /> 
  <Property Name="SessionType" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="IsAnonymous" Type="Edm.Boolean" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="ApplicationInstances" Relationship="Citrix.Monitor.Repository.ApplicationInstance_Session_Session_ApplicationInstances" ToRole="ApplicationInstance_Session" FromRole="Session_ApplicationInstances" /> 
  <NavigationProperty Name="Connections" Relationship="Citrix.Monitor.Repository.Session_Connections_Connection_Session" ToRole="Connection_Session" FromRole="Session_Connections" /> 
  <NavigationProperty Name="CurrentConnection" Relationship="Citrix.Monitor.Repository.Session_CurrentConnection" ToRole="CurrentConnection" FromRole="Session" /> 
  <NavigationProperty Name="Failure" Relationship="Citrix.Monitor.Repository.Session_Failure" ToRole="Failure" FromRole="Session" /> 
  <NavigationProperty Name="Machine" Relationship="Citrix.Monitor.Repository.Session_Machine_Machine_Sessions" ToRole="Machine_Sessions" FromRole="Session_Machine" /> 
  <NavigationProperty Name="User" Relationship="Citrix.Monitor.Repository.Session_User_User_Sessions" ToRole="User_Sessions" FromRole="Session_User" /> 
  </EntityType>
+ <EntityType Name="Connection">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="ClientName" Type="Edm.String" /> 
  <Property Name="ClientAddress" Type="Edm.String" /> 
  <Property Name="ClientVersion" Type="Edm.String" /> 
  <Property Name="ConnectedViaHostName" Type="Edm.String" /> 
  <Property Name="ConnectedViaIPAddress" Type="Edm.String" /> 
  <Property Name="LaunchedViaHostName" Type="Edm.String" /> 
  <Property Name="LaunchedViaIPAddress" Type="Edm.String" /> 
  <Property Name="IsReconnect" Type="Edm.Boolean" Nullable="false" /> 
  <Property Name="IsSecureIca" Type="Edm.Boolean" /> 
  <Property Name="Protocol" Type="Edm.String" /> 
  <Property Name="LogOnStartDate" Type="Edm.DateTime" /> 
  <Property Name="LogOnEndDate" Type="Edm.DateTime" /> 
  <Property Name="BrokeringDuration" Type="Edm.Int64" /> 
  <Property Name="BrokeringDate" Type="Edm.DateTime" /> 
  <Property Name="DisconnectCode" Type="Edm.Int64" /> 
  <Property Name="DisconnectDate" Type="Edm.DateTime" /> 
  <Property Name="VMStartStartDate" Type="Edm.DateTime" /> 
  <Property Name="VMStartEndDate" Type="Edm.DateTime" /> 
  <Property Name="ClientSessionValidateDate" Type="Edm.DateTime" /> 
  <Property Name="ServerSessionValidateDate" Type="Edm.DateTime" /> 
  <Property Name="EstablishmentDate" Type="Edm.DateTime" /> 
  <Property Name="HdxStartDate" Type="Edm.DateTime" /> 
  <Property Name="HdxEndDate" Type="Edm.DateTime" /> 
  <Property Name="AuthenticationDuration" Type="Edm.Int32" /> 
  <Property Name="GpoStartDate" Type="Edm.DateTime" /> 
  <Property Name="GpoEndDate" Type="Edm.DateTime" /> 
  <Property Name="LogOnScriptsStartDate" Type="Edm.DateTime" /> 
  <Property Name="LogOnScriptsEndDate" Type="Edm.DateTime" /> 
  <Property Name="ProfileLoadStartDate" Type="Edm.DateTime" /> 
  <Property Name="ProfileLoadEndDate" Type="Edm.DateTime" /> 
  <Property Name="InteractiveStartDate" Type="Edm.DateTime" /> 
  <Property Name="InteractiveEndDate" Type="Edm.DateTime" /> 
  <Property Name="SessionKey" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Session" Relationship="Citrix.Monitor.Repository.Session_Connections_Connection_Session" ToRole="Session_Connections" FromRole="Connection_Session" /> 
  </EntityType>
+ <EntityType Name="ConnectionFailureCategory">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="ConnectionFailureEnumValue" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Category" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  </EntityType>
+ <EntityType Name="Machine">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="Sid" Type="Edm.String" /> 
  <Property Name="Name" Type="Edm.String" /> 
  <Property Name="DnsName" Type="Edm.String" /> 
  <Property Name="LifecycleState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="IPAddress" Type="Edm.String" /> 
  <Property Name="HostedMachineId" Type="Edm.String" /> 
  <Property Name="HostingServerName" Type="Edm.String" /> 
  <Property Name="HostedMachineName" Type="Edm.String" /> 
  <Property Name="IsAssigned" Type="Edm.Boolean" /> 
  <Property Name="IsInMaintenanceMode" Type="Edm.Boolean" /> 
  <Property Name="IsPendingUpdate" Type="Edm.Boolean" /> 
  <Property Name="AgentVersion" Type="Edm.String" /> 
  <Property Name="AssociatedUserFullNames" Type="Edm.String" /> 
  <Property Name="AssociatedUserNames" Type="Edm.String" /> 
  <Property Name="AssociatedUserUPNs" Type="Edm.String" /> 
  <Property Name="CurrentRegistrationState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="RegistrationStateChangeDate" Type="Edm.DateTime" /> 
  <Property Name="LastDeregisteredCode" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="LastDeregisteredDate" Type="Edm.DateTime" /> 
  <Property Name="CurrentPowerState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CurrentSessionCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="ControllerDnsName" Type="Edm.String" /> 
  <Property Name="PoweredOnDate" Type="Edm.DateTime" /> 
  <Property Name="PowerStateChangeDate" Type="Edm.DateTime" /> 
  <Property Name="FunctionalLevel" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="FailureDate" Type="Edm.DateTime" /> 
  <Property Name="WindowsConnectionSetting" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="IsPreparing" Type="Edm.Boolean" Nullable="false" /> 
  <Property Name="FaultState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="OSType" Type="Edm.String" /> 
  <Property Name="CurrentLoadIndexId" Type="Edm.Int64" /> 
  <Property Name="CatalogId" Type="Edm.Guid" /> 
  <Property Name="DesktopGroupId" Type="Edm.Guid" /> 
  <Property Name="HypervisorId" Type="Edm.Guid" /> 
  <Property Name="Hash" Type="Edm.String" /> 
  <Property Name="MachineRole" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Catalog" Relationship="Citrix.Monitor.Repository.Machine_Catalog_Catalog_Machines" ToRole="Catalog_Machines" FromRole="Machine_Catalog" /> 
  <NavigationProperty Name="CurrentLoadIndex" Relationship="Citrix.Monitor.Repository.Machine_CurrentLoadIndex" ToRole="CurrentLoadIndex" FromRole="Machine" /> 
  <NavigationProperty Name="DesktopGroup" Relationship="Citrix.Monitor.Repository.Machine_DesktopGroup_DesktopGroup_Machines" ToRole="DesktopGroup_Machines" FromRole="Machine_DesktopGroup" /> 
  <NavigationProperty Name="Hypervisor" Relationship="Citrix.Monitor.Repository.Machine_Hypervisor_Hypervisor_Machines" ToRole="Hypervisor_Machines" FromRole="Machine_Hypervisor" /> 
  <NavigationProperty Name="LoadIndex" Relationship="Citrix.Monitor.Repository.Machine_LoadIndex_LoadIndex_Machine" ToRole="LoadIndex_Machine" FromRole="Machine_LoadIndex" /> 
  <NavigationProperty Name="MachineFailures" Relationship="Citrix.Monitor.Repository.Machine_MachineFailures_MachineFailureLog_Machine" ToRole="MachineFailureLog_Machine" FromRole="Machine_MachineFailures" /> 
  <NavigationProperty Name="MachineHotfixLogs" Relationship="Citrix.Monitor.Repository.Machine_MachineHotfixLogs_MachineHotfixLog_Machine" ToRole="MachineHotfixLog_Machine" FromRole="Machine_MachineHotfixLogs" /> 
  <NavigationProperty Name="Sessions" Relationship="Citrix.Monitor.Repository.Session_Machine_Machine_Sessions" ToRole="Session_Machine" FromRole="Machine_Sessions" /> 
  </EntityType>
+ <EntityType Name="Catalog">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="Name" Type="Edm.String" /> 
  <Property Name="LifecycleState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="ProvisioningType" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="PersistentUserChanges" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="IsMachinePhysical" Type="Edm.Boolean" /> 
  <Property Name="AllocationType" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SessionSupport" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="ProvisioningSchemeId" Type="Edm.Guid" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Machines" Relationship="Citrix.Monitor.Repository.Machine_Catalog_Catalog_Machines" ToRole="Machine_Catalog" FromRole="Catalog_Machines" /> 
  </EntityType>
- <EntityType Name="LoadIndex">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="EffectiveLoadIndex" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Cpu" Type="Edm.Int32" /> 
  <Property Name="Memory" Type="Edm.Int32" /> 
  <Property Name="Disk" Type="Edm.Int32" /> 
  <Property Name="Network" Type="Edm.Int32" /> 
  <Property Name="SessionCount" Type="Edm.Int32" /> 
  <Property Name="MachineId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Machine" Relationship="Citrix.Monitor.Repository.Machine_LoadIndex_LoadIndex_Machine" ToRole="Machine_LoadIndex" FromRole="LoadIndex_Machine" /> 
  </EntityType>
- <EntityType Name="DesktopGroup">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="Name" Type="Edm.String" /> 
  <Property Name="IsRemotePC" Type="Edm.Boolean" /> 
  <Property Name="DesktopKind" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="LifecycleState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SessionSupport" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="DeliveryType" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Applications" Relationship="Citrix.Monitor.Repository.Application_DesktopGroups_DesktopGroup_Applications" ToRole="Application_DesktopGroups" FromRole="DesktopGroup_Applications" /> 
  <NavigationProperty Name="Machines" Relationship="Citrix.Monitor.Repository.Machine_DesktopGroup_DesktopGroup_Machines" ToRole="Machine_DesktopGroup" FromRole="DesktopGroup_Machines" /> 
  </EntityType>
- <EntityType Name="Hypervisor">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="Name" Type="Edm.String" /> 
  <Property Name="LifecycleState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Machines" Relationship="Citrix.Monitor.Repository.Machine_Hypervisor_Hypervisor_Machines" ToRole="Machine_Hypervisor" FromRole="Hypervisor_Machines" /> 
  </EntityType>
- <EntityType Name="MachineFailureLog">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="MachineId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="FailureStartDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="FailureEndDate" Type="Edm.DateTime" /> 
  <Property Name="FaultState" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="LastDeregisteredCode" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Machine" Relationship="Citrix.Monitor.Repository.Machine_MachineFailures_MachineFailureLog_Machine" ToRole="Machine_MachineFailures" FromRole="MachineFailureLog_Machine" /> 
  </EntityType>
- <EntityType Name="MachineHotfixLog">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="MachineId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="HotfixId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="ChangeType" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CurrentState" Type="Edm.Boolean" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Hotfix" Relationship="Citrix.Monitor.Repository.MachineHotfixLog_Hotfix_Hotfix_MachineHotfixLogs" ToRole="Hotfix_MachineHotfixLogs" FromRole="MachineHotfixLog_Hotfix" /> 
  <NavigationProperty Name="Machine" Relationship="Citrix.Monitor.Repository.Machine_MachineHotfixLogs_MachineHotfixLog_Machine" ToRole="Machine_MachineHotfixLogs" FromRole="MachineHotfixLog_Machine" /> 
  </EntityType>
- <EntityType Name="Hotfix">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="Name" Type="Edm.String" /> 
  <Property Name="Article" Type="Edm.String" /> 
  <Property Name="ArticleName" Type="Edm.String" /> 
  <Property Name="FileName" Type="Edm.String" /> 
  <Property Name="FileFormat" Type="Edm.String" /> 
  <Property Name="Version" Type="Edm.String" /> 
  <Property Name="ComponentName" Type="Edm.String" /> 
  <Property Name="ComponentVersion" Type="Edm.String" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="MachineHotfixLogs" Relationship="Citrix.Monitor.Repository.MachineHotfixLog_Hotfix_Hotfix_MachineHotfixLogs" ToRole="MachineHotfixLog_Hotfix" FromRole="Hotfix_MachineHotfixLogs" /> 
  </EntityType>
- <EntityType Name="User">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="Sid" Type="Edm.String" /> 
  <Property Name="Upn" Type="Edm.String" /> 
  <Property Name="UserName" Type="Edm.String" /> 
  <Property Name="FullName" Type="Edm.String" /> 
  <Property Name="Domain" Type="Edm.String" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Sessions" Relationship="Citrix.Monitor.Repository.Session_User_User_Sessions" ToRole="Session_User" FromRole="User_Sessions" /> 
  </EntityType>
- <EntityType Name="ConnectionFailureLog">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="SessionKey" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="FailureDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ConnectionFailureEnumValue" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Session" Relationship="Citrix.Monitor.Repository.ConnectionFailureLog_Session" ToRole="Session" FromRole="ConnectionFailureLog" /> 
  </EntityType>
- <EntityType Name="FailureLogSummary">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="SummaryDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="DesktopGroupId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="FailureCategory" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="FailureCode" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="FailureCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Granularity" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="DesktopGroup" Relationship="Citrix.Monitor.Repository.FailureLogSummary_DesktopGroup" ToRole="DesktopGroup" FromRole="FailureLogSummary" /> 
  </EntityType>
- <EntityType Name="LoadIndexSummary">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="SummaryDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="MachineId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="SumCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SumLoadIndex" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SumCpu" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SumNetwork" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SumDisk" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SumMemory" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="SumSessionCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Granularity" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="Machine" Relationship="Citrix.Monitor.Repository.LoadIndexSummary_Machine" ToRole="Machine" FromRole="LoadIndexSummary" /> 
  </EntityType>
- <EntityType Name="SessionActivitySummary">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="SummaryDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="DesktopGroupId" Type="Edm.Guid" Nullable="false" /> 
  <Property Name="ConnectedSessionCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="DisconnectedSessionCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="TotalLogOnDuration" Type="Edm.Double" Nullable="false" /> 
  <Property Name="TotalLogOnCount" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Granularity" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  <NavigationProperty Name="DesktopGroup" Relationship="Citrix.Monitor.Repository.SessionActivitySummary_DesktopGroup" ToRole="DesktopGroup" FromRole="SessionActivitySummary" /> 
  </EntityType>
- <EntityType Name="TaskLog">
- <Key>
  <PropertyRef Name="Id" /> 
  </Key>
  <Property Name="Id" Type="Edm.Int64" Nullable="false" /> 
  <Property Name="RunDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="TaskCategory" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Task" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="Result" Type="Edm.Int32" Nullable="false" /> 
  <Property Name="ErrorMessage" Type="Edm.String" /> 
  <Property Name="CreatedDate" Type="Edm.DateTime" Nullable="false" /> 
  <Property Name="ModifiedDate" Type="Edm.DateTime" Nullable="false" /> 
  </EntityType>
- <Association Name="ApplicationInstanceSummary_Application">
  <End Type="Citrix.Monitor.Repository.ApplicationInstanceSummary" Role="ApplicationInstanceSummary" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Application" Role="Application" Multiplicity="0..1" /> 
  </Association>
- <Association Name="ApplicationInstanceSummary_DesktopGroup">
  <End Type="Citrix.Monitor.Repository.DesktopGroup" Role="DesktopGroup" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.ApplicationInstanceSummary" Role="ApplicationInstanceSummary" Multiplicity="*" /> 
  </Association>
- <Association Name="Application_ApplicationInstances_ApplicationInstance_Application">
  <End Type="Citrix.Monitor.Repository.ApplicationInstance" Role="ApplicationInstance_Application" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Application" Role="Application_ApplicationInstances" Multiplicity="0..1" /> 
  </Association>
- <Association Name="Application_DesktopGroups_DesktopGroup_Applications">
  <End Type="Citrix.Monitor.Repository.DesktopGroup" Role="DesktopGroup_Applications" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Application" Role="Application_DesktopGroups" Multiplicity="*" /> 
  </Association>
- <Association Name="ApplicationInstance_Session_Session_ApplicationInstances">
  <End Type="Citrix.Monitor.Repository.Session" Role="Session_ApplicationInstances" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.ApplicationInstance" Role="ApplicationInstance_Session" Multiplicity="*" /> 
  </Association>
- <Association Name="Session_Connections_Connection_Session">
  <End Type="Citrix.Monitor.Repository.Connection" Role="Connection_Session" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Session" Role="Session_Connections" Multiplicity="0..1" /> 
  </Association>
- <Association Name="Session_CurrentConnection">
  <End Type="Citrix.Monitor.Repository.Session" Role="Session" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Connection" Role="CurrentConnection" Multiplicity="0..1" /> 
  </Association>
- <Association Name="Session_Failure">
  <End Type="Citrix.Monitor.Repository.Session" Role="Session" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.ConnectionFailureCategory" Role="Failure" Multiplicity="0..1" /> 
  </Association>
- <Association Name="Session_Machine_Machine_Sessions">
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine_Sessions" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.Session" Role="Session_Machine" Multiplicity="*" /> 
  </Association>
- <Association Name="Session_User_User_Sessions">
  <End Type="Citrix.Monitor.Repository.User" Role="User_Sessions" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.Session" Role="Session_User" Multiplicity="*" /> 
  </Association>
- <Association Name="Machine_Catalog_Catalog_Machines">
  <End Type="Citrix.Monitor.Repository.Catalog" Role="Catalog_Machines" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine_Catalog" Multiplicity="*" /> 
  </Association>
- <Association Name="Machine_CurrentLoadIndex">
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.LoadIndex" Role="CurrentLoadIndex" Multiplicity="0..1" /> 
  </Association>
- <Association Name="Machine_DesktopGroup_DesktopGroup_Machines">
  <End Type="Citrix.Monitor.Repository.DesktopGroup" Role="DesktopGroup_Machines" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine_DesktopGroup" Multiplicity="*" /> 
  </Association>
- <Association Name="Machine_Hypervisor_Hypervisor_Machines">
  <End Type="Citrix.Monitor.Repository.Hypervisor" Role="Hypervisor_Machines" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine_Hypervisor" Multiplicity="*" /> 
  </Association>
- <Association Name="Machine_LoadIndex_LoadIndex_Machine">
  <End Type="Citrix.Monitor.Repository.LoadIndex" Role="LoadIndex_Machine" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine_LoadIndex" Multiplicity="0..1" /> 
  </Association>
- <Association Name="Machine_MachineFailures_MachineFailureLog_Machine">
  <End Type="Citrix.Monitor.Repository.MachineFailureLog" Role="MachineFailureLog_Machine" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine_MachineFailures" Multiplicity="0..1" /> 
  </Association>
- <Association Name="Machine_MachineHotfixLogs_MachineHotfixLog_Machine">
  <End Type="Citrix.Monitor.Repository.MachineHotfixLog" Role="MachineHotfixLog_Machine" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine_MachineHotfixLogs" Multiplicity="0..1" /> 
  </Association>
- <Association Name="MachineHotfixLog_Hotfix_Hotfix_MachineHotfixLogs">
  <End Type="Citrix.Monitor.Repository.Hotfix" Role="Hotfix_MachineHotfixLogs" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.MachineHotfixLog" Role="MachineHotfixLog_Hotfix" Multiplicity="*" /> 
  </Association>
- <Association Name="ConnectionFailureLog_Session">
  <End Type="Citrix.Monitor.Repository.Session" Role="Session" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.ConnectionFailureLog" Role="ConnectionFailureLog" Multiplicity="*" /> 
  </Association>
- <Association Name="FailureLogSummary_DesktopGroup">
  <End Type="Citrix.Monitor.Repository.FailureLogSummary" Role="FailureLogSummary" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.DesktopGroup" Role="DesktopGroup" Multiplicity="0..1" /> 
  </Association>
- <Association Name="LoadIndexSummary_Machine">
  <End Type="Citrix.Monitor.Repository.Machine" Role="Machine" Multiplicity="0..1" /> 
  <End Type="Citrix.Monitor.Repository.LoadIndexSummary" Role="LoadIndexSummary" Multiplicity="*" /> 
  </Association>
- <Association Name="SessionActivitySummary_DesktopGroup">
  <End Type="Citrix.Monitor.Repository.SessionActivitySummary" Role="SessionActivitySummary" Multiplicity="*" /> 
  <End Type="Citrix.Monitor.Repository.DesktopGroup" Role="DesktopGroup" Multiplicity="0..1" /> 
  </Association>
- <EntityContainer Name="DatabaseContext" m:IsDefaultEntityContainer="true">
  <EntitySet Name="ApplicationActivitySummaries" EntityType="Citrix.Monitor.Repository.ApplicationInstanceSummary" /> 
  <EntitySet Name="Applications" EntityType="Citrix.Monitor.Repository.Application" /> 
  <EntitySet Name="ApplicationInstances" EntityType="Citrix.Monitor.Repository.ApplicationInstance" /> 
  <EntitySet Name="Sessions" EntityType="Citrix.Monitor.Repository.Session" /> 
  <EntitySet Name="Connections" EntityType="Citrix.Monitor.Repository.Connection" /> 
  <EntitySet Name="ConnectionFailureCategories" EntityType="Citrix.Monitor.Repository.ConnectionFailureCategory" /> 
  <EntitySet Name="Machines" EntityType="Citrix.Monitor.Repository.Machine" /> 
  <EntitySet Name="Catalogs" EntityType="Citrix.Monitor.Repository.Catalog" /> 
  <EntitySet Name="LoadIndexes" EntityType="Citrix.Monitor.Repository.LoadIndex" /> 
  <EntitySet Name="DesktopGroups" EntityType="Citrix.Monitor.Repository.DesktopGroup" /> 
  <EntitySet Name="Hypervisors" EntityType="Citrix.Monitor.Repository.Hypervisor" /> 
  <EntitySet Name="MachineFailureLogs" EntityType="Citrix.Monitor.Repository.MachineFailureLog" /> 
  <EntitySet Name="MachineHotfixLogs" EntityType="Citrix.Monitor.Repository.MachineHotfixLog" /> 
  <EntitySet Name="Hotfixes" EntityType="Citrix.Monitor.Repository.Hotfix" /> 
  <EntitySet Name="Users" EntityType="Citrix.Monitor.Repository.User" /> 
  <EntitySet Name="ConnectionFailureLogs" EntityType="Citrix.Monitor.Repository.ConnectionFailureLog" /> 
  <EntitySet Name="FailureLogSummaries" EntityType="Citrix.Monitor.Repository.FailureLogSummary" /> 
  <EntitySet Name="LoadIndexSummaries" EntityType="Citrix.Monitor.Repository.LoadIndexSummary" /> 
  <EntitySet Name="SessionActivitySummaries" EntityType="Citrix.Monitor.Repository.SessionActivitySummary" /> 
  <EntitySet Name="TaskLogs" EntityType="Citrix.Monitor.Repository.TaskLog" /> 
- <AssociationSet Name="ApplicationInstanceSummary_Application" Association="Citrix.Monitor.Repository.ApplicationInstanceSummary_Application">
  <End Role="ApplicationInstanceSummary" EntitySet="ApplicationActivitySummaries" /> 
  <End Role="Application" EntitySet="Applications" /> 
  </AssociationSet>
- <AssociationSet Name="ApplicationInstanceSummary_DesktopGroup" Association="Citrix.Monitor.Repository.ApplicationInstanceSummary_DesktopGroup">
  <End Role="ApplicationInstanceSummary" EntitySet="ApplicationActivitySummaries" /> 
  <End Role="DesktopGroup" EntitySet="DesktopGroups" /> 
  </AssociationSet>
- <AssociationSet Name="ApplicationInstance_Application" Association="Citrix.Monitor.Repository.Application_ApplicationInstances_ApplicationInstance_Application">
  <End Role="Application_ApplicationInstances" EntitySet="Applications" /> 
  <End Role="ApplicationInstance_Application" EntitySet="ApplicationInstances" /> 
  </AssociationSet>
- <AssociationSet Name="DesktopGroup_Applications" Association="Citrix.Monitor.Repository.Application_DesktopGroups_DesktopGroup_Applications">
  <End Role="Application_DesktopGroups" EntitySet="Applications" /> 
  <End Role="DesktopGroup_Applications" EntitySet="DesktopGroups" /> 
  </AssociationSet>
- <AssociationSet Name="ApplicationInstance_Session" Association="Citrix.Monitor.Repository.ApplicationInstance_Session_Session_ApplicationInstances">
  <End Role="ApplicationInstance_Session" EntitySet="ApplicationInstances" /> 
  <End Role="Session_ApplicationInstances" EntitySet="Sessions" /> 
  </AssociationSet>
- <AssociationSet Name="Connection_Session" Association="Citrix.Monitor.Repository.Session_Connections_Connection_Session">
  <End Role="Session_Connections" EntitySet="Sessions" /> 
  <End Role="Connection_Session" EntitySet="Connections" /> 
  </AssociationSet>
- <AssociationSet Name="Session_CurrentConnection" Association="Citrix.Monitor.Repository.Session_CurrentConnection">
  <End Role="Session" EntitySet="Sessions" /> 
  <End Role="CurrentConnection" EntitySet="Connections" /> 
  </AssociationSet>
- <AssociationSet Name="Session_Failure" Association="Citrix.Monitor.Repository.Session_Failure">
  <End Role="Session" EntitySet="Sessions" /> 
  <End Role="Failure" EntitySet="ConnectionFailureCategories" /> 
  </AssociationSet>
- <AssociationSet Name="Session_Machine" Association="Citrix.Monitor.Repository.Session_Machine_Machine_Sessions">
  <End Role="Session_Machine" EntitySet="Sessions" /> 
  <End Role="Machine_Sessions" EntitySet="Machines" /> 
  </AssociationSet>
- <AssociationSet Name="Session_User" Association="Citrix.Monitor.Repository.Session_User_User_Sessions">
  <End Role="Session_User" EntitySet="Sessions" /> 
  <End Role="User_Sessions" EntitySet="Users" /> 
  </AssociationSet>
- <AssociationSet Name="Machine_Catalog" Association="Citrix.Monitor.Repository.Machine_Catalog_Catalog_Machines">
  <End Role="Machine_Catalog" EntitySet="Machines" /> 
  <End Role="Catalog_Machines" EntitySet="Catalogs" /> 
  </AssociationSet>
- <AssociationSet Name="Machine_CurrentLoadIndex" Association="Citrix.Monitor.Repository.Machine_CurrentLoadIndex">
  <End Role="Machine" EntitySet="Machines" /> 
  <End Role="CurrentLoadIndex" EntitySet="LoadIndexes" /> 
  </AssociationSet>
- <AssociationSet Name="Machine_DesktopGroup" Association="Citrix.Monitor.Repository.Machine_DesktopGroup_DesktopGroup_Machines">
  <End Role="Machine_DesktopGroup" EntitySet="Machines" /> 
  <End Role="DesktopGroup_Machines" EntitySet="DesktopGroups" /> 
  </AssociationSet>
- <AssociationSet Name="Machine_Hypervisor" Association="Citrix.Monitor.Repository.Machine_Hypervisor_Hypervisor_Machines">
  <End Role="Machine_Hypervisor" EntitySet="Machines" /> 
  <End Role="Hypervisor_Machines" EntitySet="Hypervisors" /> 
  </AssociationSet>
- <AssociationSet Name="LoadIndex_Machine" Association="Citrix.Monitor.Repository.Machine_LoadIndex_LoadIndex_Machine">
  <End Role="Machine_LoadIndex" EntitySet="Machines" /> 
  <End Role="LoadIndex_Machine" EntitySet="LoadIndexes" /> 
  </AssociationSet>
- <AssociationSet Name="MachineFailureLog_Machine" Association="Citrix.Monitor.Repository.Machine_MachineFailures_MachineFailureLog_Machine">
  <End Role="Machine_MachineFailures" EntitySet="Machines" /> 
  <End Role="MachineFailureLog_Machine" EntitySet="MachineFailureLogs" /> 
  </AssociationSet>
- <AssociationSet Name="MachineHotfixLog_Machine" Association="Citrix.Monitor.Repository.Machine_MachineHotfixLogs_MachineHotfixLog_Machine">
  <End Role="Machine_MachineHotfixLogs" EntitySet="Machines" /> 
  <End Role="MachineHotfixLog_Machine" EntitySet="MachineHotfixLogs" /> 
  </AssociationSet>
- <AssociationSet Name="MachineHotfixLog_Hotfix" Association="Citrix.Monitor.Repository.MachineHotfixLog_Hotfix_Hotfix_MachineHotfixLogs">
  <End Role="MachineHotfixLog_Hotfix" EntitySet="MachineHotfixLogs" /> 
  <End Role="Hotfix_MachineHotfixLogs" EntitySet="Hotfixes" /> 
  </AssociationSet>
- <AssociationSet Name="ConnectionFailureLog_Session" Association="Citrix.Monitor.Repository.ConnectionFailureLog_Session">
  <End Role="ConnectionFailureLog" EntitySet="ConnectionFailureLogs" /> 
  <End Role="Session" EntitySet="Sessions" /> 
  </AssociationSet>
- <AssociationSet Name="FailureLogSummary_DesktopGroup" Association="Citrix.Monitor.Repository.FailureLogSummary_DesktopGroup">
  <End Role="FailureLogSummary" EntitySet="FailureLogSummaries" /> 
  <End Role="DesktopGroup" EntitySet="DesktopGroups" /> 
  </AssociationSet>
- <AssociationSet Name="LoadIndexSummary_Machine" Association="Citrix.Monitor.Repository.LoadIndexSummary_Machine">
  <End Role="LoadIndexSummary" EntitySet="LoadIndexSummaries" /> 
  <End Role="Machine" EntitySet="Machines" /> 
  </AssociationSet>
- <AssociationSet Name="SessionActivitySummary_DesktopGroup" Association="Citrix.Monitor.Repository.SessionActivitySummary_DesktopGroup">
  <End Role="SessionActivitySummary" EntitySet="SessionActivitySummaries" /> 
  <End Role="DesktopGroup" EntitySet="DesktopGroups" /> 
  </AssociationSet>
  </EntityContainer>
  </Schema>
  </edmx:DataServices>
  </edmx:Edmx>````

Jun 11 '19 08:06 chinnaphani

Alright, so can you please execute your postman query with this amendment to the URL "?$format=json".

Jun 11 '19 09:06 filak-sap

okay!, if use this in code as below. i am getting error but if i use this in internet explorer i got download a file and below is the output.

directorURL = "http:/server.exeample.com/Citrix/Monitor/OData/v2/data?$format=json"

Traceback (most recent call last): File "C:/Users/pxksa/PycharmProjects/testodata/direct.py", line 15, in directorReqData = pyodata.Client(directorURL,directorSession) File "C:\Users\pxksa\PycharmProjects\testodata\venv\lib\site-packages\pyodata\client.py", line 37, in new 'Metadata request failed, status code: {}, body:\n{}'.format(resp.status_code, resp.content), resp) pyodata.exceptions.HttpError: Metadata request failed, status code: 415, body: b'<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code /><m:message xml:lang="en-US">Unsupported media type requested.</m:message><m:innererror><m:message>A

and here is the downloaded output of data.json.

{"odata.metadata":"http://server.example.com/Citrix/Monitor/OData/v2/Data/$metadata","value":[{"name":"ApplicationActivitySummaries","url":"ApplicationActivitySummaries"},{"name":"Applications","url":"Applications"},{"name":"ApplicationInstances","url":"ApplicationInstances"},{"name":"Sessions","url":"Sessions"},{"name":"Connections","url":"Connections"},{"name":"ConnectionFailureCategories","url":"ConnectionFailureCategories"},{"name":"Machines","url":"Machines"},{"name":"Catalogs","url":"Catalogs"},{"name":"LoadIndexes","url":"LoadIndexes"},{"name":"DesktopGroups","url":"DesktopGroups"},{"name":"Hypervisors","url":"Hypervisors"},{"name":"MachineFailureLogs","url":"MachineFailureLogs"},{"name":"MachineHotfixLogs","url":"MachineHotfixLogs"},{"name":"Hotfixes","url":"Hotfixes"},{"name":"Users","url":"Users"},{"name":"ConnectionFailureLogs","url":"ConnectionFailureLogs"},{"name":"FailureLogSummaries","url":"FailureLogSummaries"},{"name":"LoadIndexSummaries","url":"LoadIndexSummaries"},{"name":"SessionActivitySummaries","url":"SessionActivitySummaries"},{"name":"TaskLogs","url":"TaskLogs"}]}

Jun 11 '19 10:06 chinnaphani

Use this URL in Postnam: http://HOST/Citrix/Monitor/OData/v2/data/Applications?$format=json

Jun 11 '19 10:06 jfilak

here is the result, mate, can you please replace the server name in your previous comment, as part the security :), please do not mind.

Traceback (most recent call last): File "C:/Users/pxksa/PycharmProjects/testodata/direct.py", line 15, in directorReqData = pyodata.Client(directorURL,directorSession) File "C:\Users\pxksa\PycharmProjects\testodata\venv\lib\site-packages\pyodata\client.py", line 37, in new 'Metadata request failed, status code: {}, body:\n{}'.format(resp.status_code, resp.content), resp) pyodata.exceptions.HttpError: Metadata request failed, status code: 415, body: b'<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code /><m:message xml:lang="en-US">Unsupported media type requested.</m:message><m:innererror><m:message>A supported MIME type could not be found that matches the acceptable MIME types for the request. The supported type(s) 'application/atom+xml;type=feed, application/atom+xml, application/json;odata=minimalmetadata;streaming=true, application/json;odata=minimalmetadata;streaming=false, application/json;odata=minimalmetadata, application/json;odata=fullmetadata;streaming=true, application/json;odata=fullmetadata;streaming=false, application/json;odata=fullmetadata, application/json;odata=nometadata;streaming=true, application/json;odata=nometadata;streaming=false, application/json;odata=nometadata, application/json;streaming=true, application/json;streaming=false, application/json;odata=verbose, application/json' do not match any of the acceptable MIME types 'json/$metadata'.</m:message><m:type>Microsoft.Data.OData.ODataContentTypeException</m:type><m:stacktrace> at Microsoft.Data.OData.MediaTypeUtils.GetContentTypeFromSettings(ODataMessageWriterSettings settings, ODataPayloadKind payloadKind, MediaTypeResolver mediaTypeResolver, MediaType& mediaType, Encoding& encoding) \n at Microsoft.Data.OData.ODataMessageWriter.EnsureODataFormatAndContentType() \n at Microsoft.Data.OData.ODataUtils.SetHeadersForPayload(ODataMessageWriter messageWriter, ODataPayloadKind payloadKind) \n at System.Data.Services.ResponseContentTypeNegotiator.DetermineResponseFormat(ODataPayloadKind payloadKind, String acceptableMediaTypes, String acceptableCharSets)</m:stacktrace></m:innererror></m:error>'

Jun 11 '19 10:06 chinnaphani

here is the one from if i use this in internet explorer.

{"odata.metadata":"http://server.example/Citrix/Monitor/OData/v2/Data/$metadata#Applications","value":[{"Id":"0e4a1e2b-6687-40b5-a3cf-011766eb5b80","Name":"Oracle JDeveloper -ESF","PublishedName":"Oracle JDeveloper -ESF","ApplicationType":0,"Enabled":true,"AdminFolder":"Developer\","LifecycleState":1,"CreatedDate":"2018-01-13T19:28:14.893","ModifiedDate":"2018-01-24T10:33:00.737"},{"Id":"f82667ab-03b8-46a6-b267-01b3cd0d6f21","Name":"Control-M 7 CM -ESF","PublishedName":"Control-M 7 CM -0a1b74a518f4","Name":"PeopleTools 8_51 RPT Converter -ESF","PublishedName":"PeopleTools 8_51 RPT Converter -}]}

Jun 11 '19 10:06 chinnaphani

Alrigth, we are no longer fighting metadata. Please, use this URL in Postnam: http://HOST/Citrix/Monitor/OData/v2/Data/Applications?$format=json

Jun 11 '19 11:06 filak-sap

getting this error

` directorURL = "http://server.example.com/Citrix/Monitor/OData/v2/data/Applications?$format=json"

directorSession = requests.session() directorSession.auth= HttpNtlmAuth(username,password)

directorReqData = directorSession.get(directorURL)

directorReqData = pyodata.Client(directorURL,directorSession)`

Traceback (most recent call last): File "C:/Users/pxksa/PycharmProjects/testodata/direct.py", line 15, in directorReqData = pyodata.Client(directorURL,directorSession) File "C:\Users\pxksa\PycharmProjects\testodata\venv\lib\site-packages\pyodata\client.py", line 37, in new 'Metadata request failed, status code: {}, body:\n{}'.format(resp.status_code, resp.content), resp) pyodata.exceptions.HttpError: Metadata request failed, status code: 415, body: b'<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"><m:code /><m:message xml:lang="en-US">Unsupported media type requested.</m:message><m:innererror><m:message>A supported MIME type could not be found that matches the acceptable MIME types for the request. The supported type(s) 'application/atom+xml;type=feed, application/atom+xml, application/json;odata=minimalmetadata;streaming=true, application/json;odata=minimalmetadata;streaming=false, application/json;odata=minimalmetadata, application/json;odata=fullmetadata;streaming=true, application/json;odata=fullmetadata;streaming=false, application/json;odata=fullmetadata, application/json;odata=nometadata;streaming=true, application/json;odata=nometadata;streaming=false, application/json;odata=nometadata, application/json;streaming=true, application/json;streaming=false, application/json;odata=verbose, application/json' do not match any of the acceptable MIME types 'json/$metadata'.</m:message><m:type>Microsoft.Data.OData.ODataContentTypeException</m:type><m:stacktrace> at Microsoft.Data.OData.MediaTypeUtils.GetContentTypeFromSettings(ODataMessageWriterSettings settings, ODataPayloadKind payloadKind, MediaTypeResolver mediaTypeResolver, MediaType& mediaType, Encoding& encoding) \n at Microsoft.Data.OData.ODataMessageWriter.EnsureODataFormatAndContentType() \n at Microsoft.Data.OData.ODataUtils.SetHeadersForPayload(ODataMessageWriter messageWriter, ODataPayloadKind payloadKind) \n at System.Data.Services.ResponseContentTypeNegotiator.DetermineResponseFormat(ODataPayloadKind payloadKind, String acceptableMediaTypes, String acceptableCharSets)</m:stacktrace></m:innererror></m:error>'

Jun 11 '19 11:06 chinnaphani

Alright, sure, please, read my message carefully.

Please use the url http://HOST/Citrix/Monitor/OData/v2/Data/Applications?$format=json in Postnam or in Internet Explorer.

Clarification: do not use the URL in Python code to initialize pyodata.Client.

Jun 11 '19 11:06 filak-sap

hi, here is the result from internet explorer.

Jun 11 '19 11:06 chinnaphani

Thank you! Good job.

Unfortunately, the response is in the OData V3/V4 format which is not supported by pyodata yet. That's the reason why you were getting the KeyError: 'd' exception.

pyodata expects the response in the format {"d": {"results": [{ ... while the response you posted has the format{"odata.metadata":"PLACEHOLDER","value":[{ ...

You can explore the differences at:

https://services.odata.org/V2/Northwind/Northwind.svc/
https://services.odata.org/V3/Northwind/Northwind.svc/

I am not sure how much effort would be needed to implement V3 support because we have no internal V3 service for testing and I do not want DoS the one mentioned above.

Anyway, I am not sure why the service returns V2 metadata but V3 data. You might consider contacting the service provider for support on this issue.

Jun 11 '19 12:06 filak-sap

okay, thank you.. but fyi ... if i use, below code. i am getting count, but not further luck. thank for your help

test = directorReqData.entity_sets.Applications.get_entities().count().execute() print(test)

result is : 178

Jun 11 '19 13:06 chinnaphani

python-pyodata
python-pyodata copied to clipboard

ubale to connect

import pdb; pdb.set_trace()

directorReqData = directorSession.get(directorURL)

python-pyodata python-pyodata copied to clipboard

ubale to connect

import pdb; pdb.set_trace()

directorReqData = directorSession.get(directorURL)

python-pyodata
python-pyodata copied to clipboard