Add comment field to a custom Altiris report
I am trying to create a somewhat custom Altiris report. It is based off of the "General Assets" report that comes with the software. We want to track all assets entered into Altiris and do not want to focus on certain types of assets, e.g. computers, network resources, cell phones etc so this report is perfect. I cloned the report, deleted the last barcode scan because it is irrelevant for our needs, and would like to add the comment field for all assets. Is there a way to do this? I have been scouring the internet and seem to be the only one who would like to do this. Pasted below is the SQL code from the current iteration of the report. Any help or insight would be greatly appreciated.
declare @_culture varchar(20)
set @_culture = '%_culture%'
declare @BaseResourceTypeGuid uniqueidentifier
set @BaseResourceTypeGuid = '%BaseResourceTypeGuid%'
DECLARE @TrusteeScope nvarchar(max)
SET @TrusteeScope = '%TrusteeScope%'
declare @ActiveString nvarchar(20)
select @ActiveString = String from vStringCache where BaseGuid = '0A0203A5-D2B6-49F1-A53B-5EC31A89437C' and StringRef = 'item.name' and Culture = @_culture
i.Guid as _ItemGuid,
strAssetType.[String] as [Asset Type],
isnull(strAssetStatus.[String], @ActiveString) [Asset Status],
from vAsset va
join vRM_Asset_Item i on va._ResourceGuid = i.Guid
join ResourceTypeHierarchy rh on rh.ResourceTypeGuid = va._ResourceTypeGuid
select top 1 String
from StringCache where BaseGuid = va._AssetStatusGuid and Culture = @_culture and StringRef = 'item.name'
select top 1 String
from StringCache where StringRef='item.name' and Culture=@_culture and BaseGuid = va._ResourceTypeGuid
1 = 1
and ((@BaseResourceTypeGuid = '00000000-0000-0000-0000-000000000000' AND rh.BaseResourceTypeGuid = rh.ResourceTypeGuid) OR (@BaseResourceTypeGuid = rh.BaseResourceTypeGuid))
and (i.[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@TrusteeScope))))