gotqcorp
Level 7

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.

 

Regards

gotqcorp

0 Kudos
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