Listing specific Notification Manager database (NMDB) entries

Products

• Automation Point

Issue/Introduction

I need to document my Notification Manager email lists defined in the NMDB for auditing purposes.

How can I achieve this? My lists are large, so going through all of them one at a time from the NM Website is not an option.

 

Environment

Release : 11.7

Resolution

1. Verify which drive on the server containing the Automation Point installation. The following assumes AP is installed on the D: drive.

2. Copy the Listparm.rex file from the samples directory:

D:\Program Files (x86)\CA\CA Automation Point\Sample\nm

to the Myfiles\Rexx library:

D:\ProgramData\CA\CA Automation Point\Site\MyFiles\Rexx

3. From the Windows Command Prompt, change the directory to the MyFiles\Rexx directory:

CD D:\ProgramData\CA\CA Automation Point\Site\MyFiles\Rexx

4. Run the Listparm.rex file and pipe the output to a text file:

asorexx Listparm.rex > listparm.output.txt

The listparm.output.txt file will also reside in the D:\ProgramData\CA\CA Automation Point\Site\MyFiles\Rexx directory after execution.

5. The output file will contain all parms by default. Review the output and determine which parms contain the data of interest.

Sample entries within the output file:

Parm name     :  Phone
Parm key      :  300001380
Method        :  Alphanumeric Pager 1
Method key    :  200001006
Entity        :  Jane Doe
Entity key    :  199999997
Timeblock     :  null time
Timeblock key :  0
Flags         :  00000002
Value         :  555-9876


Parm name     :  PagerID
Parm key      :  300001379
Method        :  Alphanumeric Pager 1
Method key    :  200001006
Entity        :  Jane Doe
Entity key    :  199999997
Timeblock     :  null time
Timeblock key :  0
Flags         :  00000002
Value         :  1234

6. The default ADDRESS VOX "ListParm NAME(*)" command within the Listparm.rex file can now be modified based upon the data from the entries identified in the previous step to limit the output data to only those entries of interest. The full syntax of the ADDRESS VOX ListParm command is as follows:

ADDRESS VOX "LISTPARM {NAME(parmName) | KEY(parmKey)} METHOD(methodName|methodKey)
  ITEM(entityName|entityKey) [CMDRESP(destination)] [PREFIX(varname)]"

 

Examples -

To find all entries associated with a phone number parm:

ADDRESS VOX "ListParm NAME(Phone)"

To find all entries containing email address information for a specific email method:

ADDRESS VOX "ListParm NAME(*) METHOD(Email 1)"

7. After modifying the ADDRESS VOX ListParm command within the Listparm.rex file, save it, and repeat step 4. The output file should now only contain the entries of interest.