muralikvp

Could you use the Automatic subnet discovery option in IPAM.This feature will automatically discover the subnet from routers.Finally it will list the subnets discovered in routers.Importing subnets through this method will import IPAddress too. You may see this feature in below location IPAM Summary >> Getting Started with…

You should install "Add IPs" tool on solarwinds IPAM installed machine.

Your account may have limited access to subnets.While logging into SWQL studio certain username will be prompted.Provide Username which will have access to subnets. While logging into the SWQL studio user should select server type as Orion v3 How to check User is having access to subnets Through this path you may customize…

Try to add Top100 in your query.If records are huge then Top 100 records only filtered out SELECT Top 100 EventTime, UserName, Message FROM IPAM.Event where userName <>'SYSTEM' and eventtype in (920) order by EventTime desc SELECT Top 100 EventTime, UserName, Message FROM IPAM.Event where userName <>'SYSTEM' and eventtype…

Use this below query you will get the DHCP server name as well select n.SysName as 'DHCP server Name' , DHCPServer.FoundAddress as 'DHCP Server IP',g.FriendlyName as 'Subnet Name' from IPAM_Group g inner join [IPAM_DhcpScopeDetails] scope on (g.GroupId = scope.SubnetId) inner join IPAM_DhcpServerDetails DHCPServer on…

You may click the button cancel (Admin >> IPAM settings >> View scan job status) Not tested but below query this will clear the job from "Scan Job Status" page. delete FROM [dbo].[IPAM_ScanInstance] where SubnetId in (select groupid from IPAM_Group where GroupType= 8 and Address='10.199.193.0') Place your subnet address…

Based on number of users created in Orion, IPAM will duplicate such number of subnets in IPAM.Subnet. You may use IPAM.GroupReport SWIS entity. This SWIS entity is filtered with respective to SWQL studio login .That means if you have entered through 'admin' account then IPAM.GroupReport will give information related to…

Whether Windows credentials has been accidentally deleted in IPAM ?. Try to check the mapped windows credentials to particular DHCP server is exist or not. If windows credentials is present and it has been mapped to DHCP server then try to add one more windows credential and map it to existing DHCP server. Path to create…

As already stated it IPAM 3.1 has reached EOL. Not having any ready fix for this issue.

we can't run the scanning engine through SDK.

Columns can be selected based on entity(IPAM Group Node Attribute). If you need different columns from different Entity(other than IPAM Group node Attribute) then you need to select "Advance database query" method.Custom SWQL or custom sql may be good option.

Could you try Add ips tool.This tool will create IP Address based on created subnets. Run this tool on IPAM installed server. IPAM 4.3 Tool - Importing large number of subnets.

You can't delete the DHCP leases form IPAM. In IPAM IP Address delete will only delete from database. This deletion of IPAddress will not take any effect in DHCP server. Note: IPAM itself will periodically scan the subnets and display the IPAddress status.In this case you don't need to ping in separate to find out the…

1.Click edit button in custom query resource. 2.Enable search option on it 3.Paste the below query on it SELECT EventTime, UserName, Message FROM IPAM.Event where userName <>'SYSTEM' and eventtype in (920) and (UserName LIKE '%13%' or Message LIKE '%13%' or EventTime LIKE '%13%') 4. Click submit. 5.Now the resource is…

This below query will display the subnet and corresponding DHCP server name select DHCPServer.FoundAddress as 'DHCP Server Name',g.FriendlyName as 'Subnet Name' from IPAM_Group g inner join [IPAM_DhcpScopeDetails] scope on (g.GroupId = scope.SubnetId) inner join IPAM_DhcpServerDetails DHCPServer on (DHCPServer.NodeId =…

IPAM doesn't use additional poller for IP scanning. IPAM uses only main poller for IP scanning.

What is the type of DHCP server ? .Could you explain in detail. Could you share your dhcpd configuration file if it is ISC DHCP server.

You may create an custom SWQL report which will give the list of 'Not available' ipAddress list.Could you use the below query to get the list of Not available ip Address collection ======================== SELECT IPAddress, CASE i.status WHEN 1 THEN 'USED' WHEN 4 THEN 'Reserved' WHEN 8 THEN 'Transient' END as Status FROM…

Try to check whether IPAM DB is updated with your customizations. IPAM will usually store in "IPAM_setting" table. Run this below query and see whether your changes got affected SELECT [AssignedTo] ,[Category] ,[Name] ,[Value] ,[ValueType] FROM [IPAM_4.4_Dev].[dbo].[IPAM_Setting] where Name ='UI.MgtSubnetColumns'

I can't get you. You are worrying about subnet description then download the "Download an example spreadsheet with Subnets" from Import spread sheet link. Fill appropriate subnet information and there is a field called "Descroption" fill that with your information. After importing process the subnets will be filled with…

Below thread may help for you https://thwack.solarwinds.com/thread/91402

Could you post some specific error messages found in IPAM.BusinessLayer.log which will be usually found in this location C:\programdata\Solarwinds\Logs\IPAM. To increase the logging level for IPAM business layer log in debug mode.Search for "LogAdjuster" tool from solarwinds installed location then adjust debug mode for…

You may delete the group of IPAddress(.30 - 254) from subnet.This deletion will impact in IPAM only not in any real world subnets. IPAM will lose those tracking of IPAddress then you may have huge number of license count. Currently there is no option to skip the IPAddress in IPAM

Which CIDR using for your subnet ? Whether you have enabled neighbour scanning for your Subnet.? CIDR which is less than 24 may take some time to complete the subnet scan. I think IPAM is not following Trace route.

Could you confirm the IPAM version once again ?. IPAM 3.1 has reached End of life. Could you use the IPAM 4.3 which is latest version.If you still using IPAM 4.3 in your machine then re run the Configuration wizard in Orion installed machine.This may resolve the issue.

You are trying to match some text with IPAM_DhcpLeases.ClientName.If all scopes is having same text filter then you may just remove "IPAM_DhcpLeases.ScopeId = 47" and "IPAM_DhcpLeases.ScopeId = 39" to cover entire scopes. Could you club one or more scopes under one region.That means (IPAM_DhcpLeases.ScopeId = 47 or…

You may see the details of Each group type in IPAM_GroupType table Pasting the IPAM_grouptype table information below GroupTypeId GroupType 1 Root 2 Group 4 Supernet 8 Subnet 16 Internal 32 DHCP Server 64 DHCP Scope 128 IPv6 Global Prefix 256 IPv6 Site 512 IPv6 Subnet 1024 Dns Server 2048 Dns Zone

We can't schedule the Automatic Subnet discovery scanning.

Try to use this below query ========================== SELECT IPAddress, DnsBackward, DhcpClientName FROM IPAM.IPNode I inner join IPAM.GroupNode g on (i.Subnetid = g.Groupid) Where i.Status=2 AND (g.FriendlyName = '<Your Friendly Name>' OR g.FriendlyName = '<Your Friendly Name>') and Distance =1 ======================…

Yes you can choose the custom fields in report.See the below snapshot , you may choose IPAM Group Node attribute which Subnet Custom fields or IPAM IP node Attribute which is IP Address custom field.