"Assets by Type, Status, Department, Cost Center and Location" report, does not retrieve data if "Asset Status" is set to "Active"
The SQL query filter does not respect "no asset status association means Active".
Asset Management 8.1RU2
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) )