| apple | 1 |
| apple | 2 |
| apple | 3 |
| mango | 1 |
| mango | 2 |
| coco | 1 |
| coco | 2 |
| coco | 3 |
| coco | 4 |
| vanila | 1 |
| vanila | 2 |
=IF(B10<>B9,1,C9+1)or
=COUNTIF($A$2:A2,A2)
ticketuid in (select wfinstance.ownerid from wfinstance join wfassignment on wfinstance.wfid=wfassignment.wfid and wfinstance.active = 1 and wfassignment.assignstatus='ACTIVE' and wfassignment.app='PLUSGSR' and assigncode in (:&USERNAME&))
Object Launch Point: MATRECTRANS, Attribute: STATUS
from psdi.server import MXServer
if vISSUETYPE == 'RECEIPT' and vstatus == 'COMP':
# if not mbo.isNull("poline.mrnum"):
user = mbo.getUserInfo()
mboServer = mbo.getMboServer()
commTemplateSet = mboServer.getMboSet("COMMTEMPLATE", user)
commTemplateSet.setUserWhere("TEMPLATEID = 'RECEIVING' ")
commTemplate = commTemplateSet.getMbo(0)
commTemplate.sendMessage(mbo)
Role: Receiving, Type: A Set of Data Related to the RecordObject: POValue: :POLINE.person.PRIMARYEMAIL
validation: itemnum = :itemnum2. Write an Attribute Launch Point
<html>
<body>
<form name="input" action="http://maxhostname:9080/maxrest/rest/os/MX-MEASUREPOINT1?_lid=wilson&_lpwd=wilson" method="POST">
POINTNUM <input name="POINTNUM" value="1111" type="text"> <p/>
ASSETNUM <input name="ASSETNUM" value="11245" type="text"> <p/>
SITEID <input name="SITEID" value="BEDFORD" type="text"> <p/>
DESCRIPTION <input name="DESCRIPTION" value="Vibration check" type="text"> <p/>
MEASUREPOINTID <input name="MEASUREPOINTID" value="" type="number"> <p/>
METERNAME <input name="METERNAME" value="VIBRATION1" type="text"> <p/>
CHARPOINTACTIONID <input name="CHARPOINTACTION.ID1.CHARPOINTACTIONID" value="" type="number"> <p/>
VALUE <input name="CHARPOINTACTION.ID1.VALUE" value="High" type="text"> <p/>
JPNUM <input name="CHARPOINTACTION.ID1.JPNUM" value="JP-111" type="text"> <p/>
PRIORITY <input name="CHARPOINTACTION.ID1.PRIORITY" value="" type="text"> <p/>
<input type="submit" value="Submit">
</form>
</body>
<html>
<body>
<form name="input" action="http://mxhost:9080/maxrest/rest/os/MX-METERS?_lid=wilson&_lpwd=wilson" method="POST">
METERNAME <input name="METERNAME" value="VIBRATION1" type="text"> <p/>
DESCRIPTION <input name="DESCRIPTION" value="Temperature" type="text"> <p/>
METERTYPE <input name="METERTYPE" value="CHARACTERISTIC" type="text"> <p/>
DOMAINID <input name="DOMAINID" value="HLM" type="text"> <p/>
<input type="submit" value="Submit">
</form>
</body>
find/replace "DPB" with "DPx"save and import back it into 7zip xl/vbaproject.bin location
| What is Cognos connection |
| Examine Cognos connection UI elements – create a URL, Login, Logoff |
| Entry properties: General Properties, Permission, Report, Query, Analysis, Job, Agent and Page Properties |
| Navigation – Public and Private Folder |
| Open reports with report name, Go to links, Run reports from a view |
| Run Reports – Prompt Pages, Printing a report and Open in excel |
| View the run history of a report and historical reports |
| Closing and creating quick links to reports – my folder |
| Shortcut and browser bookmark |
| Metadata Modelling |
| Introduction to framework manager |
| Framework manager basics |
| User
interface, navigation, objects |
Windows Server 2016
WebSphere Application Server 9.0.0.7
Db2 Advanced Workgroup Server Edition 11.1.0.0
Maximo Asset Management 7.6.1
Installing Maximo Asset Management 7.6.1 From Start to Finish
#!/bin/bash
HOST1="10.2.4.115"
HOST2="10.2.4.116"
COUNT=4
for myHost in $HOST1
do
count=$(ping -c $COUNT $myHost | grep 'received' | awk -F',' '{ print $2 }' | awk '{ print $1 }' 2>/dev/null)
#count=$count"skj"
# echo $count" ccc"
if [ $count -gt 0 ]; then
# 100% failed
g_count=`grep -c $HOST1 /etc/hosts`
if [ $g_count -eq 0 ]; then
echo "change host1 ip"
`cat /etc/hosts | sed 's/10.2.4.116/10.2.4.115/' > /etc/hosts_tmp`
`cp /etc/hosts_tmp /etc/hosts --reply=yes`
fi
echo "Host : $myHost is UP"
else
g_count=`grep -c $HOST2 /etc/hosts`
echo $g_count
if [ $g_count -eq 0 ]; then
echo "change host2 ip"
`cat /etc/hosts | sed 's/10.2.4.115/10.2.4.116/' > /etc/hosts_tmp`
`cp /etc/hosts_tmp /etc/hosts --reply=yes`
fi
echo "Host : $myHost is down"
fi
done
access-list 1 permit 192.168.1.0 0.0.0.255
ip nat pool pool1 1.1.1.50 1.1.1.50 netmask 255.0.0.0
ip nat inside source list 1 pool pool1 overload
int fa0/0
ip nat inside
int fa0/1
ip nat outside
show ip nat translation
|
Route Source
|
Default Distance Values
|
|
Connected
interface
|
0
|
|
Static route
|
1
|
|
Enhanced Interior
Gateway Routing Protocol (EIGRP) summary route
|
5
|
|
External Border
Gateway Protocol (BGP)
|
20
|
|
Internal EIGRP
|
90
|
|
OSPF
|
110
|
|
Intermediate
System-to-Intermediate System (IS-IS)
|
115
|
|
Routing
Information Protocol (RIP)
|
120
|
|
Exterior Gateway
Protocol (EGP)
|
140
|
|
Unknown*
|
255
|
netstat –aon | find "<port number>"Example:netstat -ano -t | findstr LISTENING | findstr :8080
taskkill /F /pid xxx
taskkill /im notepad.exe
Tip: to find a string in a file using findstr:findstr /i "helloworld" abc.txtorfindstr /i "^hell*rld" abc.txt
netstat -tulpn | grep LISTEN | grep '(8080 |8081 |8082 | xxx)'
$ lsof -i tcp:1555