Remote Desktop Manager API for third party apps?

Remote Desktop Manager API for third party apps?

avatar

Hello,

we use a Ticket/Workflow-System called "tanss", which is used by many system houses (in germany) and we like to get
f.e. details from the connection log (vpn-connections f.e.) into our ticket-system/calendar.

Our primary goal is, to get a "connection start" and "connection end" info - maybe directly readable from
the sql-database, so that we have an appointment in our ticket-system calendar.

How is it possible to get that data?


Yours sincerely
Daniel

All Comments (6)

avatar

Yes the data is in the table ConnectionLog and you can create a query to read it.

David Hervieux

avatar

Thank you for your reply.
Is it also possible to get the unique id of an object?

Example:
A supporter works in a RDP-session on server "SRV01" from customer A.
Later he works in a RDP-session on server "SRV01" from customer B.

How is it possible to make a difference, when objekt names are the same.
We thought of something like an unique id to match the customer/machine in our ticket system.

avatar

We have the ConnectionID that is unique

David Hervieux

avatar

That would be fine, if the connection id would be also in the ConnectionLog table.
(I can't see any ID in the mentioned table)

Will this be realized in a future release?

avatar

Its in the log table as well. The column is ConnectionID. You can open the table with SQL Management Studio and you will see the ID columns.
edited by dhervieux on 12/16/2014

David Hervieux

avatar

Indeed the ConnectionID showed up with SQL Management Studio.
We did a query through Excel to this table, but it didn't show that column.

Thank you / solved.