• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 30 replies
  • Answers 1 answer
  • Subscribers 7 subscribers
  • Views 15272 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
    @brindas I think there is issue with DB script only as we are using mysql as backend so i'm not sure whether above script will work or not in case of oracle, but still check the below script and try it once again with both the datasoruce name as mentioned earlier and make lineNumber as primary key and autogenerated

    CREATE TABLE `logins` (
    `date` date NOT NULL,
    `time` time NOT NULL,
    `lineNumber` int(11) NOT NULL,
    `isValidLogin` smallint(1) NOT NULL,
    `username` varchar2(100) NOT NULL,
    `ipaddress` varchar2(20) NOT NULL,
    CONSTRAINT `unique` UNIQUE(`date`,`lineNumber`)
    )

    hope this will work.
Reply
  • 0
    @brindas I think there is issue with DB script only as we are using mysql as backend so i'm not sure whether above script will work or not in case of oracle, but still check the below script and try it once again with both the datasoruce name as mentioned earlier and make lineNumber as primary key and autogenerated

    CREATE TABLE `logins` (
    `date` date NOT NULL,
    `time` time NOT NULL,
    `lineNumber` int(11) NOT NULL,
    `isValidLogin` smallint(1) NOT NULL,
    `username` varchar2(100) NOT NULL,
    `ipaddress` varchar2(20) NOT NULL,
    CONSTRAINT `unique` UNIQUE(`date`,`lineNumber`)
    )

    hope this will work.
Children
No Data

© 2024 Appian. All rights reserved.