Solutions
| ID: | S141379 | |
| Published: | 17 September 2020 | |
| Updated: | 24 September 2020 |
Operating System(s)
- All Windows
Product(s)
- SBM
- Service Manager
Description
This customization adds a Header and Footer to the top and bottom of Work Center interface in SBM. Customers often use this change to create a notice that the system is a TEST or Development environment. Government customers can also use this for system classification notifications. Note that only one header and footer are allowed per server, and they are not specific to a particular user or group.
If you are running SBM 10.x, follow the steps in KB S141224.
SBM classification headers appear on all pages in User Workspace, Work Center, Application Administrator, and in item views and embedded or standalone reports. As an example, the header and footer will look like this:
Resolution
To enable this feature in SBM:
STEP 1: Enable the header footer classification feature
NOTE: You will need to make a change directly in the database. Consult your DBA if necessary.
- Check to see if you have the 'ShowClassificationBanners' value in the database already by running the following sql.
Select * from TS_SYSTEMSETTINGS where TS_NAME='ShowClassificationBanners'
- If a row is returned, change the TS_LONGVALUE to 1 (to enable headers and footers) or set the value to 0 (to disable headers and footers). This SQL with enable the feature:
- If no row was returned, you will need create add the row by following these steps:
- Increase the LASTID value using this command:
update TS_LASTIDS set TS_LASTID=TS_LASTID+1 where TS_NAME = 'SystemSettings'
- Find the new value of the LASTID using this command:
select TS_LASTID from TS_LASTIDS where TS_NAME = 'SystemSettings'
- Add the missing row by running this command. Be sure to change the 99999 to the value from step 2.
Insert into TS_SYSTEMSETTINGS ( TS_ID,TS_NAME,TS_DATATYPE, TS_LONGVALUE, TS_LONGDEFAULT ) values (99999,'ShowClassificationBanners', 1,1,1)
- If you are running Oracle, don't forget to run the COMMIT command to finalize your SQL changes.
STEP 2: Update the text to be displayed
- Open SBM System Administrator and connect to the database. *Leave the System Administrator open.*
- To edit the header:
- Edit the file C:\Program Files\Serena\SBM\Application Engine\template\banners\header.htm
- At the bottom, you will see the default sample header "This is a production system header!". Change this text as needed.
NOTE: The header is wrapped with a <div class="banner-top"> tag. This is critical for the header placement. Do not change this tag. - Save the file.
- To edit the footer:
- Edit the file C:\Program Files\Serena\SBM\Application Engine\template\banners\footer.htm
- At the bottom, you will see the default sample header "This is a production system footer!". Change this text as needed.
NOTE: The header is wrapped with a <div class="banner-bottom"> tag. This is critical for the header placement. Do not change this tag. - Save the file.
- In the SBM System Administrator, and go to File > Put Files in Database
- Perform an IIS restart
- Log into SBM and verify the header and footer display. Once you are happy with the changes, you can close the System Administrator.
