Schedule this Batch to Download via FTP | Windows

We can use Linux-based utilities which are more secure and available for windows, like "wget" and "WinSCP" which is also a good option, but I preferred to stay in windows using the default old FTP command. Or we also can use Powershell instead of the old command-prompt-based batch file.

Anyhow, below is just one windows command using echo to redirect the text in a file and then the file will be called by FTP.

Just Run or you can write this command in a batch file to schedule.

cd /d "C:\Users\AQ\INTEGRATION\download"

echo open 10.152.30.229 >> ftp.txt & echo user myuser mypassword >> ftp.txt & echo binary >> ftp.txt & echo get "filename.dat" >> ftp.txt & echo bye >> ftp.txt & ftp -n -v -s:ftp.txt & del ftp.txt

1. 1st line is the path, where you want to download. 

2. Replace myuser and mypassword with the real FTP user credentials.

3. This script will create a file ftp.txt, and at the end of the line: this file is called by FTP before deletion. 

Note: Security concerns: username and password are written here. 

We also can use power sh

Stop Workflow in BULK by Escallation | IBM Maximo

Lets say we want to stop the workflow for multiple PRs at once. We can achieve this creating a new escalation and schedule it perform this action automatically.

for instance, we want to stop PR-123 from backend, for that we are going to create a escalation and once action which will be attached with this escalation.


STOPWF_PR    Stop PR Workflow
Applies to: WFINSTANCE

Condition:
active = 1 and ownertable = 'PR' and exists (select 1 from PR where PR.PRID = wfinstance.ownerid and prnum in ('PR-123')
)

Schedule: Your desired time and date. suppose every 1 minute

Escalation point: Add a row only, no need to enter anything
 
Action : STOPWF
Create a new action and attached to this escalation
 
Action: STOPWF Stopwork
Type: Custom Class
Custom Class: psdi.workflow.StopWorkflowAction (auto populated)
Accessible from:
ESCALATION

Keyboard Shortcuts | IBM Maximo

You can use a combination of keys to perform an action without using a mouse. 

Standard keyboard shortcuts

You can navigate among and within the applications by using a combination of keys. You can use the following keyboard shortcuts to navigate the application screens.

Action	Keyboard shortcut
Move from one interface element to the next.	Tab key
Select buttons, links, and menu options.	Enter key
Select or clear a check box.	Spacebar
Display field help for field in focus.	Alt+F1

Keyboard shortcuts for global navigation

Link name	Keyboard shortcut
Bulletins	Alt+B
Go To	Alt+G
Reports	Alt+R
Start Center	Alt+C
Profile	Alt+P
Sign Out	Alt+S
Help	Alt+H
Return	Alt+R
Return with Value	Alt+W

Open Specific Record Through URL Link In Email Using Relationship in Communication Template | IBM Maximo

There is user requirement of opening specific application record in maximo when users clicks the url link on email.

Let us take an example of email notification for condition monitoring app. We have communication template which is setup on MEASUREMENT object. But we want to open the specific record of condition monitoring app which has object MEASUREPOINT. We will use it using relationship substitution variable to get the unique id of application record (:MEASUREPOINT.measurepointid).

OBJECT: MEASUREMENT

RELATIONSHIP: MEASUREPOINT

UNIQUE ID: MEASUREPOINTID

SUBSTITUTION VARIABLE: :MEASUREPOINT.measurepointid

How to Make The Hover Info Boxes Stay Up Longer In Scheduler And Graphical Assignment | IBM Maximo

The information/tool tip only displays for a short period of time and goes away too fast. You could use  the Maximo System Properties application to change the duration of the tool tips on Scheduler and Graphical Assignment

• Go To System Properties

• Change the parameter of following properties given below:

Adding Custom Hovers On Field Using Relationships | IBM Maximo

IBM Maximo has provided default Hover windows for some fields. We will explain how to add custom hover window in maximo using custom relationship.

If you want to display the PR Line Item record hovering. The custom relationship can be used with PRLINE object relationship to INVENTORY to retrieve storeroom item information.

