Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT count( *) TestCount,asset FROM table_name group by asset
- TestCount Asset
- 18 DB2MOTIV:DBMOTIVA@mxemch010405ads.mx.hsbc
- 18 IBASL01:BASL01@gbl05823.systems.uk.hsbc
- 17 ICOGP01:ITSCOG01@htng-icogp01.de.hsbc
- 18 ICTIP01:CTIP01@arp617fuc3db.ar.hsbc
- 18 IPSSP01:PSSP01@arp498fuc1db.ar.hsbc
- 16 IMXGP01:ITSMXG01@htng-imxgp01.de.hsbc
- 19 IINFP01:INFP01@gbl10805.systems.uk.hsbc
- 9 IHF4P01:HF4P01@mxcl0030006-dbai.mx.hsbc
- 19 IHQAL01:HQAL02@gbl07664.systems.uk.hsbc
- SELECT count( *) TestPassedCount,asset FROM hsbc_csmip_dbprotect where result_status = 'Not A Finding' group by asset
- TestPassedCount Asset
- 7 DB2MOTIV:DBMOTIVA@mxemch010405ads.mx.hsbc
- 16 IBASL01:BASL01@gbl05823.systems.uk.hsbc
- 11 ICOGP01:ITSCOG01@htng-icogp01.de.hsbc
- 10 ICTIP01:CTIP01@arp617fuc3db.ar.hsbc
- 11 IPSSP01:PSSP01@arp498fuc1db.ar.hsbc
- 9 IMXGP01:ITSMXG01@htng-imxgp01.de.hsbc
- 17 IINFP01:INFP01@gbl10805.systems.uk.hsbc
- 9 IHF4P01:HF4P01@mxcl0030006-dbai.mx.hsbc
- 18 IHQAL01:HQAL02@gbl07664.systems.uk.hsbc
- TestCount TestPassedCount Asset
- 18 7 DB2MOTIV:DBMOTIVA@mxemch010405ads.mx.hsbc
- 18 16 IBASL01:BASL01@gbl05823.systems.uk.hsbc
- 17 11 ICOGP01:ITSCOG01@htng-icogp01.de.hsbc
- 18 10 ICTIP01:CTIP01@arp617fuc3db.ar.hsbc
- 18 11 IPSSP01:PSSP01@arp498fuc1db.ar.hsbc
- 16 9 IMXGP01:ITSMXG01@htng-imxgp01.de.hsbc
- 19 17 IINFP01:INFP01@gbl10805.systems.uk.hsbc
- 9 9 IHF4P01:HF4P01@mxcl0030006-dbai.mx.hsbc
- 19 18 IHQAL01:HQAL02@gbl07664.systems.uk.hsbc
Add Comment
Please, Sign In to add comment