Server Management Suite

Hi,

I need to Schedule a Report in the Symantec Management Console.

In this Report there should be the following Info: PCName, BackupStatus, And if there is an error, the reason for this error.

Something like this:

                DECLARE @v1_TrusteeScope AS NVARCHAR(MAX)
          SET @v1_TrusteeScope='%TrusteeScope%'
          SELECT    i.[Name], i.[Domain], i.[OS Name] AS 'Operating System Name', i.[System Type],   
                        CASE state.[ComputerAlertLevel]

WHEN -1 THEN dbo.fnLocalizeStringByGuid('Unknown', 'ECEC63F2-1F35-48a7-836E-B5272538D9D4', '%_culture%')
WHEN 0 THEN dbo.fnLocalizeStringByGuid('Backed Up', 'ECEC63F2-1F35-48a7-836E-B5272538D9D4', '%_culture%')
WHEN 1 THEN dbo.fnLocalizeStringByGuid('Backed Up', 'ECEC63F2-1F35-48a7-836E-B5272538D9D4', '%_culture%')
WHEN 2 THEN dbo.fnLocalizeStringByGuid('Attention Needed', 'ECEC63F2-1F35-48a7-836E-B5272538D9D4', '%_culture%')
WHEN 3 THEN dbo.fnLocalizeStringByGuid('At Risk', 'ECEC63F2-1F35-48a7-836E-B5272538D9D4', '%_culture%')
                        END AS 'Computer Backup Status'

FROM    vComputerResource AS r 
                    INNER JOIN fnGetTrusteeScopedResources(@v1_TrusteeScope) AS sc on r.Guid=sc.ResourceGuid
                    INNER JOIN Inv_AeX_AC_Client_Agent AS c ON r.[Guid] = c.[_ResourceGuid]  
                    INNER JOIN Inv_AeX_AC_Identification AS i ON i.[_ResourceGuid] = r.[Guid]  
                    INNER JOIN Inv_BESR_Configuration AS besrConfig ON besrConfig.[_ResourceGuid] = r.Guid  
                    INNER JOIN Inv_BESR_ComputerState AS state ON state.[_ResourceGuid] = r.[Guid] 
                    AND (c.[Ident] = 'Symantec.BackupAgent' OR c.[Ident] = 'BESRLTASKHANDLER')
                    AND r.[IsManaged] = 1 
                    AND ( besrConfig.ProductVersion LIKE '9.0%' OR besrConfig.ProductVersion LIKE '10.0%' OR besrConfig.ProductVersion LIKE '11.0%' OR besrConfig.ProductVersion LIKE '2.0%' OR besrConfig.ProductVersion LIKE '3.0%' )
                ORDER BY state.[ComputerAlertLevel]      

but without the succesfull maschines.

Regards

Dragoro

So that query returns data which contains OK machines as well as machines that have issues, yes?

If that is the case, then simply find the table and column that clearly identifies OK machines, and then add a where clause that excludes OK machines. 

where blah not like '%blah%'

Then pop that into a report and schedule it.