This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gotqcorp
Level 7
‎Aug 16, 2020 12:31 PM

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

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.
1 Reply
dennis_reinhardt
Level 7
‎Aug 16, 2020 02:17 PM

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