Maximo Open Forum

Hello All, 

I'm looking for a little bit of help creating a query in Maximo. My SQL is a little rusty and I can't quite figure out how to query what I want. I am trying to find all closed work orders where the status date is greater than X amount of days past the reported date. We would like to see how many "backlogged" WOs we have had, and we are going to classify "backlogged" as any work order where it took more than ~60 days to close. I know this won't be perfect, but it will get us something to work with. I will hopefully be improving the data entry/tracking moving forward.

For example, find all closed WOs where the status date(in theory the date they were closed) is more than 60 days past the date they were reported. 

Also, if anyone else had a different approach to this problem please feel free to share. 

Thanks!

Hi Brett, try this:  select wonum, description, round(changedate-reportdate,1) as days from maximo.workorder where status = 'CLOSE' and istask = 0

and changedate - reportdate > 60;

Hello All, 

I'm looking for a little bit of help creating a query in Maximo. My SQL is a little rusty and I can't quite figure out how to query what I want. I am trying to find all closed work orders where the status date is greater than X amount of days past the reported date. We would like to see how many "backlogged" WOs we have had, and we are going to classify "backlogged" as any work order where it took more than ~60 days to close. I know this won't be perfect, but it will get us something to work with. I will hopefully be improving the data entry/tracking moving forward.

For example, find all closed WOs where the status date(in theory the date they were closed) is more than 60 days past the date they were reported. 

Also, if anyone else had a different approach to this problem please feel free to share. 

Thanks!

Hello All, 

I'm looking for a little bit of help creating a query in Maximo. My SQL is a little rusty and I can't quite figure out how to query what I want. I am trying to find all closed work orders where the status date is greater than X amount of days past the reported date. We would like to see how many "backlogged" WOs we have had, and we are going to classify "backlogged" as any work order where it took more than ~60 days to close. I know this won't be perfect, but it will get us something to work with. I will hopefully be improving the data entry/tracking moving forward.

For example, find all closed WOs where the status date(in theory the date they were closed) is more than 60 days past the date they were reported. 

Also, if anyone else had a different approach to this problem please feel free to share. 

Thanks!

Hello All, 

I'm looking for a little bit of help creating a query in Maximo. My SQL is a little rusty and I can't quite figure out how to query what I want. I am trying to find all closed work orders where the status date is greater than X amount of days past the reported date. We would like to see how many "backlogged" WOs we have had, and we are going to classify "backlogged" as any work order where it took more than ~60 days to close. I know this won't be perfect, but it will get us something to work with. I will hopefully be improving the data entry/tracking moving forward.

For example, find all closed WOs where the status date(in theory the date they were closed) is more than 60 days past the date they were reported. 

Also, if anyone else had a different approach to this problem please feel free to share. 

Thanks!