IT Management Suite

Hi All , 

After Upgrade of SMP from 7.1 to 7.5 we are getting Blank Real-Time Console Infrastructure Automation policy email generated 

Please find the email as below

Date:        10-10-14 09:00 AM
Subject:        RTCI Remote Access Purge policy

Symantec_TM
Automation Policy Message

Real-Time Console Infrastructure was processed with following results:

We can disbaled the automatcion policy created but need to know why its blank after upgrade 

Thanks 

SVR

This automation policy uses Query and gets data from "Evt_RTCI_Audit_Event" SQL table.

Make sure that this SQL table has data.

declare @TotalEvents int, @LeftEvents int, @DeletedEvents int,
    @TotalRes int, @LeftRes int, @DeletedRes int
                        
set @TotalEvents   = (select count(*) from Evt_RTCI_Audit_Event)
set @DeletedEvents = (select count(*) from Evt_RTCI_Audit_Event where datediff(day,Time,getdate()) > %Days%)

delete from Evt_RTCI_Audit_Event where datediff(day,Time,getdate()) > %Days%
set @LeftEvents = (select count(*) from Evt_RTCI_Audit_Event)
set @TotalRes   = (select count(*) from ItemResourceType where ResourceTypeGuid = '{677F5BD0-3B11-4136-ADBA-FD68BD3562F7}')
set @DeletedRes = (select count(*) from ItemResourceType ir inner join Item i on ir.Guid = i.Guid where ir.ResourceTypeGuid = '{677F5BD0-3B11-4136-ADBA-FD68BD3562F7}' AND datediff(day,i.ModifiedDate,getdate()) > %Days%)

delete from Item where Guid in (select i.Guid from ItemResourceType ir inner join Item i on ir.Guid = i.Guid where ir.ResourceTypeGuid = '{677F5BD0-3B11-4136-ADBA-FD68BD3562F7}' AND datediff(day,i.ModifiedDate,getdate()) > %Days%)
set @LeftRes = (select count(*) from ItemResourceType where ResourceTypeGuid = '{677F5BD0-3B11-4136-ADBA-FD68BD3562F7}')

DECLARE @NTotEvents nvarchar(64)
       ,@NLftEvents nvarchar(64)
       ,@NDelEvents nvarchar(64)
       ,@NTotTmpRes nvarchar(64)
       ,@NLefTmpRes nvarchar(64)
       ,@NDelTmpRes nvarchar(64)
       ,@sQuery     nvarchar(1024)

SELECT @NTotEvents = ISNULL( dbo.fnLocalizeString( 'Total Events', '64A23C09-DEBA-4A1E-BEB5-BEDCB3C5E361', '%_culture%' ), 'Total Events' ),
       @NLftEvents = ISNULL( dbo.fnLocalizeString( 'Left Events', '64A23C09-DEBA-4A1E-BEB5-BEDCB3C5E361', '%_culture%' ), 'Left Events' ),
       @NDelEvents = ISNULL( dbo.fnLocalizeString( 'Deleted Events', '64A23C09-DEBA-4A1E-BEB5-BEDCB3C5E361', '%_culture%' ), 'Deleted Events' ),
       @NTotTmpRes = ISNULL( dbo.fnLocalizeString( 'Total Temporary Resources', '64A23C09-DEBA-4A1E-BEB5-BEDCB3C5E361', '%_culture%' ), 'Total Temporary Resources' ),
       @NLefTmpRes = ISNULL( dbo.fnLocalizeString( 'Left Temporary Resources', '64A23C09-DEBA-4A1E-BEB5-BEDCB3C5E361', '%_culture%' ), 'Left Temporary Resources' ),
       @NDelTmpRes = ISNULL( dbo.fnLocalizeString( 'Deleted Temporary Resources', '64A23C09-DEBA-4A1E-BEB5-BEDCB3C5E361', '%_culture%' ), 'Deleted Temporary Resources' )

SELECT @sQuery =
'SELECT ' + CAST(@TotalEvents AS nvarchar) + ' AS [' + @NTotEvents + '], '
          + CAST(@LeftEvents AS nvarchar) + ' AS [' + @NLftEvents + '], '
          + CAST(@DeletedEvents AS nvarchar) + ' AS [' + @NDelEvents + '], '
          + CAST(@TotalRes AS nvarchar) + ' AS [' + @NTotTmpRes + '], '
          + CAST(@LeftRes AS nvarchar) + ' AS [' + @NLefTmpRes + '], '
          + CAST(@DeletedRes AS nvarchar) + ' AS [' + @NDelTmpRes + ']'

EXEC (@sQuery)

And here are these RTCI purge settings

Thanks Igor , 

Is there any compatibility issue in 7.5 with Real-Time Console Infrastructure?

Any article about the configuration ?

Thanks SVR 

I don't think that there are compatibility issues with RTSM/RTCI product in 7.5 release. It should work.

If you will perform some actions from Real-Time page with client, then "Evt_RTCI_Audit_Event" SQL table will populate this event there and on next Automation policy execution, it should contain this data there in report.

I have article about how to use Real-Time WMI/SNMP connection from NS Server to client

https://www-secure.symantec.com/connect/articles/how-quickly-check-client-sma-logs-and-manage-client-within-smp-console

thanks alot Igor  

The article explains more on what is required

Thanks 
SVR