Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 30 replies
  • Answers 1 answer
  • Subscribers 6 subscribers
  • Views 22199 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

How to use Login Information Parser Plugin?

brindas1
Hi all,
How to use "Login Information Parser" plugin? I have added this plug in so that now it can be used as a smart service. I have created "logins" table which now exists in the data source. How can I get the login details of the users using this smart service and table? Can someone please explain the steps?

OriginalPostID-267857

  Discussion posts and replies are publicly visible

Parents
  • 0
    @mayureshs The script is as follows:

    CREATE TABLE "SAMPLE.BUSINESS"."logins"
    (          "id" NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOT NULL ENABLE,
              "date" DATE,
              "time" TIMESTAMP (9),
              "lineNumber" NUMBER(10,0),
              "isValidLogin" NUMBER(1,0),
              "username" VARCHAR2(100 CHAR),
              "ipaddress" VARCHAR2(20 CHAR),
               CONSTRAINT "SUPPLIER_UNIQUE" UNIQUE ("id", "lineNumber")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "USERS" ENABLE
    ) SEGMENT CREATION IMMEDIATE
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
    NOCOMPRESS LOGGING
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "USERS" ;
Reply
  • 0
    @mayureshs The script is as follows:

    CREATE TABLE "SAMPLE.BUSINESS"."logins"
    (          "id" NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOT NULL ENABLE,
              "date" DATE,
              "time" TIMESTAMP (9),
              "lineNumber" NUMBER(10,0),
              "isValidLogin" NUMBER(1,0),
              "username" VARCHAR2(100 CHAR),
              "ipaddress" VARCHAR2(20 CHAR),
               CONSTRAINT "SUPPLIER_UNIQUE" UNIQUE ("id", "lineNumber")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "USERS" ENABLE
    ) SEGMENT CREATION IMMEDIATE
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
    NOCOMPRESS LOGGING
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "USERS" ;
Children
No Data
© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.