NPC

Managing application performance and delivery across modern enterprise and service provider networks is a complex undertaking. The CA NetQoS products take a “Performance First” approach to monitoring networks and systems. This approach is based on the premise that you must capture and analyze data from applications, devices, and the network itself to get an accurate and comprehensive understanding of how well an organization is supporting application delivery. The CA NetQoS Performance Center is the industry’s most comprehensive management software suite offering role-specific views of application response times, network traffic composition, infrastructure health and performance, unified communications quality of experience, early warning alerts, and packet-level diagnostics. The CA NetQoS Performance Center suite unlocks the intelligence needed to manage the network for application performance with a full suite of analytics and reporting fueled by the most comprehensive data collection available. With the NetQoS Performance Center, IT organizations can: • Helps ensure problems are resolved quickly • Mitigate risk from planned and unplanned changes • Deliver consistent application performance • Take measured steps to optimize application delivery • Reduce and avoid costs

NV Devices

Mysql nms2 -P 3308 -s -e ""select dev_name from  devices "" >> device_inventory.txt

Quick NetVoyant Device Query

This query will the total of devices for each device class in NetVoyant.

mysql nms2
select count(*), class_name from devices d join device_classes dc on d.class_id=dc.class_id 

group by class_name;

To show this as only enabled devices, add an additional filter for the poll_enable field.

mysql nms2
select count(*), class_name from devices d join device_classes dc on d.class_id=dc.class_id 

where d.poll_enable=1 group by class_name;

NetVoyant Device list

mysql -h 10.80.3.8 -D nms2 -u nmsuper -predpoint -N -e "select smgr_host, dev_alias, model_name, ifindex, ifdescr, pollinst_desc, concat(d.sys_name,'_',i.ifindex) from service_managers s, devices d, device_models m, interfaces i, pollinst p where s.smgr_id=d.dev_owner AND p.device_id=d.device_id AND d.model_id=m.model_id AND p.pollinst_id=i.interface_id AND p.pollinst_enabled=1 and d.class_id in (1,7)" > NVInterfaces.txt

Method to export NV device list data?

Mysql.exe nms2 -e "select dev_name from devices where poll_enable = 1" > path\export_file.txt

RA Fix #2

1)You can try the following on the RA console.

mysql -P3308 reporter

delete from database_servers_scheduler where resultcode not like '%SUCCEEDED%';

2)Then recycle the ReporterAnalyzer Manager service on the RA console and the "DSA Loader Service" on the DSA and see if those tables start updating or not.

Then wait about 15-30 minutes to see if any new data shows up.

3)If not, just delete the interface from the "Administration->Physical & Virtual", this will delete the agent record from the database and should clean up the DSA.

4)Then delete the full router from "Administration->Enable Interfaces"

5)RDP to the Harvester and run the following....

mysql -P3308 harvester

truncate table routers;

truncate table interfaces;

6)Recycle the "Harvester" and "Reaper" Services on the Harvester.

7)Wait for the router to show up again in "Enable Interfaces" and enable the interfaces.

8)Wait at least 15-30 minutes before expecting any data

9)If no data, run an NFA Parser report and verify that specific interface has more than 50 KB of traffic over a 15 minute period.

RA Router fix issue

If you look at the report for this interface for less than two hours do you see any data?

Are other devices using the same DSA having the same issue?

You could use the query below to find out what other interfaces are using that DSA.  Use the router Address in the first query to find out what DSA its using, then use the DSA address in the second query to see what other devices are using that DSA.

mysql -P3308 reporter

select DataServerAddress, RouterAddress from agents_all_view where RouterAddress='x.x.x.x';

select * from agents_all_view where DataServerAddress="x.x.x.x";

Can you also upload a SupportCIG file if possible so I can see what is going on in the logs?

ftp://ftp.ca.com/pub/netqos/supporttools/releasedtools/SupportCIG.exe

You may also want to check the DSA credentials on the Administration->DSA page to make sure they are a valid login for the RA console and the account is not locked out or anything like that.

Copy/Paste

http://www.evernote.com/shard/s4/sh/9ce13685-da6f-40f3-b48a-5130deed047a/f9fd89c5f795d9863769e476e5b4f2ce