• Go to Database Configuration
• Object: PRLINE 
• Create Relationship: PRL_INVENTORY
• Child Object: INVENTORY.
• Where Clause: itemnum=:itemnum and itemsetid=:itemsetid and location=:storeloc and siteid=:siteid

Revised Maximo 76 Report Administration and Feature Guide | Maximo

This guide highlights on the Administration process of the Maximo BIRT reporting functionality.

It starts with an overview of the installation process, file and database structure, and then moves into reviews of scheduling, emailing and security. It concludes with detailed reviews of each of the Report Administration actions, along with property settings and cron tasks. Throughout the guide, best practice recommendations are highlighted.


http://www-01.ibm.com/support/docview.wss?uid=swg21696690

Stop Work Order Creation When The Asset is Down (Condition Monitoring) Using Automation Script | IBM Maximo

Maximo will not (automatically or manually) create work order from condition monitoring when the selected asset is down using the following automation script.

• Launch Point: Object Lauch Point
• Business object:  WORKORDER
• Script Language: Python
• Variables: 
• asset (bind variable isrunning using relation MEASUREPOINT.ASSET.ISRUNNING)
• point (bind variable POINTNUM)
• Event: Save, Add, Before Save

How to create a READ_ONLY User in Database | Oracle

1. connect with sqlplus with dba rights

sqlplus / as sysdba

2. create a simple user and give password:

create user test identified by test;

3. Give some grants to newly created user, like create session, and select

grant CREATE SESSION to test;
grant SELECT ANY TABLE to test;

:)

How to Find Serial Number of your Computer | Windows

run this command in your command prompt:

WMIC BIOS GET SERIALNUMBER

Generate Alert Notification on Condition Monitoring Warning Limits Using Escalations | IBM Maximo

We can generate alert notification email in IBM Maximo condition monitoring application when the measurement value of gauge meter crosses the upper or lower warning limit. The following escalation will generate the email when the measurement value for the asset meter is between upper and lower warning and action limits.

1. OBJECT:          MEASUREMENT

Stop Work Order From Closing or Completing Without Entering Actual Labor (Including Task Labor Work Order Array) | IBM Maximo

We will use automation script from stopping users from closing or completing workorder without actual labor transaction which also includes task work order labor array.

• Launch Point: Object Lauch Point
• Business object:  WORKORDER
• Variables: 
• var_act_lab bind with array using relation LABTRANS.LABTRANSID*
• var_task_lab  bind with array of task work order relation WOACTIVITY.LABTRANS.LABTRANSID*
• Create error message in database configuration with errorgroup = 'wo' and errorkey = 'act_lab_exists'
• Condition: :status in ('COMP', 'CLOSE')

How to Fix VirtualBox “UUID already exists” Errors | Virtual Box

C:\Program Files\Oracle\VirtualBox>VBoxManage internalcommands sethduuid “c:\your_vdi_file_path.vdi”

Syslog Configuration in Routers | Cisco

Syslog Configuration in Packet Tracer

router >
enable
configure terminal
int fa 0/1
ip address 192.168.0.100 255.255.255.0
no shutdown
exit
logging 192.168.0.1 #ip of syslog server

now connect a Syslog server with router int fa0/1
and set ip same as mentioned in logging 192.168.0.1


:) we are done.

Port Mirroring, Switch Port Analyzer (SPAN) or Sniffing | Cisco

Port Mirroring, Switch Port Analyzer (SPAN) or Sniffing

switch>
enable
config terminal
monitor session 1 source inter fa 0/1
monitor session 1 source inter fa 0/2
monitor session 1 destination int fa 0/24
exit
show monitor

done:)

Anonymize or Replace text within a File using SED | Linux

Stream Editor aka 'sed' is a *nix utility to transform and parse text.

for example.
if a file testing.txt contains some text like ' helloworld.zip ',  it will be replace with any text or we can use $RANDOM function also.

sed s/hello.*zip/"hello://$RANDOM.zip"/g testing.txt

the final result will be like this:

hello12345.zip (any random number)

/g means all occurrence of this text

Find and Delete All Files Older than 10 Days using mtime | Linux

#to file files older than 10 days:

find /home/folder/ -mtime +10;

