Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with System monitor v5.1.23

Hello all,

I have a slight problem with System monitor.

When I reload the application, I get this error message:

Table not found

Master:

Load *,

NoOfRows('OSLogs') AS OSTableFieldCount,

If('' < 1 , '1', '2') AS TESTSingle,

IF(TypeofLog = 'Audit', RGB(42,166,8),

IF(TypeofLog = 'DSC', RGB(0,205,115),

IF(TypeofLog = 'Events', RGB(150,237,137),

IF(TypeofLog = 'HTTPERR', RGB(44,186,234),

If(TypeofLog = 'IIS', RGB(85,221,255),

IF(TypeofLog = 'Performance', RGB(170,215,217),

IF(TypeofLog = 'Pub' , RGB(192,170,192),

IF(TypeofLog = 'QMS', RGB(255,127,0),

IF(TypeofLog = 'Session', RGB(230,159,75),

IF(TypeofLog = 'Webserver', RGB(255,200,135),

IF(TypeofLog = 'Windows - App', RGB(255,255,204),

IF(TypeofLog = 'Windows - Sec', RGB(255,245,141),

IF(TypeofLog = 'Windows - Sys', RGB(255,100,85),

IF(TypeofLog = 'Restart', RGB(0,0,0),

IF(TypeofLog = 'Salesforce', RGB(131,198,238),

IF(TypeofLog = 'SAP', RGB(178,245,54),

IF(TypeofLog = 'Offline', RGB(51,0,51),''

                ))))))))))))))))) AS 'Color1',

               

IF(TypeofLog = 'Pub' AND Sev = 'Failed' OR Sev = 'Error', LightRed(),

IF(Sev = 'Warning', RGB(212,104,18),

IF(TypeofLog = 'Audit', RGB(42,166,8),

IF(TypeofLog = 'DSC', RGB(0,205,115),

IF(TypeofLog = 'Events', RGB(150,237,137),

IF(TypeofLog = 'HTTPERR', RGB(44,186,234),

If(TypeofLog = 'IIS', RGB(85,221,255),

IF(TypeofLog = 'Performance', RGB(170,215,217),

IF(TypeofLog = 'Pub' , RGB(192,170,192),

IF(TypeofLog = 'QMS', RGB(255,127,0),

IF(TypeofLog = 'Session', RGB(230,159,75),

IF(TypeofLog = 'Webserver', RGB(255,200,135),

IF(TypeofLog = 'Windows - App', RGB(255,255,204),

IF(TypeofLog = 'Windows - Sec', RGB(255,245,141),

IF(TypeofLog = 'Windows - Sys', RGB(255,100,85),

IF(TypeofLog = 'Restart', RGB(0,0,0),

IF(TypeofLog = 'Salesforce', RGB(131,198,238),

IF(TypeofLog = 'SAP', RGB(178,245,54),

IF(TypeofLog = 'Offline', RGB(51,0,51),''

                ))))))))))))))))))) AS 'Color2',

If(TypeofLog = 'Restart', White()) AS 'Color3'

Resident MasterTemp

Order by TypeofLog asc

Do you know why is that occurring?

Thanks in advance

0 Replies