Weblogic 9: Security Realms and Deleting Cache

NOTE: We are unable to send the ETX data to NAG standalone system.

If you delete the cache of a standalone instance of maximo, you will have to go recreate any users that were set up... like the maximouser

Ok.. I had to add it to a group called maximousers as well.

Weblogic - STATE is ADMIN mode...UGGGGH!

Here is a running list to help when your server is in the STATE: ADMIN
Check the Error log... it will most of the time tell you whats wrong...

ERROR:
ORA-28000: the account is locked
FIX:
A password may have changed or you lock the schema owner on the database...
Check your maximo.properties file mxe.db.password= and weblogic in your Service>JDBC>Data Sources>NAMEOFSOURCE>Connection Pool>Password:

[MAXIMO] Importing Reports

Import the reports
Note: Edit the file \reports\birt\tools\reporttools.properties according to your environment configuration.

1. Run the IMPORTREPORTS tool for the LIBRARIES in the command prompt:
\reports\birt\tools\importreports.cmd libraries

2.Run the IMPORTREPORTS tool for the REPORTS in the command prompt:
\reports\birt\tools\importreports.cmd

3.Login to Maximo application

4.Go To Administration -> Reporting -> Report Administration

5.On List tab, click on the “Generate Request pages” button

Note: this process may take a few minutes to complete

Note: If you have more than one instance of maximo on the box, you want to make sure you use the host name or IP of the instance that will access the reports instead of the computername.
reportools.properties

# HostName or IP address of the machine that has MAXIMO application running in an App Server
maximo.report.birt.hostname=IP-ADDRESS
# HTTP port of the application server (the port used to access maximo from browser)
maximo.report.birt.port=80
# Indicates whether the SSL communication is enabled or not
maximo.report.birt.ssl=false
# User that has access to perform the operation
maximo.report.birt.username=maxadmin
# Password of the user that has access to perform the operation
maximo.report.birt.password=##########
# Output folder used for the export operation
maximo.report.birt.outputfolder=./../../birt

Get IP Addresses from a list of Servers

two files:

server_list.txt - this is your list of SERVERS
SERVER_IP.txt - Outputfile

@echo off
FOR /F %%G IN (server_list.txt) DO CALL :setvars %%G %%h
:setvars
SET COMPUTER=%1

FOR /F "tokens=2 delims=[]" %%A IN ('PING %Computer% -n 1') DO (
SET IP=%%A
)

echo. %COMPUTER% %IP% >> "SERVER_IP.txt"

goto:eof

Get File Size of any file

@echo off
FOR %%A IN (C:\APP\log.txt) DO SET FileSize=%%~zA
echo %filesize%
pause

Is someone's account locked?

With the native NET command:

NET USER loginname/DOMAIN | FIND /I "Account active"

The account is either locked ("Locked") or active ("Yes").

With the native NET command:

NET USER loginname /DOMAIN /ACTIVE:YES

or, if the password needs to be reset as well:

NET USER loginname newpassword /DOMAIN /ACTIVE:YES

Highlighting Cells Containing Specific Text

=NOT(ISERR(SEARCH("RUNNING",A1)))



You can use the conditional formatting feature in Excel to help draw attention to cells that contain specific text in which you are interested. For instance, if you have a range of cells and you want to know which ones contain the letters "shawn," then you can do the following in versions of Excel prior to Excel 2007:

Select the range of cells.
Choose Conditional Formatting from the Format menu. Excel displays the Conditional Formatting dialog box. (Click here to see a related figure.)
In the drop-down Condition list, choose "Formula Is".
In the formula box, enter the following formula. (Make sure you replace A1 with the cell address of the cell in the upper-left corner of the range selected in step 1.)
=NOT(ISERR(SEARCH("Shaw",A1)))
Click on Format. Excel displays the Format Cells dialog box. (Click here to see a related figure.)
Using the controls in the dialog box, specify a format that you want used for those cells that contain the specified text. For instance, you may want bold text in a red typeface.
Click on OK to close the Format Cells dialog box.
Click on OK to close the Conditional Formatting dialog box.
If you are using Excel 2007 then you should follow these steps, instead:

Select the range of cells.
With the Home tab of the ribbon displayed, click the Conditional Formatting option in the Styles group. Excel displays a palette of options related to conditional formatting.
Choose Highlight Cells Rules and then choose More Rules from the resulting submenu. Excel displays the New Formatting Rule dialog box.
In the Select a Rule Type area at the top of the dialog box, choose Use a Formula to Determine Which Cells to Format. (Click here to see a related figure.)
In the Format Values Where This Formula Is True box, enter the following formula. (Make sure you replace A1 with the cell address of the cell in the upper-left corner of the range selected in step 1.)
=NOT(ISERR(SEARCH("Shaw",A1)))
Click Format to display the Format Cells dialog box.
Using the controls in the dialog box, specify a format that you want used for those cells that contain the specified text. For instance, you may want bold text in a red typeface.
Click OK to dismiss the Format Cells dialog box. The formatting you specified in step 7 should now appear in the preview area for the rule.
Click OK.
You can make this approach even more general-purpose in nature by specifying a cell that contains what you want to search for. For instance, if you type "Shaw" in cell F7, then you could replace the formula in step 4 or step 5 with the following:

=NOT(ISERR(SEARCH($F$7,A1)))
Now, you can search for something different just by changing the characters in cell F7.



REF: http://excel.tips.net/Pages/T002671_Highlighting_Cells_Containing_Specific_Text.html