Topic Text   Topic Comments (0)   Topic Properties   Topic Information test@tes...
Topic title: test Wednesday April 21, 2010 15:24:25

Download topic text | View in variable-width font | Tab width set to 4 (change to 8)

Files in topic:  
[Jump to] Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/AlarmManager.java  6018   {+130,-0}
[Jump to] Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/ejb/AlarmSessionBean.java  6018   {+160,-36}
[Jump to] Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/resources/AlarmClassification.xml  0   {+27,-0}
[Jump to] Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/resources/AlarmClassification.xsd  0   {+42,-0}
[Jump to] Fault.FaultManager/DVL/dvl-DefaultQueries.xml  6018   {+7,-9}
[Jump to] Fault.Publisher/src/com/dhyan/nms/server/fault/publisher/EmailPublisherImpl.java  6018   {+11,-0}
[Jump to] Perf.DataCollection/src/com/dhyan/nms/server/performance/datacollection/HistoricalProcessImpl.java  6018   {+1,-3}
[Jump to] Perf.DataCollection/src/com/dhyan/nms/server/performance/datacollection/PerformanceTaskCreator.java  6018   {+17,-8}
[Jump to] Perf.DataCollection/src/com/dhyan/nms/server/performance/datacollection/ejb/DataCollectionFacade.java  6018   {+1,-1}
[Jump to] Perf.PerformanceManager/src/com/dhyan/nms/server/performance/ejb/PerformanceFacade.java  6018   {+1,-0}
[Jump to] Web.BaseModule/WebContent/jsp/DNMSIndex.jsp  6018   {+4,-0}
[Jump to] Web.BaseModule/WebContent/jsp/LoadResourceBundle.jsp  6018   {+0,-1}
[Jump to] Web.BaseModule/WebContent/webresource/webcomponents/table/scripts/VerticalTable.js  6018   {+1,-1}
[Jump to] Web.Chart/WebContent/webresource/chart/flex/src/Linechart.mxml  6018   {+8,-5}
[Jump to] Web.ChassisView/WebContent/resources/conf/MultiChassisView.xml  6018   {+3,-3}
[Jump to] Web.ChassisView/WebContent/webresource/chassisview/scripts/ChassisView.js  6018   {+1,-1}
[Jump to] Web.ChassisView/src/com/dhyan/nms/client/webclient/chassisview/struts/resources/MultiChassisView.xsd  6018   {+6,-6}
[Jump to] Web.Fault/WebContent/WEB-INF/properties/AlarmDetailsAction.properties  6018   {+2,-1}
[Jump to] Web.Fault/WebContent/WEB-INF/struts/struts.xml  6018   {+4,-0}
[Jump to] Web.Fault/WebContent/webresource/fault/scripts/DNMSFault.js  6018   {+2,-2}
[Jump to] Web.Fault/WebContent/webresource/fault/scripts/FaultScriptController.js  6018   {+53,-28}
[Jump to] Web.Fault/WebContent/webresource/fault/scripts/FaultTabUtility.js  6018   {+19,-2}
[Jump to] Web.Fault/src/com/dhyan/nms/client/webclient/fault/struts/AlarmDetailsAction.java  6018   {+39,-3}
[Jump to] Web.Performance/WebContent/webresource/dashboard/scripts/DashboardConfigurator.js  6018   {+5,-5}
[Jump to] Web.Security/WebContent/webresource/security/scripts/SecurityUserManager.js  6018   {+1,-1}
[Jump to] Web.Topology/WebContent/WEB-INF/properties/resource.properties  6018   {+1,-1}
[Jump to] Web.Topology/WebContent/WEB-INF/properties/resourcegroup.properties  6018   {+1,-0}
[Jump to] Web.Topology/WebContent/webresource/topology/scripts/ResourceTreeManager.js  6018   {+11,-5}
[Jump to] Web.Topology/WebContent/webresource/topology/scripts/TopologyMapHelper.js  6018   {+8,-1}
[Jump to] dnms/resources/dbspecific/derby/schema/dnms_common.sql  6018   {+1,-1}
[Jump to] dnms/resources/dbspecific/derby/schema/dnms_default_records.sql  6018   {+1,-1}
[Jump to] dnms/resources/dbspecific/mysql/schema/dnms_common.sql  6018   {+1,-1}
[Jump to] dnms/resources/dbspecific/mysql/schema/dnms_default_records.sql  6018   {+1,-1}
[Jump to] dnms/resources/dbspecific/oracle/schema/dnms_common.sql  6018   {+1,-1}
[Jump to] dnms/resources/dbspecific/oracle/schema/dnms_default_records.sql  6018   {+1,-1}

[Add General Comment] to topic.

File Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/AlarmManager.java (Revision 6018) [Add File Comment] [Top] [>>]
 
