Service usage screen can tell you number of times service has executed but not the failure count or so. You can achieve this by enabling service level auditing from Developer for any particular service. If you have JDBC Pools configured for ISCoreAudit and auditstore is configured for db, this information can be found in WMSERVICE table of ISCoreAudit Pool.
In WMService table, there is column which shows the count, but I think we can get the count information from Status Codes.
I didn’t understand what exactly the codes stands for. where can I get the information about status codes. do we have any document for that. as per my knowledge I searched all the pdfs available, but they are of no use.