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.
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.
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-reportsHope 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.