Line 28 | Parallel Line 28 | Parallel
28 import com.dnms.source.com.dhyan.nms.server.fault.resources.alarmcorreltion.Matchingfields; 28 import com.dnms.source.com.dhyan.nms.server.fault.resources.alarmcorreltion.Matchingfields;
29 import com.dnms.source.com.dhyan.nms.server.fault.resources.alarmpublish.Alarmpublish; 29 import com.dnms.source.com.dhyan.nms.server.fault.resources.alarmpublish.Alarmpublish;
30 import com.dnms.source.com.dhyan.nms.server.fault.resources.alarmpublish.AlarmpublishDocument; 30 import com.dnms.source.com.dhyan.nms.server.fault.resources.alarmpublish.AlarmpublishDocument;
31 import com.dnms.source.com.dhyan.nms.server.fault.resources.classificationdetails.AlarmClassification;
32 import com.dnms.source.com.dhyan.nms.server.fault.resources.classificationdetails.AlarmClassificationDocument;
33 import com.dnms.source.com.dhyan.nms.server.fault.resources.classificationdetails.Alarmspecification;
34 import com.dnms.source.com.dhyan.nms.server.fault.resources.classificationdetails.FieldDetails;
35 import com.dnms.source.com.dhyan.nms.server.fault.resources.classificationdetails.MappingDetails;
31 36
32 public final class AlarmManager 37 public final class AlarmManager
33 { 38 {
 
 
Line 41 | Parallel Line 46 | Parallel
41 private String remedyHandling; 46 private String remedyHandling;
42 private ArrayList<String> publishFieldList = null; 47 private ArrayList<String> publishFieldList = null;
43 private boolean publishClearedAlarms = false; 48 private boolean publishClearedAlarms = false;
49 private Alarmspecification[] alarmSpecList = null;
44 50
45 /** 51 /**
46 * No-args constructor. All the member variables are initialized. 52 * No-args constructor. All the member variables are initialized.
 
 
Line 54 | Parallel Line 60 | Parallel
54 loadAlarmCorrelator(); 60 loadAlarmCorrelator();
55 parseAlarmCorrelation(); 61 parseAlarmCorrelation();
56 loadPublishersFields(); 62 loadPublishersFields();
63 parseAlarmClassification();
57 } 64 }
58 65
59 /** 66 /**
 
 
Line 95 | Parallel Line 102 | Parallel
95 } 102 }
96 } 103 }
97 104
105 private void parseAlarmClassification()
106 {
107 try
108 {
109 AlarmClassificationDocument document =
110 AlarmClassificationDocument.Factory.parse(AlarmManager.class.getResource("resources/AlarmClassification.xml"));
111 if (document != null)
112 {
113 AlarmClassification alarm_classification = document.getAlarmClassification();
114 alarmSpecList = alarm_classification.getAlarmspecificationArray();
115 }
116 }
117 catch (Exception e)
118 {
119 LOG.error("Exception occured while reading alarmcorrelationfieldmapping.xml file" + e.getMessage());
120 }
121 }
122
123 /**
124 * Method to retrieve trap details based on given alarm information.
125 * @param alarmDetails alarmDetails
126 * @return Trap
127 * @throws Exception Exception
128 */
129 public boolean isDeviceAlarm(final Alarm alarmDetails) throws Exception
130 {
131 try
132 {
133 if (alarmSpecList != null && alarmSpecList.length > 0)
134 {
135 for (Alarmspecification alarm_value : alarmSpecList)
136 {
137 if (alarm_value.getType().trim().equalsIgnoreCase("DEVICE"))
138 {
139 return isMatchingAlarmDetails(alarm_value.getMappingDetailsArray(), alarmDetails);
140 }
141 }
142 }
143 else
144 {
145 throw new Exception("Problem in getting alarm specification details. Classification details not found");
146 }
147 }
148 catch (Exception e)
149 {
150 LOG.error("Exception occured while getting TrapDetails " + e.getMessage());
151 }
152 return false;
153 }
154
155 /**
156 * Method to retrieve trap details based on given alarm information.
157 * @param alarmDetails alarmDetails
158 * @return Trap
159 * @throws Exception Exception
160 */
161 public String getAlarmSpecificationType(final Alarm alarmDetails) throws Exception
162 {
163 try
164 {
165 if (alarmSpecList != null && alarmSpecList.length > 0)
166 {
167 boolean isMatch = false;
168 for (Alarmspecification alarm_value : alarmSpecList)
169 {
170 isMatch = isMatchingAlarmDetails(alarm_value.getMappingDetailsArray(), alarmDetails);
171 if (isMatch)
172 {
173 return alarm_value.getDisplayName();
174 }
175 }
176 }
177 else
178 {
179 throw new Exception("Problem in getting alarm specification details. Classification details not found");
180 }
181 }
182 catch (Exception e)
183 {
184 LOG.error("Exception occured while getting TrapDetails " + e.getMessage());
185 }
186 return null;
187 }
188
189 private boolean isMatchingAlarmDetails(final MappingDetails[] mappingFields, final Alarm alarmDetails)
190 {
191 if (mappingFields != null && mappingFields.length > 0)
192 {
193 MappingDetails mapping_field = mappingFields[0];
194 boolean isFieldMapped = true;
195 String expectedValue = null;
196 String actualObject = null;
197 for (FieldDetails field_list : mapping_field.getFieldDetailsArray())
198 {
199 expectedValue = field_list.getValue();
200 actualObject = alarmDetails.get(field_list.getName());
201 if (expectedValue == null || actualObject == null)
202 {
203 isFieldMapped = false;
204 break;
205 }
206 if (field_list.getOperation().toString().equalsIgnoreCase("EQUALS"))
207 {
208 if (!expectedValue.trim().equalsIgnoreCase(actualObject.toString()))
209 {
210 isFieldMapped = false;
211 break;
212 }
213 }
214 else
215 {
216 if (expectedValue.trim().equalsIgnoreCase(actualObject.toString()))
217 {
218 isFieldMapped = false;
219 break;
220 }
221 }
222 }
223 return isFieldMapped;
224 }
225 return false;
226 }
227
98 private AbstractAlarmCorrelator getAlarmCorrelatorIfc(final String correlatorClassName) 228 private AbstractAlarmCorrelator getAlarmCorrelatorIfc(final String correlatorClassName)
99 { 229 {
100 AbstractAlarmCorrelator correlatorIfc = null; 230 AbstractAlarmCorrelator correlatorIfc = null;
 
File Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/ejb/AlarmSessionBean.java (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 28 | Parallel Line 28 | Parallel
28 28
29 import com.dhyan.component.audittrial.interfaces.AuditTrailFacadeLocal; 29 import com.dhyan.component.audittrial.interfaces.AuditTrailFacadeLocal;
30 import com.dhyan.component.dvl.core.DVLTableData; 30 import com.dhyan.component.dvl.core.DVLTableData;
31 import com.dhyan.component.dvl.exporter.DVLExportManager;
31 import com.dhyan.component.dvl.exporter.DVLExporterConstants; 32 import com.dhyan.component.dvl.exporter.DVLExporterConstants;
32 import com.dhyan.component.dvl.exporter.DVLExporterVO; 33 import com.dhyan.component.dvl.exporter.DVLExporterVO;
33 import com.dhyan.component.security.RoleConstants; 34 import com.dhyan.component.security.RoleConstants;
 
 
Line 81 | Parallel Line 82 | Parallel
81 private static final String SEVERITY_ID = "severityid"; 82 private static final String SEVERITY_ID = "severityid";
82 private static final String SEVERITY = "severity"; 83 private static final String SEVERITY = "severity";
83 private static final String SOURCE_MESSAGE = " Source:"; 84 private static final String SOURCE_MESSAGE = " Source:";
84 private static final String DELETE_COMMONQUERY = "DELETE FROM ALARM WHERE severityid = " + AlarmConstants.CLEARED_ID; 85 private static final String DELETE_COMMONQUERY =
85 private static final String ARCHIVE_WHERECONDITION = 86 "DELETE alm , evnt " + " FROM ALARM as alm , EVENTLOGS as evnt , EVENTALARMMAPPING as mapping" + " where alm.severityid = "
86 " WHERE a.severityid = s.severityid AND a.eventtypeid = e.eventtypeid AND" + " rd.resourceid = a.resourceid AND a.severityid = " 87 + AlarmConstants.CLEARED_ID + " AND alm.alarmid = mapping.alarmid" + " AND mapping.eventid = evnt.eventid ";
87 + AlarmConstants.CLEARED_ID;
88 private static final String ARCHIVE_SELECTQUERY =
89 "SELECT alarmid,e.eventtype as eventtype,s.severity as severity,source,rd.resourcename as resourcename,"
90 + "componentid,category,createdtime,updatedtime,owner,ackstatus,acktime,clearedtime,message,remedy,a.version as version "
91 + "FROM ALARM a,RESOURCEDETAILS rd,SEVERITY s, EVENTTYPE e";
92 private static final String ARCHIVE_COMMONQUERY = ARCHIVE_SELECTQUERY + ARCHIVE_WHERECONDITION;
93 88
89 private static final String ALARM_ARCHIVE_COMMONQUERY =
90 "SELECT alm.alarmid as alarmid, "
91 + " evntype.eventtype as eventtype, svty.severity as severity, alm.source as source, resource.resourcename as resourcename, "
92 + " alm.componentid as componentid, alm.category as category, alm.createdtime as createdtime, alm.updatedtime as updatedtime, "
93 + " alm.owner as owner, alm.ackstatus as ackstatus, alm.acktime as acktime, alm.clearedtime as clearedtime, "
94 + " alm.message as message, alm.remedy as remedy, alm.version as version "
95 + " FROM ALARM as alm , EVENTTYPE as evntype , RESOURCEDETAILS as resource ,SEVERITY as svty " + " where alm.severityid = "
96 + AlarmConstants.CLEARED_ID + " AND resource.resourceid = alm.resourceid " + " AND evntype.eventtypeid = alm.eventtypeid "
97 + " AND svty.severityid =alm.severityid ";
98
99 private static final String EVENTLOGS_ARCHIVE_COMMONQUERY =
100 "SELECT evnt.eventid as eventid, " + " evntype.eventtype as eventtype,svty.severity as severity,evnt.source,evnt.category, "
101 + " resource.resourcename as resourcename,evnt.componentid,evnt.eventtime as eventtime, "
102 + " evnt.message as message,evnt.remedy as remedy,evnt.version as version FROM "
103 + " EVENTLOGS evnt,ALARM as alm, EVENTALARMMAPPING as mapping,EVENTTYPE evntype, SEVERITY svty,RESOURCEDETAILS resource "
104 + " WHERE evnt.eventtypeid != 4 AND evntype.eventtypeid = evnt.eventtypeid "
105 + " AND evnt.severityid=svty.severityid AND resource.resourceid = evnt.resourceid " + " AND alm.alarmid = mapping.alarmid"
106 + " AND mapping.eventid = evnt.eventid " + " AND alm.severityid = " + AlarmConstants.CLEARED_ID;
107
94 private static final String GLOBAL = "global"; 108 private static final String GLOBAL = "global";
95 private static final String CLOSE_BRACKET = ")"; 109 private static final String CLOSE_BRACKET = ")";
96 private static final String ALARM_CLEARED_MESSAGE = "Alarm Updated : Cleared - Id:"; 110 private static final String ALARM_CLEARED_MESSAGE = "Alarm Updated : Cleared - Id:";
 
 
Line 1133 | Parallel Line 1147 | Parallel
1133 @RolesAllowed("DEFAULT_ROLE_FOR_SERVER") 1147 @RolesAllowed("DEFAULT_ROLE_FOR_SERVER")
1134 public final void purgeAllAlarms(final boolean cleared, final DVLExporterVO exporterVO) 1148 public final void purgeAllAlarms(final boolean cleared, final DVLExporterVO exporterVO)
1135 { 1149 {
1136 String deleteQuery; 1150 String deleteQuery = null;
1137 String archiveQuery; 1151 String alarmArchiveQuery = null;
1152 String eventLogsArchiveQuery = null;
1138 if (cleared) 1153 if (cleared)
1139 { 1154 {
1140 deleteQuery = DELETE_COMMONQUERY; 1155 deleteQuery = DELETE_COMMONQUERY;
1141 archiveQuery = ARCHIVE_COMMONQUERY; 1156 alarmArchiveQuery = ALARM_ARCHIVE_COMMONQUERY;
1157 eventLogsArchiveQuery = EVENTLOGS_ARCHIVE_COMMONQUERY;
1142 } 1158 }
1143 else 1159 // else
1160 // {
1161 // deleteQuery = "DELETE FROM ALARM";
1162 // archiveQuery = ARCHIVE_SELECTQUERY +
1163 // " WHERE a.severityid = s.severityid AND a.eventtypeid = e.eventtypeid AND rd.resourceid = a.resourceid";
1164 // }
1165 DVLExporterVO exporterVOLocal = exporterVO;
1166 if (exporterVOLocal == null)
1144 { 1167 {
1145 deleteQuery = "DELETE FROM ALARM"; 1168 exporterVOLocal = new DVLExporterVO();
1146 archiveQuery = ARCHIVE_SELECTQUERY + " WHERE a.severityid = s.severityid AND a.eventtypeid = e.eventtypeid AND rd.resourceid = a.resourceid"; 1169 exporterVOLocal.setExporterId(DVLExporterConstants.LOG_EXPORTER_ID);
1170 exporterVOLocal.setExportType(DVLExporterConstants.WHOLEVIEW);
1171 exporterVOLocal.setFileName(AlarmConstants.ALARM);
1172 exporterVOLocal.setFileType(Constants.CSV_EXPORT);
1173 exporterVOLocal.setDvlQuerryId(DVLExporterConstants.ARCHIVE_QUERY_ID);
1147 } 1174 }
1148 purge(deleteQuery, archiveQuery, -1, exporterVO); 1175 DVLExportManager.getInstance().exportData(eventLogsArchiveQuery, -1, exporterVOLocal);
1176 purge(deleteQuery, alarmArchiveQuery, -1, exporterVO, true);
1149 } 1177 }
1150 1178
1151 /** 1179 /**
 
 
Line 1157 | Parallel Line 1185 | Parallel
1157 @RolesAllowed("DEFAULT_ROLE_FOR_SERVER") 1185 @RolesAllowed("DEFAULT_ROLE_FOR_SERVER")
1158 public final void purgeAlarmsByInterval(final int filterId, final DVLExporterVO exporterVO, final long timeinterval) 1186 public final void purgeAlarmsByInterval(final int filterId, final DVLExporterVO exporterVO, final long timeinterval)
1159 { 1187 {
1160 String deleteQuery = DELETE_COMMONQUERY + " and updatedtime <= " + (System.currentTimeMillis() - timeinterval); 1188
1161 String archiveQuery = ARCHIVE_COMMONQUERY + " and updatedtime <= " + (System.currentTimeMillis() - timeinterval); 1189 String deleteQuery = DELETE_COMMONQUERY + " AND alm.updatedtime <= " + (System.currentTimeMillis() - timeinterval);
1162 purge(deleteQuery, archiveQuery, filterId, exporterVO); 1190 String alarmArchiveQuery = ALARM_ARCHIVE_COMMONQUERY + " AND alm.updatedtime <= " + (System.currentTimeMillis() - timeinterval);
1191 String eventLogsArchiveQuery = EVENTLOGS_ARCHIVE_COMMONQUERY + " AND alm.updatedtime <= " + (System.currentTimeMillis() - timeinterval);
1192 DVLExporterVO exporterVOLocal = exporterVO;
1193 if (exporterVOLocal == null)
1194 {
1195 exporterVOLocal = new DVLExporterVO();
1196 exporterVOLocal.setExporterId(DVLExporterConstants.LOG_EXPORTER_ID);
1197 exporterVOLocal.setExportType(DVLExporterConstants.WHOLEVIEW);
1198 exporterVOLocal.setFileName(AlarmConstants.ALARM);
1199 exporterVOLocal.setFileType(Constants.CSV_EXPORT);
1200 exporterVOLocal.setDvlQuerryId(DVLExporterConstants.ARCHIVE_QUERY_ID);
1163 } 1201 }
1202 DVLExportManager.getInstance().exportData(eventLogsArchiveQuery, -1, exporterVOLocal);
1203 purge(deleteQuery, alarmArchiveQuery, filterId, exporterVO, true);
1204 }
1164 1205
1165 /** 1206 /**
1166 * To purge the alarms by time interval, filter id and exporter. 1207 * To purge the alarms by time interval, filter id and exporter.
 
 
Line 1171 | Parallel Line 1212 | Parallel
1171 @RolesAllowed("DEFAULT_ROLE_FOR_SERVER") 1212 @RolesAllowed("DEFAULT_ROLE_FOR_SERVER")
1172 public final void purgeAlarmsByCount(final int filterId, final DVLExporterVO exporterVO, final long retainCount) 1213 public final void purgeAlarmsByCount(final int filterId, final DVLExporterVO exporterVO, final long retainCount)
1173 { 1214 {
1174 String commonQuery; 1215 try
1175 String deleteQuery = null; 1216 {
1176 String archiveQuery = null; 1217 StringBuilder deleteQuery = new StringBuilder();
1218 StringBuilder deleteQuery1 = new StringBuilder();
1219 StringBuilder alarmArchiveQuery = new StringBuilder();
1220 StringBuilder eventLogsArchiveQuery = new StringBuilder();
1177 long purgeCount = getAllAlarmsCount() - retainCount; 1221 long purgeCount = getAllAlarmsCount() - retainCount;
1178 if (purgeCount < 1) 1222 if (purgeCount < 1)
1179 { 1223 {
1180 return; 1224 return;
1181 } 1225 }
1182 commonQuery = " order by updatedtime ";
1183 if (ServerSettings.getDatabase() == ServerSettings.MYSQL) 1226 if (ServerSettings.getDatabase() == ServerSettings.MYSQL)
1184 { 1227 {
1185 deleteQuery = DELETE_COMMONQUERY + commonQuery + LIMIT + purgeCount; 1228 deleteQuery.append(" DELETE alm , evnt ");
1186 archiveQuery = ARCHIVE_COMMONQUERY + LIMIT + purgeCount; 1229 deleteQuery.append(" FROM ALARM as alm , ");
1230 deleteQuery.append("(SELECT alarmid from ALARM where severityid = " + AlarmConstants.CLEARED_ID + " ORDER BY updatedtime LIMIT "
1231 + purgeCount + " ) as limitedAlarm ,");
1232 deleteQuery.append(" EVENTLOGS as evnt , EVENTALARMMAPPING as mapping ");
1233 deleteQuery.append(" where alm.alarmid = limitedAlarm.alarmid ");
1234 deleteQuery.append(" AND alm.alarmid = mapping.alarmid");
1235 deleteQuery.append(" AND mapping.eventid = evnt.eventid");
1236
1237 alarmArchiveQuery.append("SELECT alm.alarmid as alarmid, ");
1238 alarmArchiveQuery
1239 .append(" evntype.eventtype as eventtype, svty.severity as severity, alm.source as source, resource.resourcename as resourcename, ");
1240 alarmArchiveQuery
1241 .append(" alm.componentid as componentid, alm.category as category, alm.createdtime as createdtime, alm.updatedtime as updatedtime, ");
1242 alarmArchiveQuery.append(" alm.owner as owner, alm.ackstatus as ackstatus, alm.acktime as acktime, alm.clearedtime as clearedtime, ");
1243 alarmArchiveQuery.append(" alm.message as message, alm.remedy as remedy, alm.version as version ");
1244 alarmArchiveQuery.append(" FROM ALARM as alm , EVENTTYPE as evntype , RESOURCEDETAILS as resource ,SEVERITY as svty, ");
1245 alarmArchiveQuery.append(" (SELECT alarmid from ALARM where severityid = " + AlarmConstants.CLEARED_ID + " ORDER BY updatedtime LIMIT "
1246 + purgeCount + " ) as limitedAlarm ");
1247 alarmArchiveQuery.append(" WHERE resource.resourceid = alm.resourceid ");
1248 alarmArchiveQuery.append(" AND evntype.eventtypeid = alm.eventtypeid ");
1249 alarmArchiveQuery.append(" AND svty.severityid =alm.severityid ");
1250 alarmArchiveQuery.append(" AND alm.alarmid = limitedAlarm.alarmid ");
1251
1252 eventLogsArchiveQuery.append("SELECT evnt.eventid as eventid, ");
1253 eventLogsArchiveQuery.append(" evntype.eventtype as eventtype,svty.severity as severity,evnt.source,evnt.category, ");
1254 eventLogsArchiveQuery.append(" resource.resourcename as resourcename,evnt.componentid,evnt.eventtime as eventtime, ");
1255 eventLogsArchiveQuery.append(" evnt.message as message,evnt.remedy as remedy,evnt.version as version FROM ");
1256 eventLogsArchiveQuery.append(" EVENTLOGS evnt, EVENTALARMMAPPING as mapping,EVENTTYPE evntype, SEVERITY svty,RESOURCEDETAILS resource, ");
1257 eventLogsArchiveQuery.append(" (SELECT alarmid from ALARM where severityid = " + AlarmConstants.CLEARED_ID + " ORDER BY updatedtime LIMIT "
1258 + purgeCount + " ) as limitedAlarm ");
1259 eventLogsArchiveQuery.append(" WHERE evnt.eventtypeid != 4 AND evntype.eventtypeid = evnt.eventtypeid ");
1260 eventLogsArchiveQuery.append(" AND evnt.severityid=svty.severityid AND resource.resourceid = evnt.resourceid ");
1261 eventLogsArchiveQuery.append(" AND limitedAlarm.alarmid = mapping.alarmid");
1262 eventLogsArchiveQuery.append(" AND mapping.eventid = evnt.eventid ");
1187 } 1263 }
1188 else if (ServerSettings.getDatabase() == ServerSettings.ORACLE) 1264 else if (ServerSettings.getDatabase() == ServerSettings.ORACLE)
1189 { 1265 {
1190 deleteQuery = 1266
1191 "DELETE FROM ALARM where alarmid IN (SELECT alarmid FROM (SELECT * FROM ALARM order by updatedtime ) WHERE rownum <= " + purgeCount 1267 deleteQuery.append(" DELETE FROM EVENTLOGS where eventid IN ");
1192 + CLOSE_BRACKET + " and severityid = " + AlarmConstants.CLEARED_ID; 1268 deleteQuery.append(" (SELECT evnt.eventid FROM ALARM alm , ");
1193 archiveQuery = 1269 deleteQuery.append("(SELECT alarmid from ALARM where severityid = " + AlarmConstants.CLEARED_ID + " AND rownum <= " + purgeCount
1194 ARCHIVE_SELECTQUERY + " where alarmid IN (SELECT alarmid FROM (SELECT * FROM ALARM order by updatedtime ) WHERE rownum <= " + purgeCount 1270 + " ORDER BY updatedtime) limitedAlarm ,");
1195 + CLOSE_BRACKET + " and a.severityid = " + AlarmConstants.CLEARED_ID 1271 deleteQuery.append(" EVENTLOGS evnt , EVENTALARMMAPPING mapping ");
1196 + " and a.severityid=s.severityid and a.eventtypeid = e.eventtypeid and a.resourceid = rd.resourceid"; 1272 deleteQuery.append(" where alm.alarmid = limitedAlarm.alarmid ");
1273 deleteQuery.append(" AND alm.alarmid = mapping.alarmid AND evnt.eventid=mapping.eventid)");
1274
1275 deleteQuery1.append("DELETE FROM ALARM where severityid = 1 AND rownum <= 2 ORDER BY updatedtime");
1276 alarmArchiveQuery.append(" SELECT alm.alarmid as alarmid, ");
1277 alarmArchiveQuery.append(" evntype.eventtype as eventtype, svty.severity as severity, alm.source as source, r.resourcename as resourcename, ");
1278 alarmArchiveQuery
1279 .append(" alm.componentid as componentid, alm.category as category, alm.createdtime as createdtime, alm.updatedtime as updatedtime, ");
1280 alarmArchiveQuery.append(" alm.owner as owner, alm.ackstatus as ackstatus, alm.acktime as acktime, alm.clearedtime as clearedtime, ");
1281 alarmArchiveQuery.append(" alm.message as message, alm.remedy as remedy, alm.version as version ");
1282 alarmArchiveQuery.append(" FROM ALARM alm , EVENTTYPE evntype , RESOURCEDETAILS r ,SEVERITY svty, ");
1283 alarmArchiveQuery.append(" (SELECT alarmid from ALARM where severityid = " + AlarmConstants.CLEARED_ID + " AND rownum <= " + purgeCount
1284 + " ORDER BY updatedtime) limitedAlarm ");
1285 alarmArchiveQuery.append(" WHERE r.resourceid = alm.resourceid ");
1286 alarmArchiveQuery.append(" AND evntype.eventtypeid = alm.eventtypeid ");
1287 alarmArchiveQuery.append(" AND svty.severityid =alm.severityid ");
1288 alarmArchiveQuery.append(" AND alm.alarmid = limitedAlarm.alarmid ");
1289
1290 eventLogsArchiveQuery.append("SELECT evnt.eventid as eventid, ");
1291 eventLogsArchiveQuery.append(" evntype.eventtype as eventtype,svty.severity as severity,evnt.source,evnt.category, ");
1292 eventLogsArchiveQuery.append(" r.resourcename as resourcename,evnt.componentid,evnt.eventtime as eventtime, ");
1293 eventLogsArchiveQuery.append(" evnt.message as message,evnt.remedy as remedy,evnt.version as version FROM ");
1294 eventLogsArchiveQuery.append(" EVENTLOGS evnt, EVENTALARMMAPPING mapping,EVENTTYPE evntype, SEVERITY svty,RESOURCEDETAILS r, ");
1295 eventLogsArchiveQuery.append(" (SELECT alarmid from ALARM where severityid ");
1296 eventLogsArchiveQuery.append(" = " + AlarmConstants.CLEARED_ID + " AND rownum <= " + purgeCount);
1297 eventLogsArchiveQuery.append(" ORDER BY updatedtime) limitedAlarm ");
1298 eventLogsArchiveQuery.append(" WHERE evnt.eventtypeid != 4 AND evntype.eventtypeid = evnt.eventtypeid ");
1299 eventLogsArchiveQuery.append(" AND evnt.severityid=svty.severityid AND r.resourceid = evnt.resourceid ");
1300 eventLogsArchiveQuery.append(" AND limitedAlarm.alarmid = mapping.alarmid");
1301 eventLogsArchiveQuery.append(" AND mapping.eventid = evnt.eventid ");
1197 } 1302 }
1198 purge(deleteQuery, archiveQuery, filterId, exporterVO); 1303 DVLExporterVO exporterVOLocal = exporterVO;
1304 if (exporterVOLocal == null)
1305 {
1306 exporterVOLocal = new DVLExporterVO();
1307 exporterVOLocal.setExporterId(DVLExporterConstants.LOG_EXPORTER_ID);
1308 exporterVOLocal.setExportType(DVLExporterConstants.WHOLEVIEW);
1309 exporterVOLocal.setFileName(AlarmConstants.ALARM);
1310 exporterVOLocal.setFileType(Constants.CSV_EXPORT);
1311 exporterVOLocal.setDvlQuerryId(DVLExporterConstants.ARCHIVE_QUERY_ID);
1199 } 1312 }
1313 DVLExportManager.getInstance().exportData(eventLogsArchiveQuery.toString(), -1, exporterVOLocal);
1314 purge(deleteQuery.toString(), alarmArchiveQuery.toString(), filterId, exporterVO, true);
1315 if (ServerSettings.getDatabase() == ServerSettings.ORACLE)
1316 {
1317 purge(deleteQuery1.toString(), alarmArchiveQuery.toString(), filterId, exporterVO, false);
1318 }
1319 }
1320 catch (Exception e)
1321 {
1322 LOG.error("ERROR in purgeAlarmsByCount due to , " + e.getMessage());
1323 }
1324 }
1200 1325
1201 /** 1326 /**
1202 * To fetch the alarm count 1327 * To fetch the alarm count
 
 
Line 1265 | Parallel Line 1390 | Parallel
1265 return false; 1390 return false;
1266 } 1391 }
1267 1392
1268 private void purge(final String purgingQuery, final String archivingQuery, final int filterId, final DVLExporterVO exporterVO) 1393 private void purge(final String purgingQuery, final String archivingQuery, final int filterId, final DVLExporterVO exporterVO, final boolean isArchive)
1269 { 1394 {
1270 DVLExporterVO exporterVOLocal = exporterVO; 1395 DVLExporterVO exporterVOLocal = exporterVO;
1271 1396
 
 
Line 1286 | Parallel Line 1411 | Parallel
1286 exporterVOLocal.setFileType(Constants.CSV_EXPORT); 1411 exporterVOLocal.setFileType(Constants.CSV_EXPORT);
1287 exporterVOLocal.setDvlQuerryId(DVLExporterConstants.ARCHIVE_QUERY_ID); 1412 exporterVOLocal.setDvlQuerryId(DVLExporterConstants.ARCHIVE_QUERY_ID);
1288 } 1413 }
1289
1290 messObject.setExporterVO(exporterVOLocal); 1414 messObject.setExporterVO(exporterVOLocal);
1291 Thread thread = new Thread(new PurgeAndArchiveOperation(messObject, true)); 1415 Thread thread = new Thread(new PurgeAndArchiveOperation(messObject, isArchive));
1292 thread.start(); 1416 thread.start();
1293 } 1417 }
1294 1418
 
File Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/resources/AlarmClassification.xml (Revision 0) [Add File Comment] [<<] [Top] [>>]
 
1 <?xml version="1.0" encoding="UTF-8"?>
2 <AlarmClassification xmlns="http://www.dnms.com/source/com/dhyan/nms/server/fault/resources/Classificationdetails">
3
4 <!-- Details to identify an alarm -->
5
6 <Alarmspecification type="Device" displayName = "Network Element" >
7 <MappingDetails>
8 <FieldDetails name="eventtypeid" value="1" operation="NOTEQUALS"/>
9 <FieldDetails name="eventtypeid" value="3" operation="NOTEQUALS"/>
10 <FieldDetails name="eventtypeid" value="4" operation="NOTEQUALS"/>
11 <FieldDetails name="eventtypeid" value="5" operation="NOTEQUALS"/>
12 <FieldDetails name="eventtypeid" value="6" operation="NOTEQUALS"/>
13 <FieldDetails name="eventtypeid" value="7" operation="NOTEQUALS"/>
14 <FieldDetails name="eventtypeid" value="8" operation="NOTEQUALS"/>
15 <FieldDetails name="eventtypeid" value="9" operation="NOTEQUALS"/>
16 <FieldDetails name="eventtypeid" value="10" operation="NOTEQUALS"/>
17 </MappingDetails>
18 </Alarmspecification>
19 <Alarmspecification type="EMS" displayName = "EMS Server" >
20 <MappingDetails>
21 <FieldDetails name="eventtypeid" value="2" operation="NOTEQUALS"/>
22 <FieldDetails name="eventtypeid" value="11" operation="NOTEQUALS"/>
23 <FieldDetails name="eventtypeid" value="12" operation="NOTEQUALS"/>
24 </MappingDetails>
25 </Alarmspecification>
26
27 </AlarmClassification>
 
File Fault.AlarmManager/src/com/dhyan/nms/server/fault/alarmmanager/resources/AlarmClassification.xsd (Revision 0) [Add File Comment] [<<] [Top] [>>]
 
1 <?xml version="1.0"?>
2 <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
3 targetNamespace="http://www.dnms.com/source/com/dhyan/nms/server/fault/resources/Classificationdetails"
4 elementFormDefault="qualified"
5 xmlns:AlarmFormatterdetailsNS="http://www.dnms.com/source/com/dhyan/nms/server/fault/resources/Classificationdetails">
6
7 <xs:element name="AlarmClassification" type="AlarmFormatterdetailsNS:AlarmClassification"/>
8
9 <xs:complexType name="AlarmClassification">
10 <xs:sequence>
11 <xs:element name="Alarmspecification" type="AlarmFormatterdetailsNS:Alarmspecification" minOccurs="0" maxOccurs="unbounded"/>
12 </xs:sequence>
13 </xs:complexType>
14
15 <xs:complexType name="Alarmspecification">
16 <xs:sequence>
17 <xs:element name="MappingDetails" type="AlarmFormatterdetailsNS:MappingDetails" minOccurs="0" maxOccurs="unbounded"/>
18 </xs:sequence>
19 <xs:attribute name="type" type="xs:string" use="required"/>
20 <xs:attribute name="displayName" type="xs:string" use="required"/>
21 </xs:complexType>
22
23 <xs:complexType name="MappingDetails">
24 <xs:sequence>
25 <xs:element name="FieldDetails" type="AlarmFormatterdetailsNS:FieldDetails" minOccurs="1" maxOccurs="unbounded"/>
26 </xs:sequence>
27 </xs:complexType>
28
29 <xs:complexType name="FieldDetails">
30 <xs:attribute name="name" type="xs:string" use="required"/>
31 <xs:attribute name="value" type="xs:string" use="required"/>
32 <xs:attribute name="operation" type="AlarmFormatterdetailsNS:operationType" use="required"/>
33 </xs:complexType>
34
35 <xs:simpleType name="operationType">
36 <xs:restriction base="xs:string">
37 <xs:enumeration value="EQUALS" />
38 <xs:enumeration value="NOTEQUALS" />
39 </xs:restriction>
40 </xs:simpleType>
41
42 </xs:schema>
 
File Fault.FaultManager/DVL/dvl-DefaultQueries.xml (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 104 | Parallel Line 104 | Parallel
104 a.alarmid as alarmid,e.eventtype as eventtype, e.eventtypeid as eventtypeid,s.severity as severity,s.severity as severityname, 104 a.alarmid as alarmid,e.eventtype as eventtype, e.eventtypeid as eventtypeid,s.severity as severity,s.severity as severityname,
105 rd.resourceid as resourceid, rd.resourcename as qf_resourcename,a.source as qf_source, rd.resourcename as resourcename,a.source as source, a.createdtime as createdtime,a.updatedtime as updatedtime, 105 rd.resourceid as resourceid, rd.resourcename as qf_resourcename,a.source as qf_source, rd.resourcename as resourcename,a.source as source, a.createdtime as createdtime,a.updatedtime as updatedtime,
106 a.acktime as acktime,a.clearedtime as clrdtime,a.owner as owner,a.ackstatus as ack, 106 a.acktime as acktime,a.clearedtime as clrdtime,a.owner as owner,a.ackstatus as ack,
107 a.message as msg,a.remedy as remedy,a.optionalfield as optionalfield,a.category as category,a.version as version,rc.component_index as compindex, 107 a.message as msg,a.remedy as remedy,a.category as category,a.version as version,rc.component_index as compindex,
108 cd.colorname as color,a.severityid as severityid 108 cd.colorname as color,s.severityid as severityid
109 FROM 109 FROM
110 SEVERITY s, EVENTTYPE e, COLORDETAILS cd, RESOURCEDETAILS rd, ALARMARCHIVE a left join 110 SEVERITY s, EVENTTYPE e, COLORDETAILS cd, RESOURCEDETAILS rd, ALARMARCHIVE a left join
111 RESOURCECOMPONENT rc on rc.componentid = a.componentid 111 RESOURCECOMPONENT rc on rc.componentid = a.componentid
112 WHERE 112 WHERE
113 (s.severitycolorid = cd.colorid and a.severityid = s.severityid and 113 (s.severitycolorid = cd.colorid and a.severity = s.severity and
114 a.eventtypeid = e.eventtypeid and rd.resourceid = a.resourceid) 114 a.eventtype = e.eventtype and rd.resourcename = a.resourcename)
115 /~alarmid: a.alarmid {alarmid}~/ 115 /~alarmid: a.alarmid {alarmid}~/
116 /~eventtype: upper(e.eventtype) {eventtype}~/ 116 /~eventtype: upper(e.eventtype) {eventtype}~/
117 /~eventtypeid: upper(e.eventtypeid) {eventtypeid}~/ 117 /~eventtypeid: upper(e.eventtypeid) {eventtypeid}~/
 
 
Line 130 | Parallel Line 130 | Parallel
130 /~ack: upper(a.ackstatus) {ack}~/ 130 /~ack: upper(a.ackstatus) {ack}~/
131 /~msg: upper(a.message) {msg}~/ 131 /~msg: upper(a.message) {msg}~/
132 /~remedy: upper(CASE WHEN a.remedy is null THEN ' ' ELSE a.remedy END) {remedy}~/ 132 /~remedy: upper(CASE WHEN a.remedy is null THEN ' ' ELSE a.remedy END) {remedy}~/
133 /~optionalfield: upper(CASE WHEN a.optionalfield is null THEN ' ' ELSE a.optionalfield END) {optionalfield}~/
134 /~category: upper(a.category) {category}~/ 133 /~category: upper(a.category) {category}~/
135 /~version: upper(a.version) {version}~/ 134 /~version: upper(a.version) {version}~/
136 /~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" /> 135 /~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" />
 
 
Line 295 | Parallel Line 294 | Parallel
295 <query id="LogViewer" value="select 294 <query id="LogViewer" value="select
296 el.eventid as id, et.eventtype as type, st.severity as severity,rd.resourcename as qf_resourcename,el.source as qf_source, 295 el.eventid as id, et.eventtype as type, st.severity as severity,rd.resourcename as qf_resourcename,el.source as qf_source,
297 rd.resourcename as resourcename,el.source as source, el.eventtime as eventtime, el.message as message, 296 rd.resourcename as resourcename,el.source as source, el.eventtime as eventtime, el.message as message,
298 el.remedy as remedy, el.optionalfield as optionalfield, el.category as category, rc.component_index as compindex, cd.colorname as color 297 el.remedy as remedy, el.category as category, rc.component_index as compindex, cd.colorname as color
299 FROM 298 FROM
300 EVENTTYPE et, SEVERITY st, COLORDETAILS cd, RESOURCEDETAILS rd, 299 EVENTTYPE et, SEVERITY st, COLORDETAILS cd, RESOURCEDETAILS rd,
301 LOGARCHIVE el left join RESOURCECOMPONENT rc on rc.componentid = el.componentid 300 LOGARCHIVE el left join RESOURCECOMPONENT rc on rc.componentid = el.componentid
302 WHERE 301 WHERE
303 (st.severitycolorid = cd.colorid and el.eventtypeid != 4 and et.eventtypeid = el.eventtypeid 302 (st.severitycolorid = cd.colorid and el.eventtype != 'SYSLOG' and et.eventtype = el.eventtype
304 and el.severityid=st.severityid and rd.resourceid = el.resourceid) 303 and el.severity=st.severity and rd.resourcename = el.resourcename)
305 /~id: (el.eventid) {id}~/ 304 /~id: (el.eventid) {id}~/
306 /~type: upper(et.eventtype) {type}~/ 305 /~type: upper(et.eventtype) {type}~/
307 /~severity: upper( st.severity) {severity}~/ 306 /~severity: upper( st.severity) {severity}~/
 
 
Line 312 | Parallel Line 311 | Parallel
312 /~eventtime: (el.eventtime ) {eventtime}~/ 311 /~eventtime: (el.eventtime ) {eventtime}~/
313 /~message: upper(el.message ) {message}~/ 312 /~message: upper(el.message ) {message}~/
314 /~remedy: upper(CASE WHEN el.remedy is null THEN ' ' ELSE el.remedy END) {remedy}~/ 313 /~remedy: upper(CASE WHEN el.remedy is null THEN ' ' ELSE el.remedy END) {remedy}~/
315 /~optionalfield: upper(CASE WHEN el.optionalfield is null THEN ' ' ELSE el.optionalfield END) {optionalfield}~/
316 /~category: upper(el.category ) {category}~/ 314 /~category: upper(el.category ) {category}~/
317 /~version: upper(el.version ) {version}~/ 315 /~version: upper(el.version ) {version}~/
318 /~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" /> 316 /~SORT_COLUMN: ORDER BY [SORT_COLUMN] [SORT_DIRECTION]~/" />
 
File Fault.Publisher/src/com/dhyan/nms/server/fault/publisher/EmailPublisherImpl.java (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 11 | Parallel Line 11 | Parallel
11 11
12 import com.dhyan.nms.Constants; 12 import com.dhyan.nms.Constants;
13 import com.dhyan.nms.server.fault.alarmmanager.AlarmFilterUtil; 13 import com.dhyan.nms.server.fault.alarmmanager.AlarmFilterUtil;
14 import com.dhyan.nms.server.fault.alarmmanager.AlarmManager;
14 import com.dhyan.nms.server.fault.alarmmanager.alarmstore.AlarmStore; 15 import com.dhyan.nms.server.fault.alarmmanager.alarmstore.AlarmStore;
15 import com.dhyan.nms.server.fault.alarmmanager.datamodel.Alarm; 16 import com.dhyan.nms.server.fault.alarmmanager.datamodel.Alarm;
16 import com.dhyan.nms.server.fault.alarmmanager.publisher.PublisherIfc; 17 import com.dhyan.nms.server.fault.alarmmanager.publisher.PublisherIfc;
 
 
Line 205 | Parallel Line 206 | Parallel
205 { 206 {
206 messageDetails.put("SOURCE COMPONENT", alarmEvent.getSourceComponent()); 207 messageDetails.put("SOURCE COMPONENT", alarmEvent.getSourceComponent());
207 } 208 }
209
210 try
211 {
212 String specification = AlarmManager.getInstance().getAlarmSpecificationType(alarmEvent);
213 messageDetails.put("ALARM RAISED BY", specification);
214 }
215 catch (Exception e)
216 {
217 LOG.error("Failure in Getting Alarm Event Type :" + e.getMessage());
208 if (alarmEvent.getEventTypeString() != null) 218 if (alarmEvent.getEventTypeString() != null)
209 { 219 {
210 messageDetails.put("ALARM RAISED BY", alarmEvent.getEventTypeString()); 220 messageDetails.put("ALARM RAISED BY", alarmEvent.getEventTypeString());
211 } 221 }
222 }
212 if (alarmEvent.getOwner() != null) 223 if (alarmEvent.getOwner() != null)
213 { 224 {
214 messageDetails.put("OWNER", alarmEvent.getOwner()); 225 messageDetails.put("OWNER", alarmEvent.getOwner());
 
File Perf.DataCollection/src/com/dhyan/nms/server/performance/datacollection/HistoricalProcessImpl.java (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 23 | Parallel Line 23 | Parallel
23 * @param resourcedetails Resourcedetails 23 * @param resourcedetails Resourcedetails
24 */ 24 */
25 @Override 25 @Override
26 public final void processCollectedData(final Collection<DynamicCollectedDataVO> dynamicdataVO, final Resourcedetails resourcedetails) 26 public void processCollectedData(final Collection<DynamicCollectedDataVO> dynamicdataVO, final Resourcedetails resourcedetails)
27 { 27 {
28 Object[][] collectedData = null; 28 Object[][] collectedData = null;
29 String tableName = null; 29 String tableName = null;
30 ArrayList<DBField> columnNames = null; 30 ArrayList<DBField> columnNames = null;
31 Collection<Object[]> finalValues = null;
32
33 try 31 try
34 { 32 {
35 for (DynamicCollectedDataVO dataVO : dynamicdataVO) 33 for (DynamicCollectedDataVO dataVO : dynamicdataVO)
 
File Perf.DataCollection/src/com/dhyan/nms/server/performance/datacollection/PerformanceTaskCreator.java (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 105 | Parallel Line 105 | Parallel
105 try 105 try
106 { 106 {
107 long scheduleInterval = perfTask.getScheduleinterval(); 107 long scheduleInterval = perfTask.getScheduleinterval();
108 pattern.setStarttime(System.currentTimeMillis()); 108 pattern.setStarttime(System.currentTimeMillis()+getTaskDelayTime());
109 pattern.setMinute((int) scheduleInterval / 60000); 109 pattern.setMinute((int) scheduleInterval / 60000);
110 }
111 catch (Exception e)
112 {
113 log.error(e);
114 }
115 return pattern;
116 }
117
118 /**
119 * Method to get delay time of a Performance task
120 * @return delay time
121 */
122 public long getTaskDelayTime()
123 {
110 if (perfProperties != null) 124 if (perfProperties != null)
111 { 125 {
112 String delayValueString = perfProperties.getProperty(DELAY_TIME_KEY); 126 String delayValueString = perfProperties.getProperty(DELAY_TIME_KEY);
 
 
Line 114 | Parallel Line 128 | Parallel
114 { 128 {
115 try 129 try
116 { 130 {
117 pattern.setStarttime(pattern.getStarttime() + Long.parseLong(delayValueString)); 131 return Long.parseLong(delayValueString);
118 } 132 }
119 catch (NumberFormatException ne) 133 catch (NumberFormatException ne)
120 { 134 {
 
 
Line 122 | Parallel Line 136 | Parallel
122 } 136 }
123 } 137 }
124 } 138 }
139 return 0;
125 } 140 }
126 catch (Exception e)
127 {
128 log.error(e);
129 }
130 return pattern;
131 }
132 141
133 /** 142 /**
134 * Reads and returns all the Tasks for a given resourceTypeId 143 * Reads and returns all the Tasks for a given resourceTypeId
 
File Perf.DataCollection/src/com/dhyan/nms/server/performance/datacollection/ejb/DataCollectionFacade.java (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 525 | Parallel Line 525 | Parallel
525 + " REPORTVIEW " + "where DCS.perftaskid = DCG.perftaskid and DCG.datacollectiongroupid = PODCGM.datacollectiongroupid and " 525 + " REPORTVIEW " + "where DCS.perftaskid = DCG.perftaskid and DCG.datacollectiongroupid = PODCGM.datacollectiongroupid and "
526 + "PODCGM.performanceobjectid = PO.performanceobjectid and " 526 + "PODCGM.performanceobjectid = PO.performanceobjectid and "
527 + "DCG.datacollectiongroupid != 3 and DCS.resourceid = ? and PO.performanceobjectid = ?" 527 + "DCG.datacollectiongroupid != 3 and DCS.resourceid = ? and PO.performanceobjectid = ?"
528 + " and REPORTVIEW.performanceobjectid = PO.performanceobjectid and REPORTVIEW.reportcategoryid " + reportCategoryId; 528 + " and REPORTVIEW.performanceobjectid = PO.performanceobjectid and REPORTVIEW.reportcategoryid = " + reportCategoryId;
529 try 529 try
530 { 530 {
531 ArrayList<Derivedobject> derived_list = (ArrayList<Derivedobject>) this.getAllDerivedObjects(); 531 ArrayList<Derivedobject> derived_list = (ArrayList<Derivedobject>) this.getAllDerivedObjects();
 
File Perf.PerformanceManager/src/com/dhyan/nms/server/performance/ejb/PerformanceFacade.java (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 172 | Parallel Line 172 | Parallel
172 { 172 {
173 try 173 try
174 { 174 {
175 pattern.setStarttime(System.currentTimeMillis()+PerformanceTaskCreator.getInstance().getTaskDelayTime());
175 SchedulerManager.getInstance().addTask(dataCollScheduleId, DATA_COLLECTION_SCHEDULER_ID, pattern); 176 SchedulerManager.getInstance().addTask(dataCollScheduleId, DATA_COLLECTION_SCHEDULER_ID, pattern);
176 } 177 }
177 catch (Exception e) 178 catch (Exception e)
 
File Web.BaseModule/WebContent/jsp/DNMSIndex.jsp (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 23 | Parallel Line 23 | Parallel
23 <script type="text/javascript" src="/webresource/webbase/scripts/prototype-1.6.0.3.js"></script> 23 <script type="text/javascript" src="/webresource/webbase/scripts/prototype-1.6.0.3.js"></script>
24 <script type="text/javascript" src="/webresource/webbase/scripts/EMSBrowserInfo.js"></script> 24 <script type="text/javascript" src="/webresource/webbase/scripts/EMSBrowserInfo.js"></script>
25 <script type="text/javascript" src="/webresource/webbase/scripts/GlobalUtil.js"></script> 25 <script type="text/javascript" src="/webresource/webbase/scripts/GlobalUtil.js"></script>
26
27 <!-- We use this resource bundle in /webresource/webbase/scripts/datetimepicker.js -->
28 <i18n:loadProperties resourceBundle="dateTimePicker" jsVarName="dateTimePickerLocale"/>
29
26 <script type="text/javascript" src="/webresource/webbase/scripts/datetimepicker.js"></script> 30 <script type="text/javascript" src="/webresource/webbase/scripts/datetimepicker.js"></script>
27 <script type="text/javascript" src="/webresource/webbase/scripts/dateUtility.js"></script> 31 <script type="text/javascript" src="/webresource/webbase/scripts/dateUtility.js"></script>
28 <script type="text/javascript" src="/webresource/webbase/scripts/DNMSDynamicLoader.js"></script> 32 <script type="text/javascript" src="/webresource/webbase/scripts/DNMSDynamicLoader.js"></script>
 
File Web.BaseModule/WebContent/jsp/LoadResourceBundle.jsp (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 111 | Parallel Line 111 | Parallel
111 <!-- Web base Settings --> 111 <!-- Web base Settings -->
112 112
113 <i18n:loadProperties resourceBundle="loginManager" jsVarName="loginManagerLocale"/> 113 <i18n:loadProperties resourceBundle="loginManager" jsVarName="loginManagerLocale"/>
114 <i18n:loadProperties resourceBundle="dateTimePicker" jsVarName="dateTimePickerLocale"/>
115 <i18n:loadProperties resourceBundle="notificationHandler" jsVarName="notificationHandlerLocale"/> 114 <i18n:loadProperties resourceBundle="notificationHandler" jsVarName="notificationHandlerLocale"/>
116 <i18n:loadProperties resourceBundle="globalUtil" jsVarName="globalUtilLocale"/> 115 <i18n:loadProperties resourceBundle="globalUtil" jsVarName="globalUtilLocale"/>
117 <i18n:loadProperties resourceBundle="layoutManager" jsVarName="layoutManagerLocale"/> 116 <i18n:loadProperties resourceBundle="layoutManager" jsVarName="layoutManagerLocale"/>
 
File Web.BaseModule/WebContent/webresource/webcomponents/table/scripts/VerticalTable.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 161 | Parallel Line 161 | Parallel
161 getSelectedRow: function() 161 getSelectedRow: function()
162 { 162 {
163 var cellInnerHTML=null; 163 var cellInnerHTML=null;
164 if (this.previousSelectedRow != null) 164 if (this.previousSelectedRow != null && this.previousSelectedRow.length > 0)
165 { 165 {
166 cellInnerHTML=new Array(); 166 cellInnerHTML=new Array();
167 for(i=0;i<this.previousSelectedRow.length;i++) 167 for(i=0;i<this.previousSelectedRow.length;i++)
 
File Web.Chart/WebContent/webresource/chart/flex/src/Linechart.mxml (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 58 | Parallel Line 58 | Parallel
58 refreshInterval= uint(Application.application.parameters.refreshInterval); 58 refreshInterval= uint(Application.application.parameters.refreshInterval);
59 if (refreshInterval < 10000) refreshInterval=10000; 59 if (refreshInterval < 10000) refreshInterval=10000;
60 this.isChartRefreshEnabled=Application.application.parameters.isChartRefreshEnabled.toString(); 60 this.isChartRefreshEnabled=Application.application.parameters.isChartRefreshEnabled.toString();
61 this.isRealTimeChart = Application.application.parameters.isRealTimeChart.toString(); 61 this.isRealTimeChart = Application.application.parameters.isRealTimeChart as String;
62 this.legendsContainer = new Canvas(); 62 this.legendsContainer = new Canvas();
63 legendsContainer.x = 0; 63 legendsContainer.x = 0;
64 legendsContainer.y = 0; 64 legendsContainer.y = 0;
 
 
Line 134 | Parallel Line 134 | Parallel
134 if(this.noDataLabel == null){ 134 if(this.noDataLabel == null){
135 this.noDataLabel = ChartsUtil.addNoDataToCanvas(chartContainer); 135 this.noDataLabel = ChartsUtil.addNoDataToCanvas(chartContainer);
136 } 136 }
137 if (isRealTimeChart === "true") startRefreshTimer(); 137 if (this.isRealTimeChart === "true") startRefreshTimer();
138 } 138 }
139 else 139 else
140 { 140 {
 
 
Line 187 | Parallel Line 187 | Parallel
187 { 187 {
188 if(refreshTimer.running) 188 if(refreshTimer.running)
189 { 189 {
190 isLoadedFirst = false;
190 isDataPopulated=false; 191 isDataPopulated=false;
191 loadChartData(); 192 loadChartData();
192 } 193 }
 
 
Line 239 | Parallel Line 240 | Parallel
239 { 240 {
240 try 241 try
241 { 242 {
243 chartData = new ArrayCollection(dataObject.dbValues.chartData as Array);
244 delete dataObject.dbValues.chartData;
245 linechart.dataProvider = chartData;
246
242 if(isLoadedFirst) 247 if(isLoadedFirst)
243 { 248 {
244 var legendsHeight : uint = 0; 249 var legendsHeight : uint = 0;
245 var previousXPosition : uint = 0; 250 var previousXPosition : uint = 0;
246 var previousYPosition : uint = 0; 251 var previousYPosition : uint = 0;
247 chartData = new ArrayCollection(dataObject.dbValues.chartData as Array);
248 delete dataObject.dbValues.chartData;
249 linechart.series = []; // Reset the series... 252 linechart.series = []; // Reset the series...
250 var series:LineSeries=null; 253 var series:LineSeries=null;
251 var displayStr:String=""; 254 var displayStr:String="";
 
 
Line 269 | Parallel Line 272 | Parallel
269 series.setStyle("radius", 3); 272 series.setStyle("radius", 3);
270 series.setStyle("adjustedRadius", 1); 273 series.setStyle("adjustedRadius", 1);
271 series.setStyle("itemRenderer", new ClassFactory(DiamondItemRenderer)); 274 series.setStyle("itemRenderer", new ClassFactory(DiamondItemRenderer));
272 if (isRealTimeChart === "false") 275 if (this.isRealTimeChart === "false")
273 series.setStyle("showDataEffect", interpolateData); 276 series.setStyle("showDataEffect", interpolateData);
274 var legendItem : LegendItem = new LegendItem({"name": series.id, 277 var legendItem : LegendItem = new LegendItem({"name": series.id,
275 legendBox:{"fillColor" : fillColorValue, "fillAlpha": 0.5}, 278 legendBox:{"fillColor" : fillColorValue, "fillAlpha": 0.5},
 
File Web.ChassisView/WebContent/resources/conf/MultiChassisView.xml (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 1 | Parallel Line 1 | Parallel
1 <?xml version="1.0" encoding="UTF-8"?> 1 <?xml version="1.0" encoding="UTF-8"?>
2 <chassisViewDetails xmlns="http://www.dhyan.com/nms/client/webclient/chassisview"> 2 <chassisViewDetails xmlns="http://www.dhyan.com/nms/client/webclient/chassisview">
3 <resource resourceType="Linux" refreshRate="10000" maxZoomWidth="2000"> 3 <resource resourceType="Linux" refreshRate="10000" maxZoomWidth="2000">
4 <view type="front" width="680" height="460"> <!-- Front view --> 4 <view type="Front" width="680" height="460"> <!-- Front view -->
5 <!-- Shelf component - 1 --> 5 <!-- Shelf component - 1 -->
6 <component 6 <component
7 index="1" 7 index="1"
 
 
Line 668 | Parallel Line 668 | Parallel
668 </resource> 668 </resource>
669 669
670 <resource resourceType="Windows" refreshRate="10000" maxZoomWidth="2000"> 670 <resource resourceType="Windows" refreshRate="10000" maxZoomWidth="2000">
671 <view type="front" width="680" height="460"> <!-- Front view --> 671 <view type="Front" width="680" height="460"> <!-- Front view -->
672 <!-- Shelf component - 1 --> 672 <!-- Shelf component - 1 -->
673 <component 673 <component
674 index="1" 674 index="1"
 
 
Line 1335 | Parallel Line 1335 | Parallel
1335 </resource> 1335 </resource>
1336 1336
1337 <resource resourceType="Solaris" refreshRate="10000" maxZoomWidth="2000"> 1337 <resource resourceType="Solaris" refreshRate="10000" maxZoomWidth="2000">
1338 <view type="front" width="680" height="460"> <!-- Front view --> 1338 <view type="Front" width="680" height="460"> <!-- Front view -->
1339 <!-- Shelf component - 1 --> 1339 <!-- Shelf component - 1 -->
1340 <component 1340 <component
1341 index="1" 1341 index="1"
 
File Web.ChassisView/WebContent/webresource/chassisview/scripts/ChassisView.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 12 | Parallel Line 12 | Parallel
12 var parent_component_status = new Array(); 12 var parent_component_status = new Array();
13 var resourceId = ""; 13 var resourceId = "";
14 var resourceType = ""; 14 var resourceType = "";
15 var viewType = "front"; 15 var viewType = "Front";
16 var zoom_size = 0; 16 var zoom_size = 0;
17 var chassi_table_width = 0; 17 var chassi_table_width = 0;
18 var chassi_table_height = 0; 18 var chassi_table_height = 0;
 
File Web.ChassisView/src/com/dhyan/nms/client/webclient/chassisview/struts/resources/MultiChassisView.xsd (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 66 | Parallel Line 66 | Parallel
66 66
67 <xs:simpleType name="viewType"> 67 <xs:simpleType name="viewType">
68 <xs:restriction base="xs:string"> 68 <xs:restriction base="xs:string">
69 <xs:enumeration value="front"/> 69 <xs:enumeration value="Front"/>
70 <xs:enumeration value="rear"/> 70 <xs:enumeration value="Rear"/>
71 <xs:enumeration value="top"/> 71 <xs:enumeration value="Top"/>
72 <xs:enumeration value="bottom"/> 72 <xs:enumeration value="Bottom"/>
73 <xs:enumeration value="left"/> 73 <xs:enumeration value="Left"/>
74 <xs:enumeration value="right"/> 74 <xs:enumeration value="Right"/>
75 </xs:restriction> 75 </xs:restriction>
76 </xs:simpleType> 76 </xs:simpleType>
77 77
 
File Web.Fault/WebContent/WEB-INF/properties/AlarmDetailsAction.properties (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 1 | Parallel Line 1 | Parallel
1 AlarmDetailsAction.alert.unauthorized.annotation=You are not authorized to give Annotation. 1 AlarmDetailsAction.alert.unauthorized.annotation=You are not authorized to give Annotation.
2 AlarmDetailsAction.alert.unauthorized.acknowledge=You are not authorized to acknowledge the Alarm. 2 AlarmDetailsAction.alert.unauthorized.acknowledge=You are not authorized to acknowledge the Alarm.
3 AlarmDetailsAction.alert.unauthorized.acknowledgeAlarmID=You are not authorized to acknowledge alarm with id 3 AlarmDetailsAction.alert.unauthorized.acknowledgeAlarmID=You are not authorized to acknowledge alarm with id
4 AlarmDetailsAction.alert.clearAlarm.validation= Cannot clear Device generated alarm(s).
 
File Web.Fault/WebContent/WEB-INF/struts/struts.xml (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 58 | Parallel Line 58 | Parallel
58 </interceptor-ref> 58 </interceptor-ref>
59 <result>/fault/AlarmBrowser.jsp</result> 59 <result>/fault/AlarmBrowser.jsp</result>
60 </action> 60 </action>
61 <action name="checkCanClearAlarms"
62 class="com.dhyan.nms.client.webclient.fault.struts.AlarmDetailsAction"
63 method="checkCanClearAlarms">
64 </action>
61 <action name="ClearAlarms" 65 <action name="ClearAlarms"
62 class="com.dhyan.nms.client.webclient.fault.struts.AlarmDetailsAction" 66 class="com.dhyan.nms.client.webclient.fault.struts.AlarmDetailsAction"
63 method="clearAlarm"> 67 method="clearAlarm">
 
File Web.Fault/WebContent/webresource/fault/scripts/DNMSFault.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 498 | Parallel Line 498 | Parallel
498 { 498 {
499 Windows.close(FaultUtil.ALARM_EDIT_WINDOW_ID); 499 Windows.close(FaultUtil.ALARM_EDIT_WINDOW_ID);
500 var updatedTime = errorMessage.updatedtime; 500 var updatedTime = errorMessage.updatedtime;
501 var lowerLimit = parseFloat(updatedTime) - (60 * 1000); 501 var lowerLimit = parseFloat(updatedTime) - (5 * 60 * 1000);
502 var upperLimit = parseFloat(updatedTime) + (60 * 1000); 502 var upperLimit = parseFloat(updatedTime) + (5 * 60 * 1000);
503 setTimeout(function() 503 setTimeout(function()
504 { 504 {
505 alarmDetailView(errorMessage.alarmid, errorMessage.resourceid, lowerLimit, upperLimit); 505 alarmDetailView(errorMessage.alarmid, errorMessage.resourceid, lowerLimit, upperLimit);
 
File Web.Fault/WebContent/webresource/fault/scripts/FaultScriptController.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 589 | Parallel Line 589 | Parallel
589 purgeAlarmsNowCallBack: 589 purgeAlarmsNowCallBack:
590 function() 590 function()
591 { 591 {
592 if (FaultMenuHandler.purgeNowWin == null) 592 var conMessage;
593 var purgeOption=1;
594 if(purgeOption == 1)
593 { 595 {
594 FaultMenuHandler.purgeNowWin = new Window( 596 conMessage = alarmpurgeintervalLocale.getText("alarmPurgeInterval.dialog.message.sureToDeleteAllClearedAlarms")
597 }
598 else
595 { 599 {
596 id: 'purgeAlarmWindow', 600 conMessage = alarmpurgeintervalLocale.getText("alarmPurgeInterval.dialog.message.sureToDeleteAllAlarms");
597 title: alarmpurgeintervalLocale.getText("alarmPurgeInterval.window.title.purgeAlarmsNow"), 601 }
598 width: 390, 602 JSDialog.showConfirmDialog(conMessage,
599 height: 100,
600 left: 350,
601 top: 200,
602 maximizable: false,
603 minimizable: false,
604 iconURL:ImageUtility.getImageURL(DNMSUtility.FAULT) + "purge_now.gif",
605 resizable: false,
606 destroyOnClose: true,
607 hasButton:true,
608 onContentLoad:function()
609 { 603 {
610 var window = Windows.getWindow(this.id); 604 onOk : function()
611 var helpButtonJSON = {id:'alarmPurgeNowHelpButton', title:alarmpurgeintervalLocale.getText("alarmPurgeInterval.button.name.help"), name:'alarmPurgeHelpButton', className:DNMSButton.HELP_BUTTON, handler: null}; 605 {
612 var okButtonJSON = {id:'alarmPurgeNowOkButton', title:alarmpurgeintervalLocale.getText("alarmPurgeInterval.button.name.ok"), name:'alarmPurgeSaveButton', className:DNMSButton.OK_BUTTON, handler: purgeAlarms.bind(this, document.alarmPurgeNowForm)}; 606 new Ajax.Request("/fault/PurgeAlarmsNow.action",
613 var cancelButtonJSON = {id:'alarmPurgeNowCancelButton', title:alarmpurgeintervalLocale.getText("alarmPurgeInterval.button.name.cancel"), name:'alarmPurgeCancelButton', className:DNMSButton.CANCEL_BUTTON, handler: closeAlarmPurge}; 607 {
614 window.addButton(DNMSButton.createButton(helpButtonJSON), "left"); 608 onSuccess: function()
615 window.addButton(DNMSButton.createButton(okButtonJSON), "right"); 609 {
616 window.addButton(DNMSButton.createButton(cancelButtonJSON), "right"); 610 Windows.close('purgeAlarmWindow');
611 AlarmBrowserUtil.alarm_grid['grid'].buffer.refresh();
617 }, 612 },
618 onDestroy: function() 613 postBody:'purgeNowOption=1'
619 { 614 });
620 FaultMenuHandler.purgeNowWin = null
621 } 615 }
622 }); 616 });
623 FaultMenuHandler.purgeNowWin.show(true); 617 // if (FaultMenuHandler.purgeNowWin == null)
624 } 618 // {
625 FaultMenuHandler.purgeNowWin.setURL('/fault/getPurgingOptins.action'); 619 // FaultMenuHandler.purgeNowWin = new Window(
620 // {
621 // id: 'purgeAlarmWindow',
622 // title: alarmpurgeintervalLocale.getText("alarmPurgeInterval.window.title.purgeAlarmsNow"),
623 // width: 390,
624 // height: 100,
625 // left: 350,
626 // top: 200,
627 // maximizable: false,
628 // minimizable: false,
629 // iconURL:ImageUtility.getImageURL(DNMSUtility.FAULT) + "purge_now.gif",
630 // resizable: false,
631 // destroyOnClose: true,
632 // hasButton:true,
633 // onContentLoad:function()
634 // {
635 // var window = Windows.getWindow(this.id);
636 // var helpButtonJSON = {id:'alarmPurgeNowHelpButton', title:alarmpurgeintervalLocale.getText("alarmPurgeInterval.button.name.help"), name:'alarmPurgeHelpButton', className:DNMSButton.HELP_BUTTON, handler: null};
637 // var okButtonJSON = {id:'alarmPurgeNowOkButton', title:alarmpurgeintervalLocale.getText("alarmPurgeInterval.button.name.ok"), name:'alarmPurgeSaveButton', className:DNMSButton.OK_BUTTON, handler: purgeAlarms.bind(this, document.alarmPurgeNowForm)};
638 // var cancelButtonJSON = {id:'alarmPurgeNowCancelButton', title:alarmpurgeintervalLocale.getText("alarmPurgeInterval.button.name.cancel"), name:'alarmPurgeCancelButton', className:DNMSButton.CANCEL_BUTTON, handler: closeAlarmPurge};
639 // window.addButton(DNMSButton.createButton(helpButtonJSON), "left");
640 // window.addButton(DNMSButton.createButton(okButtonJSON), "right");
641 // window.addButton(DNMSButton.createButton(cancelButtonJSON), "right");
642 // },
643 // onDestroy: function()
644 // {
645 // FaultMenuHandler.purgeNowWin = null
646 // }
647 // });
648 // FaultMenuHandler.purgeNowWin.show(true);
649 // }
650 // FaultMenuHandler.purgeNowWin.setURL('/fault/getPurgingOptins.action');
626 }, 651 },
627 652
628 purgeAlarmsNow: 653 purgeAlarmsNow:
 
File Web.Fault/WebContent/webresource/fault/scripts/FaultTabUtility.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 348 | Parallel Line 348 | Parallel
348 var alarmid = rowJSON.rows[0].alarmid; 348 var alarmid = rowJSON.rows[0].alarmid;
349 var resourceId = rowJSON.rows[0].resourceid; 349 var resourceId = rowJSON.rows[0].resourceid;
350 var updatedTime = rowJSON.rows[0].updatedtime; 350 var updatedTime = rowJSON.rows[0].updatedtime;
351 var lowerLimit = parseFloat(updatedTime) - (60 * 1000); 351 var lowerLimit = parseFloat(updatedTime) - (5 * 60 * 1000);
352 var upperLimit = parseFloat(updatedTime) + (60 * 1000); 352 var upperLimit = parseFloat(updatedTime) + (5 * 60 * 1000);
353 alarmDetailView(alarmid, resourceId, lowerLimit, upperLimit); 353 alarmDetailView(alarmid, resourceId, lowerLimit, upperLimit);
354 } 354 }
355 else 355 else
 
 
Line 664 | Parallel Line 664 | Parallel
664 var rowJSON = AlarmBrowserUtil.alarm_grid['grid'].getSelectedRowsJSON(); 664 var rowJSON = AlarmBrowserUtil.alarm_grid['grid'].getSelectedRowsJSON();
665 if (rowJSON.rows) 665 if (rowJSON.rows)
666 { 666 {
667 new Ajax.Request('/fault/checkCanClearAlarms.action',
668 {
669 method: 'get',
670 parameters:'rowsjson='+ Object.toJSON(rowJSON.rows),
671 onSuccess: function(response)
672 {
673 var responseJSON = eval('(' + response.responseText + ')');
674 if (responseJSON != null && responseJSON.errorMessage != null)
675 {
676 JSDialog.showAlertDialog(responseJSON.errorMessage+"");
677 }
678 else
679 {
667 JSDialog.showConfirmDialog(alarmsLocale.getText("alarms.dialog.message.wantToClearAlarms"), 680 JSDialog.showConfirmDialog(alarmsLocale.getText("alarms.dialog.message.wantToClearAlarms"),
668 { 681 {
669 onOk : function() 682 onOk : function()
 
 
Line 703 | Parallel Line 716 | Parallel
703 } 716 }
704 }); 717 });
705 } 718 }
719 }
720 });
721
722 }
706 else 723 else
707 { 724 {
708 showNotSelectError(); 725 showNotSelectError();
 
File Web.Fault/src/com/dhyan/nms/client/webclient/fault/struts/AlarmDetailsAction.java (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 31 | Parallel Line 31 | Parallel
31 import com.dhyan.nms.client.webclient.webbase.struts.WebConstants; 31 import com.dhyan.nms.client.webclient.webbase.struts.WebConstants;
32 import com.dhyan.nms.datamodel.StaleDataException; 32 import com.dhyan.nms.datamodel.StaleDataException;
33 import com.dhyan.nms.server.fault.alarmmanager.AlarmConstants; 33 import com.dhyan.nms.server.fault.alarmmanager.AlarmConstants;
34 import com.dhyan.nms.server.fault.alarmmanager.AlarmManager;
34 import com.dhyan.nms.server.fault.alarmmanager.datamodel.Alarm; 35 import com.dhyan.nms.server.fault.alarmmanager.datamodel.Alarm;
35 import com.dhyan.nms.server.fault.alarmmanager.datamodel.Alarmannotation; 36 import com.dhyan.nms.server.fault.alarmmanager.datamodel.Alarmannotation;
36 import com.dhyan.nms.server.fault.alarmmanager.interfaces.AlarmSessionLocal; 37 import com.dhyan.nms.server.fault.alarmmanager.interfaces.AlarmSessionLocal;
 
 
Line 160 | Parallel Line 161 | Parallel
160 this.optionalfield = optionalfieldArg; 161 this.optionalfield = optionalfieldArg;
161 } 162 }
162 163
163
164 /** 164 /**
165 * @param rowsjsonArg the rowsjson to set 165 * @param rowsjsonArg the rowsjson to set
166 */ 166 */
 
 
Line 883 | Parallel Line 883 | Parallel
883 { 883 {
884 if (response != null) 884 if (response != null)
885 { 885 {
886 JSONBuilder.setResponseAttributes(response);
886 response.getWriter().write(responseString); 887 response.getWriter().write(responseString);
887 } 888 }
888 } 889 }
 
 
Line 892 | Parallel Line 893 | Parallel
892 * @return null 893 * @return null
893 * @throws Exception exception 894 * @throws Exception exception
894 */ 895 */
896 public String checkCanClearAlarms() throws Exception
897 {
898
899 try
900 {
901 JSONArray jsonArray = new JSONArray(getRowsjson());
902 JSONObject responseJSON = new JSONObject();
903 if (jsonArray.length() > 0)
904 {
905 for (int i = 0; i < jsonArray.length(); i++)
906 {
907 JSONObject jsonObject = jsonArray.getJSONObject(i);
908 Alarm alarmObj = getAlarmFromJSON(jsonObject);
909 if (AlarmManager.getInstance().isDeviceAlarm(alarmObj))
910 {
911 responseJSON.put("errorMessage", ResourceBundleHandler.getInstance().getResource(AlarmDetailsAction.RESOURCE_BUNDLE,
912 "AlarmDetailsAction.alert.clearAlarm.validation", "Problem in locating Resource Bundle / Keys"));
913 break;
914 }
915 }
916 }
917 this.writeToResponse(responseJSON.toString());
918 }
919 catch (Exception e)
920 {
921 AlarmDetailsAction.LOGGER.error("Problem while Clearing Alarms; Exception caused due to " + e.getMessage());
922 }
923 return null;
924 }
925
926 /**
927 * To clear the alarms.
928 * @return null
929 * @throws Exception exception
930 */
895 public String clearAlarm() throws Exception 931 public String clearAlarm() throws Exception
896 { 932 {
897 try 933 try
 
 
Line 913 | Parallel Line 949 | Parallel
913 alarm_store_local.addAnnotateAlarm(alarmObj.getAlarmid(), this.getAnnotation(), security_facade_local.getUserID(alarmObj.getOwner())); 949 alarm_store_local.addAnnotateAlarm(alarmObj.getAlarmid(), this.getAnnotation(), security_facade_local.getUserID(alarmObj.getOwner()));
914 } 950 }
915 } 951 }
916 this.writeToResponse(JSONBuilder.OPEN_CURLY_BRACE 952 this.writeToResponse(JSONBuilder.OPEN_CURLY_BRACE + JSONBuilder.prepareKeyValuePair(AlarmDetailsAction.SUCCESS, "success ")
917 + JSONBuilder.prepareKeyValuePair(AlarmDetailsAction.SUCCESS, "success ") + JSONBuilder.CLOSED_CURLY_BRACE); 953 + JSONBuilder.CLOSED_CURLY_BRACE);
918 } 954 }
919 catch (StaleDataException se) 955 catch (StaleDataException se)
920 { 956 {
 
File Web.Performance/WebContent/webresource/dashboard/scripts/DashboardConfigurator.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 298 | Parallel Line 298 | Parallel
298 } 298 }
299 } 299 }
300 this.setScrollerPosition(defaultOption); 300 this.setScrollerPosition(defaultOption);
301 setTimeout(function(){this.loadDashboard()}.bind(this), 150); 301 setTimeout(function(){this.loadDashboard();}.bind(this), 150);
302 } 302 }
303 catch(e) 303 catch(e)
304 { 304 {
 
 
Line 468 | Parallel Line 468 | Parallel
468 { 468 {
469 try 469 try
470 { 470 {
471 this.stopRealTimeDataCollection(); 471 //this.stopRealTimeDataCollection();
472 this.slots = new Array(); 472 this.slots = new Array();
473 this.drawSlots(); 473 this.drawSlots();
474 this.initDashboardLoader(); 474 this.initDashboardLoader();
 
 
Line 1690 | Parallel Line 1690 | Parallel
1690 { 1690 {
1691 postParam += "&filterCondition=" + $('slot_filter_selector_' + slotPosition[i]).value; 1691 postParam += "&filterCondition=" + $('slot_filter_selector_' + slotPosition[i]).value;
1692 } 1692 }
1693 if ($('slot_aggregate_selector_'+ slotPosition[i]) != null) 1693 //if ($('slot_aggregate_selector_'+ slotPosition[i]) != null)
1694 { 1694 //{
1695 //postParam += "&aggregateType=" + $('slot_aggregate_selector_'+ slotPosition[i]).value; 1695 //postParam += "&aggregateType=" + $('slot_aggregate_selector_'+ slotPosition[i]).value;
1696 postParam += "&aggregateType=3"; 1696 postParam += "&aggregateType=3";
1697 //}
1697 } 1698 }
1698 }
1699 if ($('dashboardCategory').value == 2) 1699 if ($('dashboardCategory').value == 2)
1700 { 1700 {
1701 postParam += "&refreshInterval=" + $('slot_refreshInterval_'+ slotPosition[i]).value; 1701 postParam += "&refreshInterval=" + $('slot_refreshInterval_'+ slotPosition[i]).value;
 
File Web.Security/WebContent/webresource/security/scripts/SecurityUserManager.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 963 | Parallel Line 963 | Parallel
963 focus_field = thisForm.password; 963 focus_field = thisForm.password;
964 } 964 }
965 } 965 }
966 temp_error = validateConfirmPassword(thisForm.password.value, thisForm.confirmPassword.value, userManagementLocale.getText("security.userManagement.addUser.confirmPassword"), true); 966 temp_error = validateConfirmPassword(thisForm.password.value, thisForm.confirmPassword.value, userManagementLocale.getText("security.userManagement.message.confirmPassword"), true);
967 if(temp_error != null) 967 if(temp_error != null)
968 { 968 {
969 error_mess += temp_error + "\n"; 969 error_mess += temp_error + "\n";
 
File Web.Topology/WebContent/WEB-INF/properties/resource.properties (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 27 | Parallel Line 27 | Parallel
27 resource.dialog.message.zip=ZIP 27 resource.dialog.message.zip=ZIP
28 resource.dialog.message.noInvalidResourceId=No/Invalid Network Element Id 28 resource.dialog.message.noInvalidResourceId=No/Invalid Network Element Id
29 resource.dialog.message.selectResource=Please select a Network Element 29 resource.dialog.message.selectResource=Please select a Network Element
30 resource.dialog.message.cannotDeleteResource= {0} Could not delete selected Network Element 30 resource.dialog.message.cannotDeleteResource=Could not delete selected Network Element
31 resource.dialog.message.wantToDeleteResource=Are you sure you want to delete the selected Network Element? 31 resource.dialog.message.wantToDeleteResource=Are you sure you want to delete the selected Network Element?
32 32
33 resource.progressWindow.title.addingResourceDetails=Adding Network Element Details 33 resource.progressWindow.title.addingResourceDetails=Adding Network Element Details
 
File Web.Topology/WebContent/WEB-INF/properties/resourcegroup.properties (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 5 | Parallel Line 5 | Parallel
5 resourceGroup.button.name.save=Save 5 resourceGroup.button.name.save=Save
6 resourceGroup.button.name.cancel=Cancel 6 resourceGroup.button.name.cancel=Cancel
7 7
8 resourceGroup.dialog.message.deletingGroup = Deleting group.
8 resourceGroup.dialog.message.validateGroupAddition = Group cannot be added. Nesting limit reached. 9 resourceGroup.dialog.message.validateGroupAddition = Group cannot be added. Nesting limit reached.
9 resourceGroup.dialog.message.enterValidGroupName=Please enter a valid group name 10 resourceGroup.dialog.message.enterValidGroupName=Please enter a valid group name
10 resourceGroup.dialog.message.notAllowedSelectParentGroup=You are not allowed to select the parent group 11 resourceGroup.dialog.message.notAllowedSelectParentGroup=You are not allowed to select the parent group
 
File Web.Topology/WebContent/webresource/topology/scripts/ResourceTreeManager.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 457 | Parallel Line 457 | Parallel
457 457
458 if(thisForm.resourceFormId_locationDetails1.checked) 458 if(thisForm.resourceFormId_locationDetails1.checked)
459 { 459 {
460 getAddressValue(thisForm, successResourceAdd, "/topology/addResource.action", "Add"); 460 getLatLngValue(thisForm, successResourceAdd, "/topology/addResource.action", "Add");
461 } 461 }
462 else 462 else
463 { 463 {
464 getLatLngValue(thisForm, successResourceAdd, "/topology/addResource.action", "Add"); 464 getAddressValue(thisForm, successResourceAdd, "/topology/addResource.action", "Add");
465 } 465 }
466 } 466 }
467 else if (thisForm.operationType.value == "EDIT") 467 else if (thisForm.operationType.value == "EDIT")
 
 
Line 609 | Parallel Line 609 | Parallel
609 var point=copyOfPoint; 609 var point=copyOfPoint;
610 copyOfPoint=null; 610 copyOfPoint=null;
611 progressWindow.closeProgressWindow(); 611 progressWindow.closeProgressWindow();
612 closeEditGroupWindow(); 612
613 if (response.responseText) 613 if (response.responseText)
614 { 614 {
615 var errorJson = eval('(' + response.responseText + ')'); 615 var errorJson = eval('(' + response.responseText + ')');
 
 
Line 623 | Parallel Line 623 | Parallel
623 { 623 {
624 updateGroupLocationDetails(TopologyManager.topologyTree.getTree().getRootNode(), errorJson); 624 updateGroupLocationDetails(TopologyManager.topologyTree.getTree().getRootNode(), errorJson);
625 TopologyManager.topologyGoogleMapControl.setCenter(point,errorJson.zoom); 625 TopologyManager.topologyGoogleMapControl.setCenter(point,errorJson.zoom);
626 closeEditGroupWindow();
626 }, 5); 627 }, 5);
627 } 628 }
628 } 629 }
 
 
Line 911 | Parallel Line 912 | Parallel
911 deleteGroup = function(paramNode) 912 deleteGroup = function(paramNode)
912 { 913 {
913 914
915
914 var groupId = null; 916 var groupId = null;
915 groupId = TopologyManager.topologyTree.getEntityId(paramNode); 917 groupId = TopologyManager.topologyTree.getEntityId(paramNode);
916 JSDialog.showConfirmDialog(resourcegroupLocale.getText("resourceGroup.dialog.message.subgroupDeletedWantToContinue", [paramNode.getNodeText()]), 918 JSDialog.showConfirmDialog(resourcegroupLocale.getText("resourceGroup.dialog.message.subgroupDeletedWantToContinue", [paramNode.getNodeText()]),
917 { 919 {
918 onOk : function() 920 onOk : function()
919 { 921 {
922 var deleteGroupProgressWindow = JSDialog.showProgressDialog(resourcegroupLocale.getText("resourceGroup.dialog.message.deletingGroup"));
920 var parentNode = paramNode.getParentNode(); 923 var parentNode = paramNode.getParentNode();
921 new Ajax.Request('/topology/deleteGroup.action?groupId=' + groupId, 924 new Ajax.Request('/topology/deleteGroup.action?groupId=' + groupId,
922 { 925 {
 
 
Line 936 | Parallel Line 939 | Parallel
936 } 939 }
937 if (responseJSON.error != null) 940 if (responseJSON.error != null)
938 JSDialog.showAlertDialog(resourcegroupLocale.getText("resourceGroup.dialog.message.cannotDeleteGroup", [paramNode.getNodeText()])); 941 JSDialog.showAlertDialog(resourcegroupLocale.getText("resourceGroup.dialog.message.cannotDeleteGroup", [paramNode.getNodeText()]));
942
939 } 943 }
940 catch (e) 944 catch (e)
941 { 945 {
942 } 946 }
947 deleteGroupProgressWindow.close();
943 } 948 }
944 }); 949 });
950
951
945 return true; 952 return true;
946 } 953 }
947 }); 954 });
948
949 return false; 955 return false;
950 }; 956 };
951 var editResourceWindow = null; 957 var editResourceWindow = null;
 
 
Line 1035 | Parallel Line 1041 | Parallel
1035 } 1041 }
1036 if (responseJSON.error != null) 1042 if (responseJSON.error != null)
1037 { 1043 {
1038 JSDialog.showAlertDialog(resourceLocale.getText("resource.dialog.message.cannotDeleteResource",[responseJSON.error])); 1044 JSDialog.showAlertDialog(resourceLocale.getText("resource.dialog.message.cannotDeleteResource"));
1039 } 1045 }
1040 } 1046 }
1041 catch (e) 1047 catch (e)
 
