"All Assets" report is not displaying "Active" status

Products

• IT Management Suite
• Asset Management Solution

Issue/Introduction

In the SMP Console under Reports > All Reports > Notification Server Management > Server > Resource Reports > All Assets, the "Active" status is now displayed and is showing nothing, it is blank.

Environment

ITMS 8.x

Asset Mangement 8.x

Cause

Cosmetic issue. By default if there is not association with "Asset Status", it means the asset is active. Reports get the status from [vAsset] view which handles that conversion.

Resolution

This was fixed but in the event it is seen again the following workaround is available.  The report can be edited:

1. Right click the report and clone it.
2. Open the cloned report and click on edit.
3. click "Convert this query to SQL query" (in the up right conrener of the edit page of the report.)
4. Replace the line "[vri6_Fixed Asset Status Resource Type].[Name] AS [Status]," with the below line:
        "isnull([vri6_Fixed Asset Status Resource Type].[Name], 'Active') AS [Status]"
5. Click save, now the report will show "Active" status.