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
Yes the data is in the table ConnectionLog and you can create a query to read it.
David Hervieux
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.
We have the ConnectionID that is unique
David Hervieux
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?
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
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.