Asset operational state report what does it mean 0 and -1

[Nikolaj]

Hello Support,

Can you help me where i can find the answer for our asset operational state. In the database direct i cannot switch between "Use Column Display Names" and "Use Column Database Name" nothing happen. And i can only find something about asset operational state 1, 2 and 3.

But in my report it shows 0 and -1.

Thanks

Nikolaj

[Steve Giller]

The value will be -1 if the Operational State is blank:

[Nikolaj]

HI @Steve Giller thanks for your help. In our case it looks like this after some deeper look with service manager reports. I found out that

-1 = Archived

0 = Active

But anyway thanks and best regards

Nikolaj

 

 

[Steve Giller]

@Nikolaj Just to clarify - are you wanting the value for "State" or "Operational State" here?

They are two distinct fields.

[Nikolaj]

@Steve Giller good point we don't use operational state for our assets. But in the report i use it is calling operational state. I cannot find just state in the table to use. second picture.

sorry for my bad explanation and confusion.

Nikolaj

 

 

 

[Steve Giller]

@Nikolaj I think the field you're looking for is h_record_state

[Nikolaj]

@Steve Giller Ok that make sense. Thank you very much.

now i have 1 (active) and 2( archive)