Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
select gla.COMPANY, gla.FISCAL_YEAR, -- '' AS BUDFY, gla.ACCT_UNIT, gla.ACCOUNT, gla.SUB_ACCOUNT, gla.DB_AMOUNT_01 + gla.CR_AMOUNT_01 GLAMONTH1, gla.DB_AMOUNT_02 + gla.CR_AMOUNT_02 GLAMOUNT2, gla.DB_AMOUNT_03 + gla.CR_AMOUNT_03 GLAMONTH3, gla.DB_AMOUNT_04 + gla.CR_AMOUNT_04 GLAMONTH4, gla.DB_AMOUNT_05 + gla.CR_AMOUNT_05 GLAMONTH5, gla.DB_AMOUNT_06 + gla.CR_AMOUNT_06 GLAMONTH6, gla.DB_AMOUNT_07 + gla.CR_AMOUNT_07 GLAMONTH7, gla.DB_AMOUNT_08 + gla.CR_AMOUNT_08 GLAMONTH8, gla.DB_AMOUNT_09 + gla.CR_AMOUNT_09 GLAMONTH9, gla.DB_AMOUNT_10 + gla.CR_AMOUNT_10 GLAMONTH10, gla.DB_AMOUNT_11 + gla.CR_AMOUNT_11 GLAMONTH11, gla.DB_AMOUNT_12 + gla.CR_AMOUNT_12 GLAMONTH12, '' BUDMONTH1, '' BUDMONTH2, '' BUDMONTH3, '' BUDMONTH4, '' BUDMONTH5, '' BUDMONTH6, '' BUDMONTH7, '' BUDMONTH8, '' BUDMONTH9, '' BUDMONTH10, '' BUDMONTH11, '' BUDMONTH12 from GLAMOUNTS gla where gla.ACCT_UNIT = 01000 and gla.ACCOUNT in (6050,6060) union select fbd.COMPANY, -- '' AS GLFY, fbd.FISCAL_YEAR, fbd.ACCT_UNIT, fbd.ACCOUNT, fbd.SUB_ACCOUNT, '' GLAMONTH1, '' GLAMONTH2, '' GLAMONTH3, '' GLAMONTH4, '' GLAMONTH5, '' GLAMONTH6, '' GLAMONTH7, '' GLAMONTH8, '' GLAMONTH9, '' GLAMONTH10, '' GLAMONTH11, '' GLAMONTH12, fbd.DB_AMOUNT_01 + fbd.CR_AMOUNT_01 BUDMONTH1, fbd.DB_AMOUNT_02 + fbd.CR_AMOUNT_02 BUDMOUNT2, fbd.DB_AMOUNT_03 + fbd.CR_AMOUNT_03 BUDMONTH3, fbd.DB_AMOUNT_04 + fbd.CR_AMOUNT_04 BUDMONTH4, fbd.DB_AMOUNT_05 + fbd.CR_AMOUNT_05 BUDMONTH5, fbd.DB_AMOUNT_06 + fbd.CR_AMOUNT_06 BUDMONTH6, fbd.DB_AMOUNT_07 + fbd.CR_AMOUNT_07 BUDMONTH7, fbd.DB_AMOUNT_08 + fbd.CR_AMOUNT_08 BUDMONTH8, fbd.DB_AMOUNT_09 + fbd.CR_AMOUNT_09 BUDMONTH9, fbd.DB_AMOUNT_10 + fbd.CR_AMOUNT_10 BUDMONTH10, fbd.DB_AMOUNT_11 + fbd.CR_AMOUNT_11 BUDMONTH11, fbd.DB_AMOUNT_12 + fbd.CR_AMOUNT_12 BUDMONTH12 from FBDETAIL fbd where fbd.ACCT_UNIT = 01000 and fbd.ACCOUNT in (6050,6060)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.