"Assets by Type, Status, Department, Cost Center and Location" report not filtering by (Active) status

Article Id: 170148

Status: Published

Updated On: 02-10-2017 01:37

Legacy Id: TECH247590

Products:

Asset Management Solution

Issue/Introduction:

"Assets by Type, Status, Department, Cost Center and Location" report, does not retrieve data if "Asset Status" is set to "Active"

Cause:

The SQL query filter does not respect "no asset status association means Active".

Resolution:

Symantec is aware of this issue, which fix is targeted to Asset Management 8.5.

Affected reports (same fix applies):

```
Asset Search
```

Assets by Type, Status, Department, Cost Center, Location

```
All Assets
```
```
Departments by Location and Cost Center
```

As a temporary solutions, apply the following steps:
- Clone the report (right click on the report, Clone), then edit report's SQL query as following:
Change:
(@AssetStatus = '00000000-0000-0000-0000-000000000000' OR @AssetStatus = rStatus.ChildResourceGuid)
to:
(@AssetStatus = '00000000-0000-0000-0000-000000000000' OR @AssetStatus = rStatus.ChildResourceGuid
OR (@AssetStatus = '0A0203A5-D2B6-49F1-A53B-5EC31A89437C' AND rStatus.ChildResourceGuid is NULL) )