File Web.Topology/WebContent/webresource/topology/scripts/TopologyMapHelper.js (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 111 | Parallel Line 111 | Parallel
111 noOfResourcePerLine = parseInt($('toInsertMapView').clientWidth / 80, 10); 111 noOfResourcePerLine = parseInt($('toInsertMapView').clientWidth / 80, 10);
112 } 112 }
113 catch (e) { 113 catch (e) {
114
115 }
116 }
117 if (noOfResourcePerLine < 10)
118 {
114 noOfResourcePerLine = 10; 119 noOfResourcePerLine = 10;
115 } 120 }
121 else
122 {
123 noOfResourcePerLine = noOfResourcePerLine + 1;
116 } 124 }
117
118 var tr = null; 125 var tr = null;
119 var noOfRows = 0; 126 var noOfRows = 0;
120 if ($('dnmsTopologyMapResourceDetailsView') != null) $('dnmsTopologyMapResourceDetailsView').remove(); 127 if ($('dnmsTopologyMapResourceDetailsView') != null) $('dnmsTopologyMapResourceDetailsView').remove();
 
File dnms/resources/dbspecific/derby/schema/dnms_common.sql (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 12 | Parallel Line 12 | Parallel
12 version NUMERIC(18) default 1, 12 version NUMERIC(18) default 1,
13 primary key (filterid) , 13 primary key (filterid) ,
14 foreign key (filtertypeid) references FILTERTYPE (filtertypeid), 14 foreign key (filtertypeid) references FILTERTYPE (filtertypeid),
15 foreign key (userid) references USERDETAILS (userid) ); 15 foreign key (userid) references USERDETAILS (userid) on delete cascade );
16 16
17 CREATE table FILTERGROUP ( filtergroupid NUMERIC(15) NOT NULL, 17 CREATE table FILTERGROUP ( filtergroupid NUMERIC(15) NOT NULL,
18 filterid NUMERIC(15) NOT NULL, 18 filterid NUMERIC(15) NOT NULL,
 
File dnms/resources/dbspecific/derby/schema/dnms_default_records.sql (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 2135 | Parallel Line 2135 | Parallel
2135 2135
2136 INSERT INTO TASKSCHEDULER VALUES(1,'DBBACKUPSCHEDULER',2,1,4,-1,-1,-1,1); 2136 INSERT INTO TASKSCHEDULER VALUES(1,'DBBACKUPSCHEDULER',2,1,4,-1,-1,-1,1);
2137 INSERT INTO TASKSCHEDULER VALUES(2,'DBBACKUPPURGESCHEDULER',2,1,5,-1,-1,-1,1); 2137 INSERT INTO TASKSCHEDULER VALUES(2,'DBBACKUPPURGESCHEDULER',2,1,5,-1,-1,-1,1);
2138 INSERT INTO TASKSCHEDULER VALUES(3,'PURGELOGBYCOUNTSCHEDULER',1,1,6,-1,-1,-1,1); 2138 INSERT INTO TASKSCHEDULER VALUES(3,'PURGELOGBYCOUNTSCHEDULER',2,1,6,-1,-1,-1,1);
2139 INSERT INTO TASKSCHEDULER VALUES(4,'REPORTSCHEDULER',1,1,7,-1,-1,-1,1); 2139 INSERT INTO TASKSCHEDULER VALUES(4,'REPORTSCHEDULER',1,1,7,-1,-1,-1,1);
2140 INSERT INTO TASKSCHEDULER VALUES(5,'PURGEREPORTSCHEDULER',1,1,8,-1,-1,-1,1); 2140 INSERT INTO TASKSCHEDULER VALUES(5,'PURGEREPORTSCHEDULER',1,1,8,-1,-1,-1,1);
2141 INSERT INTO TASKSCHEDULER VALUES(6,'PURGEALARMBYCOUNTSCHEDULER',1,1,10,-1,-1,-1,1); 2141 INSERT INTO TASKSCHEDULER VALUES(6,'PURGEALARMBYCOUNTSCHEDULER',1,1,10,-1,-1,-1,1);
 
File dnms/resources/dbspecific/mysql/schema/dnms_common.sql (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 22 | Parallel Line 22 | Parallel
22 primary key (filterid), 22 primary key (filterid),
23 index filtertypeidindex (filtertypeid), 23 index filtertypeidindex (filtertypeid),
24 foreign key (filtertypeid) references FILTERTYPE (filtertypeid) on delete restrict, 24 foreign key (filtertypeid) references FILTERTYPE (filtertypeid) on delete restrict,
25 foreign key (userid) references USERDETAILS (userid) on delete restrict 25 foreign key (userid) references USERDETAILS (userid) on delete cascade
26 )ENGINE=INNODB; 26 )ENGINE=INNODB;
27 27
28 --This Table holds the Grouping details for filters 28 --This Table holds the Grouping details for filters
 
File dnms/resources/dbspecific/mysql/schema/dnms_default_records.sql (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 2136 | Parallel Line 2136 | Parallel
2136 2136
2137 INSERT INTO TASKSCHEDULER VALUES(1,'DBBACKUPSCHEDULER',2,1,4,-1,-1,-1,1); 2137 INSERT INTO TASKSCHEDULER VALUES(1,'DBBACKUPSCHEDULER',2,1,4,-1,-1,-1,1);
2138 INSERT INTO TASKSCHEDULER VALUES(2,'DBBACKUPPURGESCHEDULER',2,1,5,-1,-1,-1,1); 2138 INSERT INTO TASKSCHEDULER VALUES(2,'DBBACKUPPURGESCHEDULER',2,1,5,-1,-1,-1,1);
2139 INSERT INTO TASKSCHEDULER VALUES(3,'PURGELOGBYCOUNTSCHEDULER',1,1,6,-1,-1,-1,1); 2139 INSERT INTO TASKSCHEDULER VALUES(3,'PURGELOGBYCOUNTSCHEDULER',2,1,6,-1,-1,-1,1);
2140 INSERT INTO TASKSCHEDULER VALUES(4,'REPORTSCHEDULER',1,1,7,-1,-1,-1,1); 2140 INSERT INTO TASKSCHEDULER VALUES(4,'REPORTSCHEDULER',1,1,7,-1,-1,-1,1);
2141 INSERT INTO TASKSCHEDULER VALUES(5,'PURGEREPORTSCHEDULER',1,1,8,-1,-1,-1,1); 2141 INSERT INTO TASKSCHEDULER VALUES(5,'PURGEREPORTSCHEDULER',1,1,8,-1,-1,-1,1);
2142 INSERT INTO TASKSCHEDULER VALUES(6,'PURGEALARMBYCOUNTSCHEDULER',1,1,10,-1,-1,-1,1); 2142 INSERT INTO TASKSCHEDULER VALUES(6,'PURGEALARMBYCOUNTSCHEDULER',1,1,10,-1,-1,-1,1);
 
File dnms/resources/dbspecific/oracle/schema/dnms_common.sql (Revision 6018) [Add File Comment] [<<] [Top] [>>]
 
Line 26 | Parallel Line 26 | Parallel
26 version NUMBER (18) default 1, 26 version NUMBER (18) default 1,
27 primary key (filterid) , 27 primary key (filterid) ,
28 foreign key (filtertypeid) references FILTERTYPE (filtertypeid), 28 foreign key (filtertypeid) references FILTERTYPE (filtertypeid),
29 foreign key (userid) references USERDETAILS (userid) ); 29 foreign key (userid) references USERDETAILS (userid) on delete cascade );
30 30
31 create table FILTERGROUP ( filtergroupid NUMBER(15) NOT NULL, 31 create table FILTERGROUP ( filtergroupid NUMBER(15) NOT NULL,
32 filterid NUMBER(15) NOT NULL, 32 filterid NUMBER(15) NOT NULL,
 
File dnms/resources/dbspecific/oracle/schema/dnms_default_records.sql (Revision 6018) [Add File Comment] [<<] [Top]
 
Line 2135 | Parallel Line 2135 | Parallel
2135 2135
2136 INSERT INTO TASKSCHEDULER VALUES(1,'DBBACKUPSCHEDULER',2,1,4,-1,-1,-1,1); 2136 INSERT INTO TASKSCHEDULER VALUES(1,'DBBACKUPSCHEDULER',2,1,4,-1,-1,-1,1);
2137 INSERT INTO TASKSCHEDULER VALUES(2,'DBBACKUPPURGESCHEDULER',2,1,5,-1,-1,-1,1); 2137 INSERT INTO TASKSCHEDULER VALUES(2,'DBBACKUPPURGESCHEDULER',2,1,5,-1,-1,-1,1);
2138 INSERT INTO TASKSCHEDULER VALUES(3,'PURGELOGBYCOUNTSCHEDULER',1,1,6,-1,-1,-1,1); 2138 INSERT INTO TASKSCHEDULER VALUES(3,'PURGELOGBYCOUNTSCHEDULER',2,1,6,-1,-1,-1,1);
2139 INSERT INTO TASKSCHEDULER VALUES(4,'REPORTSCHEDULER',1,1,7,-1,-1,-1,1); 2139 INSERT INTO TASKSCHEDULER VALUES(4,'REPORTSCHEDULER',1,1,7,-1,-1,-1,1);
2140 INSERT INTO TASKSCHEDULER VALUES(5,'PURGEREPORTSCHEDULER',1,1,8,-1,-1,-1,1); 2140 INSERT INTO TASKSCHEDULER VALUES(5,'PURGEREPORTSCHEDULER',1,1,8,-1,-1,-1,1);
2141 INSERT INTO TASKSCHEDULER VALUES(6,'PURGEALARMBYCOUNTSCHEDULER',1,1,10,-1,-1,-1,1); 2141 INSERT INTO TASKSCHEDULER VALUES(6,'PURGEALARMBYCOUNTSCHEDULER',1,1,10,-1,-1,-1,1);
 
  
Legend:
Removed 
Changed
 Added

[Add General Comment] to topic.