#now append it with -exec switch +  rm {} loop to delete all found files:

find /home/folder/ -mtime +10 -exec rm {} \;

----------------------
#and to find only in specific directory ignore sub directories

find /home/folder/ -maxdepth 1 -mtime +10

Install and Configure Target iSCSI Server on Windows Server 2012 | Windows

1. in Add new Role and Feature > Navigate to Server Roles
2. under File and Storage Services > Check iSCSI Target Server > > Install.

3. again in Server Manager, a new File and Storage Services has added,
Click on Launch the new Virtual Disk wizard to create Virtual Disk

Select iSCSI virtual disk Location: Select Drive/ or custom Path
Next
Specify iSCSI virtual disk size:  10GB
iSCSI Target. New iSCSI Target > Next
Target Name and Action : any name > Next
Access Servers (list initiators so the disk be presented to only these): ADD by IQN or IP etc
Next > Create(b).
Close(b).
-------------------------------
on Client as Initiator: 

Start iSCSI Initiator
Targets(T): Target: enter IP (ie. 10.1.1.100), Quick Connect(b)
Done(b)

now verify in Disk Management, a new disk is added with 10GB space. 

Creating a Dialog Window | IBM Maximo

You can add a new dialog window to a specific application or you can make it

available for use by all applications. You must modify an XML file to create a

dialog window and import the modified file into the Application Designer. After

importing it, you can modify the new dialog window in the Application Designer.

Procedure:

• In the Application Designer, export one of the following XML files:

• In the List tab, click Export System XML in the Select Action menu to export the library.xml file if you want to add a new dialog for use by all applications.

• In the Workspace tab, click the Export Application Definition icon to export the presentation.xml file if you want to add a new dialog for use by a specific application.
• The XML definition opens in a new browser window.
• Save the XML definition to a local file and open it with a text editor.

Enforce Unique Key & Fetch Records From Unsaved MBO Using Automation Script | IBM Maximo

This automation scripts describes the enforcing of unique key to the object, Fetching and looping through unsaved rows of MBO Set from memory.

We have taken the example of restricting the users from selecting same itemnum multiple times in spare parts of asset. It works on both saved and unsaved objects.

Launch Point: Attribute Lauch Point

Business object:  SPAREPART

Attribute: ITEMNUM

Variable: ar_item bind with ITEMNUM of object SPAREPART

Increase The Workflow Map Display Size Maximo | IBM Maximo

Please follow the provided steps below:

• Go to Directory  ...\maximo\applications\maximo\maximouiweb\webmodule\webclient\css
• Search for the file maximo.css
• Change the height/width in the wfmd tag which looks like this:

         /* wfmapdiv */
         .wfmd
         {
         width:800px;
         height:375px;
         border:1px solid #999999;
         overflow:auto;
         }

Increase "Systems" Window Display Size On Asset/ Location Drilldown | IBM Maximo

Some users complaint that the "Systems" window display size is very small on asset/ location drilldown as shown in the screenshot below.




Solution:

1. Open the Application Designer and select the Export System XML action from the menu. 
2. Click on the small arrow for the LIBRARY row to export the file. 
3. Open the XML file with a good text editor and search for "system".

Synchronizing Active Workflow Processes without Creating Revision of Main Process | IBM Maximo

A workflow process can include one or more sub-processes. When you modify a sub-process, you must update the main process so that it uses the revised sub-process. This process is known as synchronization.

You must enable the sub-process revisions before you can synchronize a workflow process.

Solution:

1. In the Workflow Designer application, Create the sub-process revision and Enable it.

Assigning Meters/ Meters Group To Multiple Existing Assets Using Asset Templates | IBM Maximo

1. Click Go To > Assets > Asset Templates
2. Click on ‘New Asset Template’
3. Click on ‘Meters’ tab and enter the following.
4. Do not enter any other detail on asset template (except template code and description).
5. Save the record

Difference between sqlplus /nolog & Sys as sysdba

sqlplus /nolog :
you are not connecting to any user, instance or database;

sqlplus / as sysdba :
you are connected with 'SYS' through os authentication if enabled with ORACLE_SID.