#CognosAnalyticswithWatson

One option is - You can extract alerts specific to downtime of service from Cognos Logs and probably upload as CSV file to generate Dashboard. If on CA 11.1.7, probably you can automate task

• Jupyter Notebook to parse Cognos logs and format
• Using REST API to upload CSV file to Cognos

------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Fri October 23, 2020 11:16 AM
From: Ramanujam Rajagopal
Subject: Cognos servers health check

Hi,

I am using a distributed environment and want to display the health check of each servers in the dashboard whether the server is active or down. 

NC_SDS_INSTANCE table storing instance URL but not saying server is up or down.

Which content store table is storing server related information?.

Thanks,

Ram

#CognosAnalyticswithWatson

Thanks Buddhi.

I am using CA11.1.4. We don't have Jupyter Notebook yet. 

I will go with option 1.
1. have to extract the log files every day and find if the server is down.
2. load the data into the table
3. create a report.

Okay i will  update the status next week

Thanks,
Ram 






------------------------------
Ramanujam Rajagopal
------------------------------

Original Message:
Sent: Fri October 23, 2020 11:45 AM
From: Buddhi Gupta
Subject: Cognos servers health check

One option is - You can extract alerts specific to downtime of service from Cognos Logs and probably upload as CSV file to generate Dashboard. If on CA 11.1.7, probably you can automate task

• Jupyter Notebook to parse Cognos logs and format
• Using REST API to upload CSV file to Cognos

------------------------------
Buddhi Gupta

Original Message:
Sent: Fri October 23, 2020 11:16 AM
From: Ramanujam Rajagopal
Subject: Cognos servers health check

Hi,

I am using a distributed environment and want to display the health check of each servers in the dashboard whether the server is active or down. 

NC_SDS_INSTANCE table storing instance URL but not saying server is up or down.

Which content store table is storing server related information?.

Thanks,

Ram

#CognosAnalyticswithWatson

You may need to check more frequently depending on Environment usage as logs files get full and renamed.

You can write shell script to get required log messages and format in tabbed format and upload to Cognos.


------------------------------
Buddhi Gupta
------------------------------

Original Message:
Sent: Fri October 23, 2020 11:57 AM
From: Ramanujam Rajagopal
Subject: Cognos servers health check

Thanks Buddhi.

I am using CA11.1.4. We don't have Jupyter Notebook yet. 

I will go with option 1.
1. have to extract the log files every day and find if the server is down.
2. load the data into the table
3. create a report.

Okay i will  update the status next week

Thanks,
Ram 






------------------------------
Ramanujam Rajagopal

Original Message:
Sent: Fri October 23, 2020 11:45 AM
From: Buddhi Gupta
Subject: Cognos servers health check

One option is - You can extract alerts specific to downtime of service from Cognos Logs and probably upload as CSV file to generate Dashboard. If on CA 11.1.7, probably you can automate task

• Jupyter Notebook to parse Cognos logs and format
• Using REST API to upload CSV file to Cognos

------------------------------
Buddhi Gupta

Original Message:
Sent: Fri October 23, 2020 11:16 AM
From: Ramanujam Rajagopal
Subject: Cognos servers health check

Hi,

I am using a distributed environment and want to display the health check of each servers in the dashboard whether the server is active or down. 

NC_SDS_INSTANCE table storing instance URL but not saying server is up or down.

Which content store table is storing server related information?.

Thanks,

Ram

#CognosAnalyticswithWatson

You could also look into using the SDK to ping the dispatchers: https://www.ibm.com/support/pages/sdk-how-monitor-cognos-dispatcher-and-services-see-if-they-are-available. It shouldn't be very difficult to do. MotioCI has the functionality to create alerts for this and many more things that really help manage Cognos environments including: security policy changes, new folder content and data source testing.

------------------------------
Robert Hofstetter
------------------------------

Original Message:
Sent: Fri October 23, 2020 11:16 AM
From: Ramanujam Rajagopal
Subject: Cognos servers health check

Hi,

I am using a distributed environment and want to display the health check of each servers in the dashboard whether the server is active or down. 

NC_SDS_INSTANCE table storing instance URL but not saying server is up or down.

Which content store table is storing server related information?.

Thanks,

Ram

#CognosAnalyticswithWatson