How can I add Site and Network definitions using mysql for Site to Site reports?

book

Article ID: 144973

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Is there a way to create site and network definitions using mysql for Site to Site reports instead of having to use the GUI?

Environment

Release : 10.0

Component : NQRPTA - REPORTERANALYZER

Resolution

The site definitions are defined in the reporter.sites table on the NFA Console server.

The query below will show you the sites results on the console.

mysql reporter
select * from sites;



You would first have to create the sites, the first column increments up so that number must be unique on each insert, the second column is the name, then description, tenantID default is 8, then you can use the unix_timestamp() function to enter the current time and you use N for the deleted column like in the example below:

insert into sites values(2,'site2','Description2',8,unix_timestamp(),'n');

The subnets are in the reporter.networks table and each row maps back to a siteID, so once all the sites are created, you can then add the network like below, the first column has to be unique, and the last column has to match the siteID from above.



insert into networks values (5,'network5','13.0.0.0/24',2);



You can then verify the site has the proper networks by looking at the Admin->Sites page:

Additional Information

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/network-flow-analysis/10-0-0/managing/manage-sites.html

Attachments