DX NetOps

 View Only
Expand all | Collapse all

Cannot Generate Reports by selected event ID

  • 1.  Cannot Generate Reports by selected event ID

    Posted Sep 19, 2019 11:52 AM

    Hi,

    The customer has a requirement of getting a report filtered with event id 0x10d35 . In the input controls, we saw an option where we can include some attributes, but there are some  .xml files. Please advise a way to do this since this is a bit urgent. waiting for your prompt response.


    Thank you,

    Uchira.



  • 2.  RE: Cannot Generate Reports by selected event ID
    Best Answer

    Posted Sep 19, 2019 01:25 PM
    1. Navigate to $SPECROOT/custom/repmgr/config/events/ 
    2. Create an XML file as below (Ex: DeviceDown.xml)

    <?xml version="1.0" encoding="ISO-8859-1"?>
    <filter xmlns="http://www.aprisma.com"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.aprisma.com ./event-filter.xsd">
    <event_type>0x10d35</event_type>
    </filter>

    DeviceDown.xml will be available in the list to select from the reports.

    Below is the link for documentation on the same.
    https://docops.ca.com/ca-spectrum/10-2-3/en/installing-and-upgrading/install-report-manager/maintenance-and-troubleshooting/define-event-filters-for-event-reports

    Hope this helps.

    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 3.  RE: Cannot Generate Reports by selected event ID

    Posted Sep 19, 2019 01:28 PM
    Here, $SPECROOT is the Spectrum installation directory. You need to do this on OneClick server (if it is installed on a separate server).

    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 4.  RE: Cannot Generate Reports by selected event ID

    Posted Sep 30, 2019 04:31 AM
    Hi Rajasekar,

    Thanks for the response.

    What i actually need is, customer has created global collections. when customer try to get report from jespersoft selected global collection it shows may events including 0x10d35 event ID.Customer only want is see the 0x10d35 event ID and they need to schedule it as daily report send to an email. 

    If create as per you said can i do this ? yes spectrum and OneClick both are separate servers. If i try this i have do this in live environment is it ok if try this to create in OC server is there any possibility impact server ??

    Thank you,
    Uchira.   



  • 5.  RE: Cannot Generate Reports by selected event ID

    Posted Sep 30, 2019 06:11 AM
    Yes, that works. Once, you create the XML file at the specified location on the OneClick Server, you can see the XML file name under "Select the Event Types to Include or Exclude list". Also, select Include under "Do you want to include or exclude specific alarm causes".


    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 6.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 01, 2019 03:27 AM
    Hi Rajashekar,

    It's work thank you very much for your support. and i have one more question. Global collection which has in Spectrum it doesn't show. 
    Global Collections
    There's a one  is missing Global collection how can we check that ? missing one has In Spectrum.

    Thank you,
    Uchira.



  • 7.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 01, 2019 09:47 AM
    Edited by Rajashekar Allala Oct 01, 2019 01:51 PM
    Login to OneClick server and navigate to <$SPECROOT>/mysql/bin/ and execute the below commands/query.

    To Login to Reporting DB on Linux server
    ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

    On Windows Server
    <$SPECROOT>/mysql/bin -uroot -proot reporting

    select gc_name from globalcollection where gc_name like '<GC_NAME>%';
    Replace the <GC_NAME> with the global collection name that is missing.

    Once the Query returns the output type exit and press enter to come out of the mysql.

    Is the output showing the GC name?

    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 8.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 01, 2019 01:25 PM
    Edited by Uchira Amarasinghe Oct 01, 2019 01:28 PM
    Hello Rajashekar,

    You are doing grate job.  Thank you very much for your support
     
    Missing GC name is CEYLINKO. And what happen when i try these command in live environment ? 


    Thanks,
    Uchira. 



  • 9.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 01, 2019 01:31 PM
    This will not impact anything. As this is a select query, it will just return the output.

    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 10.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 01, 2019 01:36 PM
    Hello Rajashekar,

    If i change the default GC name to missing GC name what will happen other already showing GC names ? 


    Thank you,
    Uchira.



  • 11.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 01, 2019 01:55 PM
    What is default GC name here?
    Just update the missing GC name "CEYLINKO" to  "CEYLINKO-1" and change the name back to "CEYLINKO". There will be events generating for this GC and this will be updated in reporting DB automatically. Check after few minutes (may be after 30 minutes) in the CABI/Jasper reports and see if the GC name is populating.

    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 12.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 02, 2019 01:38 AM
    Edited by Uchira Amarasinghe Oct 02, 2019 01:42 AM
    Hi Rajashekar,

    I seen there was some changes from OneClick particular GC  and i fix those. is there any way to fast synchronize with jespersoft and one click ? 


    Thanks,
    Uchira. 



  • 13.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 02, 2019 02:40 AM
    Edited by Uchira Amarasinghe Oct 02, 2019 02:41 AM
    Hi Rajashekar,

    I tried below commands that you have given. 

    Login to OneClick server and navigate to <$SPECROOT>/mysql/bin/ and execute the below commands/query.

    To Login to Reporting DB on Linux server
    ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

    On Windows Server
    <$SPECROOT>/mysql/bin -uroot -proot reporting

    select gc_name from globalcollection where gc_name like '<GC_NAME>%';
    Replace the <GC_NAME> with the global collection name that is missing.
    MySQL output
    when i try this output came like this can you help me ?


    ------------------------------------------
    Original Message:
    Sent: 10-02-2019 01:38 AM
    From: Uchira Amarasinghe
    Subject: Cannot Generate Reports by selected event ID

    Hi Rajashekar,

    I seen there was some changes from OneClick particular GC  and i fix those. is there any way to fast synchronize with jespersoft and one click ? 


    Thanks,
    Uchira. 

    Original Message:
    Sent: 10-01-2019 01:54 PM
    From: Rajashekar Allala
    Subject: Cannot Generate Reports by selected event ID

    What is default GC name here?
    Just update the missing GC name "CEYLINKO" to  "CEYLINKO-1" and change the name back to "CEYLINKO". There will be events generating for this GC and this will be updated in reporting DB automatically. Check after few minutes (may be after 30 minutes) in the CABI/Jasper reports and see if the GC name is populating.

    ------------------------------
    Thank you.
    Rajashekar

    Original Message:
    Sent: 10-01-2019 01:36 PM
    From: Uchira Amarasinghe
    Subject: Cannot Generate Reports by selected event ID

    Hello Rajashekar,

    If i change the default GC name to missing GC name what will happen other already showing GC names ? 


    Thank you,
    Uchira.

    Original Message:
    Sent: 10-01-2019 01:31 PM
    From: Rajashekar Allala
    Subject: Cannot Generate Reports by selected event ID

    This will not impact anything. As this is a select query, it will just return the output.

    ------------------------------
    Thank you.
    Rajashekar

    Original Message:
    Sent: 10-01-2019 01:25 PM
    From: Uchira Amarasinghe
    Subject: Cannot Generate Reports by selected event ID

    Hello Rajashekar,

    You are doing grate job.  Thank you very much for your support
     
    Missing GC name is CEYLINKO. And what happen when i try these command in live environment ? 


    Thanks,
    Uchira. 

    Original Message:
    Sent: 10-01-2019 09:46 AM
    From: Rajashekar Allala
    Subject: Cannot Generate Reports by selected event ID

    Login to OneClick server and navigate to <$SPECROOT>/mysql/bin/ and execute the below commands/query.

    To Login to Reporting DB on Linux server
    ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting

    On Windows Server
    <$SPECROOT>/mysql/bin -uroot -proot reporting

    select gc_name from globalcollection where gc_name like '<GC_NAME>%';
    Replace the <GC_NAME> with the global collection name that is missing.

    Is the output showing the GC name?

    ------------------------------
    Thank you.
    Rajashekar

    Original Message:
    Sent: 10-01-2019 03:27 AM
    From: Uchira Amarasinghe
    Subject: Cannot Generate Reports by selected event ID

    Hi Rajashekar,

    It's work thank you very much for your support. and i have one more question. Global collection which has in Spectrum it doesn't show. 
    Global Collections
    There's a one  is missing Global collection how can we check that ? missing one has In Spectrum.

    Thank you,
    Uchira.

    Original Message:
    Sent: 09-30-2019 06:10 AM
    From: Rajashekar Allala
    Subject: Cannot Generate Reports by selected event ID

    Yes, that works. Once, you create the XML file at the specified location on the OneClick Server, you can see the XML file name under "Select the Event Types to Include or Exclude list". Also, select Include under "Do you want to include or exclude specific alarm causes".


    ------------------------------
    Thank you.
    Rajashekar

    Original Message:
    Sent: 09-30-2019 04:31 AM
    From: Uchira Amarasinghe
    Subject: Cannot Generate Reports by selected event ID

    Hi Rajasekar,

    Thanks for the response.

    What i actually need is, customer has created global collections. when customer try to get report from jespersoft selected global collection it shows may events including 0x10d35 event ID.Customer only want is see the 0x10d35 event ID and they need to schedule it as daily report send to an email. 

    If create as per you said can i do this ? yes spectrum and OneClick both are separate servers. If i try this i have do this in live environment is it ok if try this to create in OC server is there any possibility impact server ??

    Thank you,
    Uchira.   

    Original Message:
    Sent: 09-19-2019 01:28 PM
    From: Rajashekar Allala
    Subject: Cannot Generate Reports by selected event ID

    Here, $SPECROOT is the Spectrum installation directory. You need to do this on OneClick server (if it is installed on a separate server).

    ------------------------------
    Thank you.
    Rajashekar

    Original Message:
    Sent: 09-19-2019 01:24 PM
    From: Rajashekar Allala
    Subject: Cannot Generate Reports by selected event ID

    1. Navigate to $SPECROOT/custom/repmgr/config/events/ 
    2. Create an XML file as below (Ex: DeviceDown.xml)

    <?xml version="1.0" encoding="ISO-8859-1"?>
    <filter xmlns="http://www.aprisma.com"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.aprisma.com ./event-filter.xsd">
    <event_type>0x10d35</event_type>
    </filter>

    DeviceDown.xml will be available in the list to select from the reports.

    Below is the link for documentation on the same.
    https://docops.ca.com/ca-spectrum/10-2-3/en/installing-and-upgrading/install-report-manager/maintenance-and-troubleshooting/define-event-filters-for-event-reports

    Hope this helps.

    ------------------------------
    Thank you.
    Rajashekar

    Original Message:
    Sent: 09-19-2019 11:52 AM
    From: Uchira Amarasinghe
    Subject: Cannot Generate Reports by selected event ID

    Hi,

    The customer has a requirement of getting a report filtered with event id 0x10d35 . In the input controls, we saw an option where we can include some attributes, but there are some  .xml files. Please advise a way to do this since this is a bit urgent. waiting for your prompt response.


    Thank you,

    Uchira.



  • 14.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 02, 2019 08:25 AM
    Did you run the below query after connecting to mysql?

    select gc_name from globalcollection where gc_name like '<GC_NAME>%';

    Replace the <GC_NAME> with the global collection name that is missing.


    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 15.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 02, 2019 08:26 AM
    Are you able to see the GC in reports now?

    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 16.  RE: Cannot Generate Reports by selected event ID

    Posted Oct 03, 2019 11:55 PM
    Hi Rajashekar,

    I  ran those command didn't work. what i did was create new GC on OneClick same like missing one, then aftter five min it's shows in jespersoft. now i can get filtered event as per your xml query. but still i have no idea what happen to the missing GC.

    Do i need to run below command after connecting to mysql?

    select gc_name from globalcollection where gc_name like '<GC_NAME>%';

    i think i missed this one.

    Thank  you,
    Uchira.