"All Assets" report not displaying (Active) status
Article ID: 162097
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
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.
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.
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.
Feedback
Yes
No
Powered by
