Find attachments in DOCLINKS for each record

This post explains how to extract the list of attachments attached to a record.

Unfortunately, from the file names you cannot understand to which records each file is linked to. In order to do this you have to run an SQL query. In this example I'm showing how to get all the file names of work orders attachments.

How to get current month records since first date in database query?

To get the records for the current month since day one of current month you may use the below where clause.

How to create a custom Auto-Number for attribute in Maximo

Follow the below steps to add autonumber for the attribute and add seed and key to the autonumber.

Deleting a user-created application in Maximo

You must use a database editor such as SQL Developer, DB Visualizer etc to delete the user created application.