SQL: All Available SMP Reports - Cacher Snippet

2/10/2016 - 7:32 PM

SQL: All Available SMP Reports

SQL: All Available SMP Reports

smp_available_reports.sql

select
	[_ItemGuid] = [vri2_Resource].[Guid]
	, [Name] = [vri2_Resource].[Name]
	, [Link] = '/Altiris/Reporting/Report.aspx?ItemGuid=' + CAST([vri2_Resource].[Guid] AS varchar(max))
from [vItem] [vri2_Resource]
-- Altiris.Reporting.ReportManagementItem
where [vri2_Resource].[ClassGuid] = 'A968A2A6-C9B9-483B-B9E0-7F0B199F9DA3'
order by 2