List of Contributions

Brian Swanson

Contact Details

My Content

1 to 12 of 12 total

RE: Calculate Duration between status dates

Posted By Brian Swanson Feb 4, 2021 11:29 AM
Found In Community: Maximo Open Forum \ view thread
HI Rob, This is something I did for a result set and a KPI, perhaps you could use parts of it to get what you need. This looks at all workorders generated for the previous month that I compare the status change and the change took between 3 and 5 days. This is in SQL Server and you would substitute "YOURSTATUS ...

RE: Select workorders generated from previous week

Posted By Brian Swanson Jan 7, 2021 12:39 PM
Found In Egroup: Maximo Open Forum \ view thread
HI Aaron, I think I got it. I may need to deal with the timestamp, but seems to be working.. Thanks.. select wonum, reportdate from workorder where reportdate > dateadd(day, -datepart(weekday, getdate()), getdate()) - 6 and reportdate < dateadd(day, -datepart(weekday, getdate()), getdate()) order ...

Select workorders generated from previous week

Posted By Brian Swanson Jan 7, 2021 11:37 AM
Found In Egroup: Maximo Open Forum \ view thread
HI all, In SQL Server, I'm attempting to create a query that will select all workorders based on the reportdate generated the previous week, no matter what day of the current week I'm in. I did this for a monthly view, but struggling with the weekly range. I have looked at the datepart function, but ...

RE: Auto Load Work Center Inspections

Posted By Brian Swanson Dec 18, 2020 8:33 AM
Found In Egroup: Maximo Open Forum \ view thread
Thanks Steven Shull , That video was very good. Exactly what I needed. I would love to see some of the automation scripts they did. That tab for the Inspection details was also very good. They did mention that there were scripts in Maximo that auto create workorders when an inspection fails. I'm ...

Auto Load Work Center Inspections

Posted By Brian Swanson Dec 15, 2020 4:02 PM
Found In Egroup: Maximo Open Forum \ view thread
HI All, has anyone attempted to load Inspection forms using MXLoader or any other means instead of manually creating them? Thanks #Integrations ------------------------------ Brian Swanson Herman Miller ------------------------------

RE: Inspection form can't retrieve Meters

Posted By Brian Swanson Oct 14, 2020 11:39 AM
Found In Egroup: Maximo Open Forum \ view thread
Thanks Alex, that helped. I can select the meter in the form now, but when I go to do the inspection, I'm getting an error the meter is not available in the selected asset or location.. ------------------------------ Brian Swanson Herman Miller ------------------------------

RE: Inspection form can't retrieve Meters

Posted By Brian Swanson Oct 13, 2020 4:54 PM
Found In Egroup: Maximo Open Forum \ view thread
Sorry, we are on 7.6.09 ------------------------------ Brian Swanson Herman Miller ------------------------------

Inspection form can't retrieve Meters

Posted By Brian Swanson Oct 13, 2020 1:23 PM
Found In Egroup: Maximo Open Forum \ view thread
HI All, I'm attempting to create a new Inspection form including a Meter reading. When I go to select the meter, it can't find any records. I have verified the meter is in the Meters group and active. I have also looked the the API objects associated to Meters and made sure they were flagged for Flat ...

RE: Blank Page when logging into the Maximo Work Centers

Posted By Brian Swanson Sep 28, 2020 7:39 AM
Found In Egroup: Maximo Open Forum \ view thread
Biplab, Looks like you are right. Getting the null connect. I will keep working on the config.json. I'm sur it's just something commented out or the url isn't correct. Thanks [maximo-remote-notification::_flattenBehaviorsList]: behavior is null, check for missing or 404 import Brian Swanson Maximo ...

RE: Blank Page when logging into the Maximo Work Centers

Posted By Brian Swanson Sep 26, 2020 10:15 AM
Found In Egroup: Maximo Open Forum \ view thread
Thanks Lacey. I did some research and I may need to configure the config.json and possibly the web.xml. Now it is somehow redirecting the primary maximo login to the maximo-x login.

Blank Page when logging into the Maximo Work Centers

Posted By Brian Swanson Sep 25, 2020 1:06 PM
Found In Egroup: Maximo Open Forum \ view thread
This may have been posted already, but did not find anything in a search, but I deployed the maximo-x war file on Websphere and I'm getting a blank page when logging in. I read somewhere that there may be some other configurations with config.json files? Any advise would be much appreciated. Thanks ...

Rest API's and Database views

Posted By Brian Swanson Sep 15, 2020 8:29 AM
Found In Egroup: Maximo Open Forum \ view thread
Is it possible to retrieve data from a database view using a REST API? #Customizations ------------------------------ Brian Swanson Herman Miller ------------------------------