storniga

Thank you very much!! I figured I would try something like that which would deliver only the changes of the last 7 days, but I don't know how to write it correctly: SELECT EventTime, UserName, Message FROM IPAM.Event where userName <>'SYSTEM' and eventtype in (920) and eventtime > *today()-7 days* order by EventTime desc

thank you very much

Thanks a lot!! You are a life safer These are the queries I'm using now: SELECT EventTime, UserName, Message FROM IPAM.Event where userName <>'SYSTEM' and eventtype in (920) order by EventTime desc SELECT EventTime, UserName, Message FROM IPAM.Event where userName <>'SYSTEM' and eventtype in (920) and (UserName LIKE…

Thank you very very much! I was wondering how I can have the hostname in addition to the ip address of the DHCP-Server, is that stored in another table again and I have to make another join??

Or does it have to do something with the type "Webgestützt". I don't really know what that means..

Ok, so Event Messages like "DHCP Scope:.... overlaps in the range(s): (172.....) " only means that the addresses are managed on more than one DHCP Server? Because we have two DHCP Server on each site, one acts as Primary Server and is active while the other one is passive and only takes over if the Primary fails, both…

Hi, the category of the reports are "Benutzerdefiniert" which means in english defined by user. The custom reports are saved in the reports folder and can be found under "all reports" just like all other reports. Is there maybe a way to chance the category of the reports to something else that is than listet at the custom…

So we adapted the query as following in order to make it work SELECT EventTime, UserName, Message FROM IPAM.Event where userName <>'SYSTEM' and eventtype in (920) ORDER BY EventTime DESC; Maybe the amount of events was too big and so the query failed, so we reduced it to only one type of events and created three different…

Thank you very much!! I added the custom query like you described, but there is nothing displayed. After some time of loading the following error message is displayed:

hi, thank you for your quick answer!! we know solved it in that way that we deleted the subnets which where created from dhcp, then imported the xls-list and then afterwards added the discovered dhcp scopes to the imported subnets.. so we didn't have to try out the sql-solution. I still don't know why it's possible to add…

PLEASE HELP! I know that, when I'm in the network view I can see the dhcp server when I go to the coloum "Scopes in Subnet" and hover over the content of this coloum.. but I really need to have the DHCP server name displayed in reports as well

UPDATE: So i found out the name of the table is IPAM_DhcpOptionsValue, so i did this: select dhcp.FriendlyName as 'DHCP Server', g.FriendlyName as 'Subnet Name',g.Address,g.CIDR, opt.Code as 'ScopeOptionCode', opt.Value as 'ScopeOption' from IPAM_Group g left outer join [IPAM_DhcpScopeDetails] scope on (g.GroupId =…

So, i tried the following: select dhcp.FriendlyName as 'DHCP Server', g.FriendlyName as 'Subnet Name', scope.* from IPAM_Group g left outer join [IPAM_DhcpScopeDetails] scope on (g.GroupId = scope.SubnetId) left outer join IPAM_DhcpServerDetails DHCPServer on (DHCPServer.NodeId = scope.NodeId) left outer join IPAM_Group…