Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB query Target usage
#1
Question 
Hi,
Due to historical and practical reasons we have alot of connections multiple times.
And possible quite some connections that are no loger used.

is there a query to find out what is the number of "made connections" to a target and the last time that connection was used ?

This will probably be limited to the settings in the log option, but still this would be quite handy.

We are running on SQL server, so a Tsql would be much more interesting than through a menu option.
Reply
#2
Hi,

I'm not very good with SQL so I had to ask and got this statement as a
starting point:

SELECT * FROM Logs WHERE LogType = 2 And ComputerName = ‘test‘

Hope that helps :-)
best regards,
Michael -- michael.scholz@asg.com --
Reply




Users browsing this thread: 1 Guest(s)