DX Infrastructure Manager

Expand all | Collapse all

Nimsoft Infrastructure Manager: Unable to get the alarm messages for the custom checkpoint using the sqlserver probe

  • 1.  Nimsoft Infrastructure Manager: Unable to get the alarm messages for the custom checkpoint using the sqlserver probe

    Posted 10-27-2015 12:44 PM

    I am new to Nimsoft Infrastructure Manager. I am trying to perform the sql calls into the database to get the information using the 'sqlserver' probe.

     

    I having created a new checkpoint for the sqlserver probe in the Nimsoft Infrastructure probe and added it to the profile.

    I have created a new checkpoint - 'no_of_tenants'. I am able to get a value count as '3' for the query. Please find the pic_1 and pic_2 for the details.

    Next, I have created a threshold for this checkpoint with the count value greater than or equal to 2 then raise a message. See the attached pic_3 and pic_4 for the details.

    Next, I have used this check point in a profile 'Tenant_Profile'. See the pic_5 for the details.

    But, when I check the status for the profile, I don't see any alarm messages for the 'no_of_tenants' profile. See the attached pic_6 for the details. I see that the Value column shows 3 but there are no alarm messages triggered.

     

    Could you please let me know where I am going wrong.

     

    Regards,

    Abhilash

    402-999-3929

     

    pic1:

    Pic_1.PNG

     

    pic2:

    Pic_2.PNG

     

    pic3:

    Pic_3.PNG

     

    pic4:

    Pic_4.PNG

     

    pic 5:

    Pic_5.PNG

     

    pic 6:

    Pic_6.PNG



  • 2.  Re: Nimsoft Infrastructure Manager: Unable to get the alarm messages for the custom checkpoint using the sqlserver probe

    Posted 11-16-2015 02:59 AM

    Here's the basic method that I used, and it's working well for me in UIM 8.1 (sqlserver probe v4.91).

     

    I have a single connection that is connected to a single profile dedicated to a custom check.

     

    • First, I created a custom connection to my DB
    • Next, I created a profile for my custom check.
    • Next I created my template - this is where it got tricky for me.
      • I wrote my query and gave each returned column my own name; I am keying off of the first column in the "row identification" field. In your screenshot, this would be "pic2" and the "row identification" field. Try adding "$count" here (without the quotes).
    • Also, when you specify "2" in "key column value" in "pic3", I don't think you'll find anything; you don't return a column called "2" in your query. Try leaving that blank or maybe changing it to "count" as well. For me, I have one query that returns 15 rows and 6 columns. My version of your "pic3" looks like the shot below, but I have a WHOLE bunch of these. This is because my query keys off of the first column, which I have labeled "Process" in my query (SELECT foo AS process FROM bar WHERE ...). If the row returned (in my example) is "TRANRECE" then this could be used. But I am also getting many columns (another "AS" in my SELECT query, in this picture, I have "pending" as one of my columns; another is "processing" and another is "error' and another is "critical" and so on). So, in my SS, what you're actually seeing is if the first column has a value of "TRANRECE" and the column labeled "Pending" is greater than or equal to 101, then a "minor" alarm is raised. I have custom message text too. Hope this helps, and good luck.


  • 3.  Re: Nimsoft Infrastructure Manager: Unable to get the alarm messages for the custom checkpoint using the sqlserver probe

    Posted 12-09-2015 03:06 PM

    Thank you for your input but when I try to give the pic 3 as:

     

    I still do not get any alarms. And when I view the log file for the SQL Server probe, I get this information:

     

    Dec  9 15:05:20:443 [11104] sqlserver: fwIsScheduleActive starting -  current: 1449691520

    Dec  9 15:05:20:443 [11104] sqlserver: fwParseTime starting..., time: 15:5

    Dec  9 15:05:20:443 [11104] sqlserver: fwExpandMsgString starting chk: no_of_tenants

    Dec  9 15:05:20:443 [11104] sqlserver: (fwCheckAlarm) Checkpoint:no_of_tenants CI ID:4.2.1 CI Name:SampleProfile-no_of_tenants-no_of_tenants_QOS_SQLSERVER-SampleProfile-no_of_tenants.3

    Dec  9 15:05:20:443 [11104] sqlserver: (fwCustomSendAlarm) - ciOpenRemoteDevice->hostname-> [ATL-DEV-004D],p->pconn->address-> [ATL-DEV-004D,1433] 

    Dec  9 15:05:20:443 [11104] sqlserver: ciOpen - cache path: C:\Program Files (x86)\Nimsoft\niscache

    Dec  9 15:05:20:443 [11104] sqlserver: ciGetDeviceIdentifiers - ATL-DEV-004D found (remote device) [D7F2447AF8184E95725362C0F789F2E46]

    Dec  9 15:05:20:443 [11104] sqlserver: ciClose - [CD30DE42037C217D98FCA66D21BA41725]

    Dec  9 15:05:20:443 [11104] sqlserver: Profile: SampleProfile/no_of_tenants: fwSendQos starting...mode 0, active=1

    Dec  9 15:05:20:443 [11104] sqlserver: Profile: SampleProfile/no_of_tenants,: fwSendQos QOS_SQLSERVER_no_of_tenants_QOS_SQLSERVER for target: LocalDB

    Dec  9 15:05:20:443 [11104] sqlserver: (fwSendQos) - Checkpoint:no_of_tenants CI ID:4.2.1 CI Name:SampleProfile-no_of_tenants-no_of_tenants_QOS_SQLSERVER-SampleProfile-no_of_tenants

    Dec  9 15:05:20:443 [11104] sqlserver: (fwSendQos) - ciOpenRemoteDevice->hostname-> [ATL-DEV-004D],p->pconn->address-> [ATL-DEV-004D,1433] 

    Dec  9 15:05:20:443 [11104] sqlserver: Profile: SampleProfile/no_of_tenants,: key count found

    Dec  9 15:05:20:444 [11104] sqlserver: RREPLY: status=OK(0) <-10.90.3.75/48001  h=37 d=28

    Dec  9 15:05:20:444 [11104] sqlserver:  head   mtype=200 status=0 seq=0

    Dec  9 15:05:20:444 [11104] sqlserver:  data   nimid=RX96603190-00026

    Dec  9 15:05:20:444 [11104] sqlserver: sockClose:00000000012EF6F0:10.90.3.75/7463

    Dec  9 15:05:20:444 [11104] sqlserver: SREQUEST: _close ->10.90.3.75/48001

    Dec  9 15:05:20:444 [11104] sqlserver:  head   tout=0 addr=

    Dec  9 15:05:20:444 [11104] sqlserver: ciClose - [CB98258A63B69B80AE0F600911CF91CA6]

    Dec  9 15:05:20:444 [11104] sqlserver: Profile: SampleProfile/no_of_tenants - fwClear_orphans started...

    Dec  9 15:05:20:445 [11104] sqlserver: TASK: SQLSERVER_PROFILE - RemoveRequest 'SampleProfile', 0 in queue, 0 active

     

     

     

    Could you please let me know where I am going wrong. Any help will be appreciated.



  • 4.  Re: Nimsoft Infrastructure Manager: Unable to get the alarm messages for the custom checkpoint using the sqlserver probe

    Posted 12-09-2015 03:09 PM

    Adding the schedule screenshot: