How to add the Creation Time column in readable date format

Products

• Spectrum
• Network Observability

Issue/Introduction

How to add the Creation Time column to the Test Hosts List tab?

I want to add the Creation Time as a column to the OneClick Users List tab.

How do you convert a time based attribute value in unix time to a readable date and time format? The column appears but the value is the raw unix time stamp.

Environment

All supported Network Observability DX NetOps Spectrum OneClick releases

Resolution

Test Host List Tab Steps

In order to add an extra column in the Test Host List tab, you have to create the following directory structure on the OneClick web server machine:

$SPECROOT/custom/spm-oc/config/ directory

Create the following file under the $SPECROOT/custom/spm-oc/config/ directory:

table-testhost-config.xml

Add the following entries in the table-testhost-config.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<table idref="table-testhost-config">
     <column-list>
          <column>
               <name>Creation Time</name>
               <content>
                     <attribute>0x11b41</attribute>
                     <renderer>
                          com.aprisma.spectrum.app.util.render.DateRenderer
                     </renderer>
               </content>
               <hidden-by-default>false</hidden-by-default>
              <swing-cell-template>
                   <text>
                       <renderer>
                            com.aprisma.spectrum.app.util.render.CommentedTextRenderer
                      </renderer>
                 </text>
              </swing-cell-template>
          </column>
     </column-list>
</table>

Save the changes.

No tomcat restart is necessary. Simply close any open OneClick Java clients or WebApp tabs. Open a new one and display the custom column.

Users List Tab Steps

In order to add an extra column in the Users List tab create a copy of the following file.

$SPECROOT/Spectrum/tomcat/webapps/spectrum/WEB-INF/admin/config/table-userlist-config.xml

Place the copy of the file in the following directory new directory. The directory will need to be created and given directory permissions of 750 to match others.

$SPECROOT/custom/admin/config

Add the following entries in the $SPECROOT/custom/admin/config/table-userlist-config.xml file:

	  <column>
		   <name>Creation Time</name>
		   <content>
				 <attribute>0x11b41</attribute>
				 <renderer>
					  com.aprisma.spectrum.app.util.render.DateRenderer
				 </renderer>
		   </content>
		   <hidden-by-default>false</hidden-by-default>
		  <swing-cell-template>
			   <text>
				   <renderer>
						com.aprisma.spectrum.app.util.render.CommentedTextRenderer
				  </renderer>
			 </text>
		  </swing-cell-template>
	  </column>

Save the changes.

No tomcat restart is necessary. Simply close any open OneClick Java clients or WebApp tabs. Open a new one and display the custom column.

Additional Information

Completed customizations for the Creation Time column should show values similar to these.