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

book

Article ID: 170148

calendar_today

Updated On:

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".

Environment

Asset Management 8.1RU2

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) )