DX Infrastructure Management

Currently this is the working link to documentation: Delete Devices in USM

You can run the tool on any machine that has an UIM robot installed + nimsoft_generic.dat/pm

If you run: nimsoft_delete_device.exe/pl -h"your_devname" -d"p"

you will receive a PU command generated for the discovery_server callback..

If you replace the callback: remove_master_device_by_cskey + id by the callback: get_discovery_status, you can test if your connection to UIM works fine with the userid and password combination

Common problems are that the uim domain/hub/robot is not in the correct case or that the password is not encrypted via nimsoft_crypt.exe (both in nimsoft_generic.dat)

I am trying to run it in my server but I get SSL Security error(SQL-08001). Any idea why this happened?

I'm pretty sure the information in nimsoft_generic.dat is correct because I can run it in my desktop up until I get 'Could not login to nimbus with username administrator!'. By the way is it only supposed to run in the UIM server?

OK I will try to re-enter the user name and password again to make sure its accurate. If still not working I will email you for assistance. I have tried using the UIM administrator account and my own account with no luck already.

Hi, like you can see at docops: "Delete Devices in USM - CA Unified Infrastructure Management - 8.5.1 - CA Technologies Documentation", the delete is not the same, qos data is not deleted, only the reference to the data is removed.

Whether UIM version 8.5.1 have this feature of deleting all entries from DB too?

Thank you for the reply. The user name and password were entered correctly and I got the password from the nimsoft crypt tool's output as outlined in the doc.

I have a question - does deleting servers from USM inventory screen and checking the 3 options (Delete Measurements, Ack Alarms, and Prevent Rediscovery) do the same thing as the nimsoft delete tool? If it doesnt delete all the qos data and various other leftover stuff I will email you to get this tool working.

Thanks again

During simulation mode the tool doesn't need a login to UIM, only to SQL.

This means probably that the combiniation of uim_user and uim_password is:

- invalid

- password perhaps not encrypted with the nimsoft_crypt tool like described in the doc file

- you have a user/password combination for another environment (test/prod?)

Else send me an email (luc.christiaens@ca.com) and I can provide you with a version that creates the manual PU command to execute the callback.

I am trying to get this utility working in our environment. In simulation mode it runs all the way through and bypasses all deletes which seems correct. When setting sim to no it stops at step 2 and says "Could not login to nimbus with username" then terminates. I have verified all the entires in the nimsoft_generic.dat file are correct. Any suggestions will be very helpful...

We did talk offline, and the reason was that the tool was pointing to a test UIM installation.

Ok, thanks, but how can I troubleshoot why the device is not found? I know it exists in cm_computer_system but still the script can't find it and stops.

Thanks for the remark, this is clearly an error in my "print "statements.

The SQL queries are correctly using cm_computer_system but in the print statementsonly  I'm using in error cm_computer_table.

I made the correction in teh source so that the next version will include this. Thanks, Luc

Hi,

I'm trying to run the script on Windows, UIM 8.5.1, but getting error:

nimsoft_delete_device -s"n" -h"dummyapp1"

the output I get indicates the device can't be found in cm_computer_table:

step 1: We added device string: dummyapp1
step 2: We found 0 matching devices in cm_computer_table (matching: ) (csids: )
step 2: Like no match was found in cm_computer_table we stop here

Obviously nimsoft_generic.dat is correct and the script is able to connect to the db but looking for cm_computer_table? Is there a cm_computer_table table? The device exists in cm_computer_system...

Indeed, version 8.51 has removed the logic/requirement of a "model device" in MCS.

I'm testing the new version of the tool and will post it asap.

In the meantime you can use -m"n" to bypass this problem.

Note: like Yu mentioned, there is now in 8.51 a standard option under USM to remove a device (that works very good)

Hello.

You are now able to remove devices through USM in UIM 8.5.1.

This is new feature in UIM 8.5.1.

Please have a minute to take a look at the below doc.

Remove Devices in USM - CA Unified Infrastructure Management - 8.5.1 - CA Technologies Documentation 

Regards,

Yu

Hi Luc ~ Wondering if you can remark on any utility use against 8.5.1 GA. Upon execution against upgraded 8.5.1 GA environment received error shown below and appears that with 8.5.1 column [model_device] was removed from [SSRV2DeviceGroup] table. Adding -m"n" moves past the error but wondering if you have any other knowledge related to this table change.

Error output:

