Archive for category: Articles

It is pretty common for a Lawson recurring job to error out and continually run for hours and days. This can build up in the waiting screen of the job scheduler (jobschd). To clean it up can be repetitive when it doesn’t have to be.

1. Login to LID
2. Go to the job scheduler by typing the jobschd command
3. F7 >> A. to show all user jobs
   • In our example we have 7 jobs, but this method works for hundreds of jobs.
4. On the top most job that you want to delete press the HOME key to “mark” the job. Notice the black arrow on the very left
   
5. Now scroll down or even page down to the bottom most record >> Press the END key. Notice all jobs from the top to bottom have the black arrow on the left, indicating these are selected.
   
6. Now press F9 (Delete) to remove these jobs. Press enter to confirm.
   • NOTE: if there are dozens or hundreds of jobs, you may need to hold Enter to continuosly delete them.

Hope this was helpful!

LBI Smart Notifications are reports that are sent directly to users for reviewing vs a user logging into LBI to manually view a report. In this section we will first start off with an Intro to creating a Smart Notification. See Part 1 titled: “Creating an LBI Smart Notification Series – Creating an InfoSet (Part 1)”

1. Login into LBI (admin permission required) >> go to Tools >> Select Smart Notification
2. In Smart Notification, select Notifications at the top
   • If you have none, it’ll say No Selections (see screenshot), else you’ll notice a list of existing Notifications
     
3. To create a new Smart Note, click Add
   
   
4. Smart Notification Wizard will pop-up and starts at step 1 (Select Facts)
   
   • The Facts section is where you would connect the dataset (or InfoSet) to the notification (this can also be a document among varios other types of data).
   • An InfoSet is most commonly an SQL query or stored Proc that gathers data from a database.
5. For this example, we will assume you have an InfoSet already created. View your InfoSets by clicking Search
   
   
6. For our example we will be selecting the MonlthyVariance InfoSet and then select Range
   
7. At the bottom of the next page choose Select >> Add >> Ok at the very bottom
   
   
8. At the bottom under My Selections you should now see your InfoSet for step 1
   
9. Now click Next or select step 2 Conditions
   • Conditions can be added with the Add button. This lets you tailor the data to your liking. This can also be done on the InfoSet side when writing a query or stored proc.
10. Click Next again or select step 3 Delivery
    • Delivery typically is done through the Device tab which are setup email addresses in Smart Notes (See article titled “How to setup a LBI smart note delivery device”)
    • The Bursting tab is the alternate method. In the Bursting tab select the InfoSet, and the column to burst on which is typically a list of email addresses.
    • Schedule tab is similar to Device, except on a schedule which can be set elsewhere for the Notification.
11. Click Next again or select Step 4 Related Info
    • Related Info lets you link other LBI reports, shared documents, deploy in a pre-made formatted template among other customizations. This may be covered in more depth in a future article.
12. Click Next again or select Step 5 Save
    • This is where you Name, describe, set Home Page Group for your Notification.
    • You can also Preview, set Status, and add additional Permissions if needed.
13. Click Save New Item to create your new notification and view it in the Notifications Tab.

Hope this was helpful! Good luck!

The default behavior of the shopping screen in RQC is to now allow users to select their Requesting Company.  To allow users to select the company, the rqc_config.xml file must be updated.  Navigate to LAWDIR/system and open the rqc_config.xml file in a text editor.  In the “client” section, update the setting “allow_company_select” to “true”.  Bounce the WebSphere application server for the change to take effect.

This process is going to assume you already know how to build a Lawson CSV report of users to compare against. LSA Report Maintenance has these report options available for this.

1. Login into your windows machine and open Powershell as an Administrator.
2. Type in this command: Get-ADUser -Filter * -SearchBase “dc=domain,dc=local” | select Name,SID | Export-CSV
   1. dc=domain,dc=local will need to be updated to match your organizations.
   2. select Name,SID will extract the users Name in AD (typically First and Last Name) and their Security ID.
   3. Since we are doing this to compare against Lawson users (assuming you’re using SSOP), you want to also include the sAMAccountName, this is login name the users use to login into their windows machine.
   4. Export-CSV Requires a path after it including filename,
      • example: Export-CSV C:\ExportDirectory\ADUserList.csv
3. For example, if you only wanted the Name and sAMAccountName use the command below:
   1. Get-ADUser -Filter * -SearchBase “dc=Yourdomain,dc=Yourlocal” | select Name,sAMAccountName | Export-CSV C:\ExportDirectory\ADUserList.csv
      • NOTE: If you type dc=domain,dc=local incorrectly, Powershell will list the allowed partition(s), see screenshot below.
        
4. If you only want Name and SID use the command below:
   1. Get-ADUser -Filter * -SearchBase “dc=Yourdomain,dc=Yourlocal” | select Name,SID | Export-CSV C:\ExportDirectory\ADUserList.csv

You should now be able to acquire the CSV file in your C:\ExportDirectory\ that you outputted to.

Good luck!