How to use Login Information Parser Plugin?

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
  • @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
  • @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