search cancel

"All Assets" report not displaying (Active) status

book

Article ID: 162097

calendar_today

Updated On:

Products

IT Management Suite Asset Management Solution

Issue/Introduction

Altiris Console > Reports > All Reports > Notification Server Management > Server > Resource Reports > All Assets.

Cosmetic issue, (Active) status is not displayed, and shown as blank. NA

Cause

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

Resolution

This cosmetic issue will be addressed in a future release.

As a work around, the report can be edited as following: NB. (no I8n)
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.