nimsoft_delete_device_v2.3\nimsoft_delete_device.exe -h "removednode" -q"y" -l"y" -I"n" -v"y" -s"n"
Unknown option: I
Unknown option: n
step 1: We added device string: removednode
DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'model_device'. (SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)at script/nimsoft_delete_device.pl line 195.
SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'model_device'.(SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000)

Hi Marek,

You can perhaps start a new discussion with your question?

I never reviewed these tables for possible relationships and for possible deletes in these entries.

Regards, Luc

Luc,

thank you for very useful document and script, but I'm facing little bit different issue - due to wrong setup, ntperf probe created tens of thousands metrics instead of few metrics with thousands pieces of data. So my tables s_qos_data, cm_configuration_item and cm_configuration_item_metric contain huge number of rows with useless data. If I've read well your script will delete data from s_qos_data and *_qos_data_* tables according to table_id. Is there a way to delete data from cm_configuration_item and cm_configuration_item_metric? I don't know if there are some other relations ...

Kind regards,

Marek

Perhaps that you need to change:

#!/usr/bin/perl

into:
#!/opt/nimbus/bin/perl

(I have also $PERL5LIB set to point to my perl env)

BUT: this Perl was written to access an UIM manager on Windows environment, I don't know if it will work if your UIM manager/DB is on Linux.

Trying to run the command, but getting an error stating I'm missing something:

[root@nimsoft-prod-noc01 tools]# perl nimsoft_delete_device.pl -h"nos-hub01"
perl: symbol lookup error: ./auto/Nimbus/API/API.so: undefined symbol: Perl_xs_apiversion_bootcheck

It's normal that during simulation this error rc=2 is not appearing because we don't create the callback to the discovery server.

I reproduced the second problem "not staying in domain", and will correct it.

Can you send me a direct email (luc.christiaens@ca.com) so I can post you a special version of the tool that will display more info.

Confirmed nimsoft_generic.dat entries are accurate. Have attempted lower and upper case with no change. discovery_server is operational and deployed into the primary robot. When executed with simulation the script moves past step 2 where without simulation mode fails with the "rc=2 err". While executing with simulation mode observed the script not remaining with domain_lock. It is discovering another UIM domain on the subnet. This appears to be issue with the script API discovering the other UIM domain broadcast?

I assume that all parameters in the nimsoft_generic.dat are correctly modified?

Specially: uim_domain, uim_hub and uim_robot because they are used to construct the address to the main hub to execute the callback. I assume that the discovery_server probe is also running on that server?

Because the error message you receive could indicate that the created address is incorrect.

Thank you for confirming perl dependency. Error remains the same when using compiled executable or perl with "rc=2 err=communication". Running directly on primary hub as well.

UIM v8.4 SP1

     discovery_server v8.41 (yes, remove_master_devices_by_cskeys is available as have executed said tasks manually previously)

- for Perl it's the same requirement as the UIM Perl requirement: only version 5.14.2 (the Perl source was created with Strawberry Perl 5.14.2 + the SDK Perl copied into these Strawberry libraries)

- what version of UIM are you running? The Perl uses the discovery_server probe callback: remove_master_devices_by_cskeys. Is this callback available in your discovery probe?

Thanks! Was those settings but setting did not seem to take but looks better now when invoked as simulation. Can you confirm few additional items?

• Any specific perl version dependency? When execute the script itself receive error that could not be started due to "perl514.dll" missing. Library content has been copied into lib folder. Currently have Strawberry Perl v5.24.
• Receive this error when execute the compiled exe.
  • rc=2 err=communication error from nimNamedRequest for remove_master_devices_by_cskeys

This depends what you define in the nimsoft_generic.dat file.

1 - if you enter sql_user and sql_password (password in crypted format) we will use SQL auth.

2 - if you use "sql_user=trusted" and use also "sql_password=" we will connect to MSSQL via a trusted connection. (=your logged on userid) (see also doc file page 12)

What authentication methods are permitted for this utility to run against SQL servers? Mixed mode, Windows Authentication or is this utility SQL Server authentication only?

I tested on 8.1 and 8.31; you need to use the parameter -m"n" so that the tool will not use the MCS/SSR sql tables

I am running on 8.1.

This version was tested on UIM 8.4

Probably this will work on other 8.x versions if you add the option: -m"n" to exclude MCS/SSR records that are new in 8.4.

( I will try to start a 8.31 image to test this out. What version are you running?)

Luc -Whether it supports all versions of UIM.