Showing results for 
Show  only  | Search instead for 
Did you mean: 

Can subnet be registered through SQL Query directly?

Hi Guys,

I would like to ask community members whether I can bulk register subnet through SQL Query.

Would be good I can get help from you guys.




(1) Reply

Hi @gotqcorp ,

based on the structure of FNMS subnets, you should do the following steps

1. Create a new site nodes based on the required data for the SP "EXEC SitePutBatchByName"

2. Add IP subents to sites creates in step 1, using the SP "EXEC SiteSubnetPutBatchByIPSubnetIPSubnetBitsSiteID"

3. Assign IP subnets created in step 2 to beacon assignment, using the SP "EXEC BeaconSiteSubnetMappingPutBatchByBeaconIDSubnetID"


Best, Dennis