eky

No as you can see when you run that you will only get current dates. Not historical ones. Eg. The machine which was connected 10 days ago will not be there.

Please vote for this option:

Well first of all thanks for you reply. Tried whit GUI but i did not succeed so i turned to to SWQL. I opened SWQL studio just to see what i would get to modify it but it seems like this query is to heavy for the system as i get: Message: Timeout expired. The timeout period elapsed prior to completion of the operation or…

Hi, The beginning. Somebody please try to perfect this.. USE [SolarWindsOrion] SELECT dbo.udt_FormatMACAddressForUI(E.MACAddress) as MACAddress, ip.IPAddress, P2e.LastSeen as LastSeen, P2E.VlanID, N.caption as Nodename, P.Name as PortName, P.PortDescription FROM UDT_Endpoint E with(nolock) INNER JOIN (select…

Hi, I think we are looking for same information: Please let me know if you succeed. If i Do first I will let you know. Newbie: Combining UDT and Interface data in an repport

Nobody? My final goal is to have this fields: <Mac Address> <interface caption>, <date last seen on network> , <ip address that it had (if known)> At this moment I have: SELECT MACAddress, LastSeen, PortDescription, IpAddress, HostName FROM [dbo].[UDT_MACCurrentInformation]…

Nope, Excluding wireless did't help nether. Thanks anyway for your suggestion...