| cd /home/backup-logs/jboss | Past log records related to web service |
| cd space .. | down level path |
| pwd | List currect path |
| ls | list file |
| cd /usr/local/jboss/server/production/log/musicstore | Latest up to date musicstore log |
| tail -f common.log | live log web service tracking |
| cd /usr/local/jboss/sever/production/log/MWap | Latest up to date MWap log |
| tail -f common.log | live log wap service tracking |
| grep "keyword()" filename | check filename |
| filename:comomn.log | frontend |
| filename:server.log | backend |
| SELECT TOP 1000 [RequestID] ,[SPTransactionID] ,[SPID] ,[Service] ,[Remark] ,[Status] ,[RecDate] FROM [MilkywayDB].[dbo].[RequestInfo] where Remark like '%97261091%' and RecDate between '2011-05-18 10:17:30.467' and '2011-06-11 10:17:30.467' | TO check what the transaction status in GD end/ Atomic end:change the number and date accordingly |
| SELECT TOP 1000 [ZTEEventLogID] ,[Method] ,[InputParam] ,[ReturnCode] ,[ReturnDescription] ,[ReturnException] ,[MSISDN] ,[CreatedDate] FROM [MilkywayDB].[dbo].[ZTEEventLog] where MSISDN like '6597261091' and CreatedDate between '2011-01-11 01:23:21.053' and '2011-01-13 01:23:21.053' | To check what the transaction status in ZTE:change the number and date accordingly |
| SELECT [SubscriberID] ,[MSISDN] ,[MobileType] ,[Name] ,[Email] ,[Password] ,[IsValidFree] ,[IsValidReplace] ,[Status] ,[Remark] ,[CreatedBy] ,[CreatedDate] ,[ModifiedBy] ,[ModifiedDate] FROM [MilkywayDB].[dbo].[SubscriberInfo] where MSISDN like '%97261091%' | fixed line |
cron