Wednesday, April 25, 2012

NetQos License Upgrades

For CA NetQoS products, each license file (.lic) is named after the software
component that it enables. Please copy each license file into the \netqos
\licenses directory of the corresponding host:

1. In d:\netqos\licenses for CA appliances with preinstalled software.
2. In c:\windows\netqos\licenses for certain software installations.
3. Create the license folder if it does not exist.
4. Replace any existing license file(s) with the new license file(s) for
license upgrades.
5. Choose Yes to replace files if prompted.
6. Restart all NetQoS Services on the server to apply the new license.
7. Remove the existing Hardware against Software Piracy (HASP) "dongle"
from the USB drive if applicable. Note that the new software license file
replaces the old HASP license key.

Certain software components require multiple license files to function as
shown in the list below:

" ReporterAnalyzer Distributed: Requires 2 license files. For version
9.0 and later, copy the license keys for the Flow Manager and
ReporterAnalyzer to the Management Console. For version 8.3 and earlier,
install the Flow Manager license file on the Flow Manager and the
ReporterAnalyzer license file on the Management Console. The Data Storage
Appliance and Harvester do not require license files.

" ReporterAnalyzer Stand-alone: Requires 1 license file.

" SuperAgent Master Console: Requires 1 license file.

" SuperAgent Single-Port Collector: Each Collector or Virtual
Collector requires 1 license file. Note that the SuperAgent Multi-Port
Collector (MTP) does not require a software license file.

" SuperAgent Aggregator: Requires 1 license file.

" SuperAgent Stand-alone: Requires 1 license file.

" Unified Communications Monitor (UCM) Management Console: Requires 1
license file.

" Unified Communications Monitor (UCM) Management Collector: Each
Collector requires 1 license file.

" Unified Communications Monitor (UCM) Stand-alone (Basic): Requires 1
license file.

" NetVoyant Management Console: Requires 1 license file.

" NetVoyant Polling Station: Each Polling Station requires 1 license
file.

Note that the CA NetQoS Performance Center does not require a license file.

Att,

Aline Yuri Isa

Friday, April 20, 2012

C Drive greater than 80% used

You can run the nqdiskcleaner (on the FTP site) to see if it pulls cleans up anything else, but being over 80% isn’t really a big deal. I assume watchdog is complaining about this, but it’s not really going to effect the performance of the server. You can change the watchdog settings so that it alarms at 90% if the customer doesn’t want to get alerts anymore.

Rediscover Interfaces in Reporter Analyzer when Deleted:

One way to force a re-discovery is to delete the router (and interfaces) from the Harvester database and restart the Harvester service. Obviously, take care when doing so

(Working Script)
But before you go there, check the router state.
mysql -P 3308 harvester
select inet_ntoa(router),state from routers order by router;
-- do you see state=2 for these misbehaving devices
----------------

Open a command prompt.
mysql -P 3308 reporter
update routers set lastrefresh=0, firstpollerror=0, nextpollretry=0
where inet_aton('routeraddress'); i.e. ('1.1.1.1');

1.1.1.1=the router ip address
------------------------
Hi John. This is often the result of stale routers in the harvester dbase. On harvester:

Mysql -P 3308 harvester
Delete * from routers;
or
Mysql -P 3308 harvester
Delete 10.246.155.253 from routers;
-------------------------------------
There’s a chance that until the harvester tells the console it sees a “new” device that you won’t see this router. You would have to delete from the routers table, and then the interfaces table (to clean out the interface that were associated with that router) on the harvester…

Mysql -P 3308 harvester
Delete from routers where inet_ntoa(router)=inet_aton(‘10.246.155.253’);

Mysql -P 3308 harvester
Delete from interfaces where routerid(10.246.155.253) not in (select routerid from routers).

Something like that…retype the lines (due to Microsoft smart quotes) and double check column names.
-------------------------------

Your queries are slightly off there.

The ip address is stored as an integer, and inet_aton(‘X.x.x.x’) will give you that integer representation.
The query you’re running is giving you the dotted decimial (using inet_ntoa()) and then comparing it to the integer you got using the inet_aton() command.

***(This one worked)
Mysql -P 3308 harvester
Delete from routers where router = inet_aton('10.246.155.253');
delete from interfaces where router not in (select router from routers);

You don’t need to designate anything concerning the router in the second query because you should never have interfaces that don’t have a router referenced in the routers table, so we would want ot clear any interface out that doesn’t have it’s router represented in the routers table.

Reset both the harvester and the reaper services on that system after making the delete.
------------------------
Instructions from Support Case:

If its a new device and we can delete it you can do the following to delete the device and clean up to allow it to come in fresh.

1)In "Administration->Physical & Virtual", you can select the router then select "Delete"

2)Then also check "Adminstration->Enable Interfaces" to see if the router

still shows up here, if so delete it here as well.

3)Then on the Harvester you can run the following mysql queries...

mysql -P3308 harvester

truncate table interfaces;

truncate table routers;

4)Recycle the NetQos Harvester service

Then allow the router to come back in again.

Thursday, April 12, 2012

All Interfaces

This wouldn’t do any of that…..agents_all_view will only show you your licensed interfaces.

Select * from interfaces where lastflow > unix_timestamp()-86400 and enabled='N';

This would give you any where the interfaces are not enabled and lastflow has seen an update in the last 24 hours.

To get it to a text file:

Mysql –P 3308 reporter
Select * from interfaces where lastflow > unix_timestamp()-86400 and enabled='Y'; (Worked)

Mysql -P 3308 reporter
select * From interfaces where lastflow> unix_timestamp()-86400 and enabled='N'; (Worked)

From Katie:

mysql -P 3308 reporter
select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view
where LastData > unix_timestamp()-86400 and enabled='N' order by RouterName; (not working)

mysql -P 3308 reporter
select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view; (worked)

List of Inactive enabled interfaces in RA 9.0

From MSO Wiki

List of Inactive and Enabled interfaces in Reporter Analyzer 9.0

mysql -P 3308 reporter

select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view where LastData < unix_timestamp()-86400 and enabled='Y' order by RouterName; > RAInterfacesinactive.txt (worked)